 |
Corporate
portraits |
|
|
|
|
| Expertly
tailored Microsoft Office training courses: Brighton,
Worthing, Portsmouth, Chichester, Sussex, Surrey and London
|
 |
Microsoft
Access Beginners Course (1 day) |
|
 |
Microsoft
Access Beginners Course Overview |
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.
For pricing click
here
To return to the applicationl
overview page click
here
|
|
|
| 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
|
|
|
|
|
| |
|
|