Microsoft Access Foundation

Dorset based half-day Training Course

Basepoint-Meeting room

How to

Who is this course designed for?

For new users of the Access database. During this course you will learn the basic Access skills needed to enter information, in setting up a single table flat file database. You will be shown how to run queries to retrieve information and produce reports.

Price: £99 + VAT

Contact Us:

01202 788277

Next Date: TBA

Click here to book

About your Trainer: Claire

What is in the Course?

  • Introduction to databases: overview of the database window; understanding database components: tables, forms, queries and reports; using help
  • Entering data: entering data in datasheet view; using different views; defining field names and data types; using a data entry form; creating new records; understanding primary key
  • Working with data: finding and replacing data; sorting and filtering data; working with data entry errors; spell checking; formatting data
  • Creating simple queries: creating a simple query; sorting data alphanumerically; filtering and setting single criteria; running and saving queries
  • Creating simple reports: identify reports which meet information requirements; using menus, wizards and shortcuts

What are the Course Outcomes?

To use a range of basic Access tools to input and edit information. You will learn how to:

  • enter, edit and organise structured information
  • use tools to extract information and produce reports