Microsoft Access Beginners

Sponsored links

This course is suitable for complete beginners or occasional user of Microsoft Access. The training will give delegates introduction to four main object types in Microsoft Access: tables, queries, forms and reports.

To accompany the instructor lead training, each delegate will receive manuals and practice, step-by-step exercises. This will provide an excellent source of information and on-going self study once the training has been completed. Alternatively a more complete self study package can be purchased from our e-learning catalogue.

Delivery:
  • In house
Category:

Further Details

Introduction to Access
Overview of object types - tables, queries, forms and reports
Naming conventions



Tables
Fields and records
Data types
Field properties
Lookup fields
Data entry
Formatting data tables
Hiding columns
Freezing columns
Filter by selection
Filter by form
Importing tables from Excel
Linking Excel tables



Queries
The QBE grid
Adding fields to your query
Adding criteria to your query
AND criteria
OR criteria
Sorting a query



Forms
Creating forms using the form creation wizard
Designing your form
Formatting and placement of form controls



Reports
Creating reports using the report creationg wizard
Designing your report
Formatting and placement of report controls


This Training Course is offered "in house" at the following locations:
Brighton

Guide Price: £450 per group of 8 delegates