catraining

 

Microsoft Partner
Microsoft Access 2016 Modules

Audience: The content of this course is intended to be tailored to meet your specific requirements, To provide some ideas of possible course content,we have listed below example topic modules, and would recommend combining the content of four of the modules. We are happy to arrange for a trainer to contact you to help tailor your course.

Course Duration: Half day module to be combined with any other half day module in the Microsoft Office suite.

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Access 2016 Module training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

 

 

After completing this course, students will be able to:
  • Work with Access in line with the agreed course aimsreaining course

Possible Course Content - Select 4 Modules (or discuss with our team your individual requirements)

print this page
Planning a Microsoft Access Relational Database
  • Creating tables
  • Using Quick Start fields
  • Setting field properties
  • Setting the primary key
  • Defining relationships
  • Setting referential integrity
  • Creating lookups
  • Creating calculated fields

Working with Forms

  • Creating a form with the Form Wizard
  • Editing a form
  • Opening a form
  • Adding, editing and deleting records
  • Find and replace records
  • Filtering data in a form

Introduction to Select Queries

  • Select queries explained
  • Creating select queries
  • Working with query views
  • Adding and deleting fields
  • Sorting records in the Design View
  • Using query criteria
  • Adding calculated fields

Designing Advanced Queries

  • Setting join types between tables and queries
  • Setting top values in a query
  • Creating Calculated fields
  • Creating Summary queries
  • Grouping queries
  • Creating Parameter queries

Action Queries

  • Update Query
  • Make Table Query
  • Delete Query
  • Append Query
  • Union Query
  • Find duplicates query
  • Find unmatched query
Working in Form Design View
  • Manipulating controls in form design view
  • Changing form and control properties
  • Adding controls to a form
  • List boxes, Check boxes and Option buttons etc.
  • Using calculations on forms
  • Tabular forms
  • Using Conditional formatting

Working in Report Design View

  • Manipulating controls in a report
  • Changing report control properties
  • Managing, sorting and grouping in reports
  • Adding calculations to a report
  • Controlling pagination

Importing and Exporting Access Data

  • Importing a spreadsheet from Excel
  • Linking data tables to an Access database
  • Export a table to Excel and text files
  • Exporting reports
  • Export to HTML format
  • Export linked data source information to Excel (new)

Access Macros

  • Developing macros with Macro Designer
  • Triggering data macros
  • Running a macro
  • Attaching a macro to a command button
  • Running a macro from field properties
  • Creating conditional macros
  • Using sub macrosMicrosoft

Call us now for further information Tel:08001601666