Presentation Style: Tutor-led Classroom
Duration: 1 Day
Course Time: 09:30 - 16:30hrs
Course Location: Northampton
Cost: Public Courses: £285 + VAT per delegate, £260 each + VAT for two delegates on the same day (call for group discounts)
Closed Courses: please enquire
Click a date to book: Call 01604 655900 for available dates

 

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