Presentation Style: Tutor-led Classroom
Duration: 2 Days
Course Time: 09:30 - 16:30hrs
Course Location: Northampton
Cost: Public Courses: £480 + VAT per delegate (call for group discounts)
Closed Courses: please enquire
Click a date to book: No upcoming courses

 

What will you learn on this Microsoft Access Training Course?

By the end of this course delegates will have gained skills in understanding the design techniques involved in building a database as well as how to create tables, input forms, queries and basic reports.

 

Course Content

Module One:

Database concepts and terminology, ground rules for database design, getting started in Microsoft Access, getting help

Module Two:

Creating a table in design view, data types, indexes, default values, validation rules, input masks, setting a primary key

Module Three:

Adding and editing data, navigating, adding, editing and deleting records, finding and replacing data, sorting and filtering records, filtering by selection

Module Four:

Understanding forms, creating forms, customising forms

Module Five:

Understanding queries, creating a select query, refining the results of a query, multi-table queries, setting basic criteria

Module Six:

Importing Microsoft Excel spread-sheets, Exporting data to Microsoft Excel and Microsoft Word

Module Seven:

Relationship concepts

 

Additional Information

  • Buffet lunch included and free parking (for courses held at Paradise Training Centre)
  • Joining instructions will be sent prior to attending the course