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: |
|
| Category: |
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
