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
Guide price
£450 per group of 8 delegates |
