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

 

What will you learn on this 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 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 (only for courses held at Paradise Training Centre)
  • Joining instructions will be sent prior to attending the course