Microsoft Access Intermediate
Sponsored links
This course is suitable for regular users of Microsoft Access or those who have a good knowledge of the topics covered at the beginner's level Microsoft Access course. The training provides an overview of advanced queries and table relationships.
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: |
Further Details
Advanced Queries
Revision of select queries as covered at the beginner's level
Parameter queries
Wildcard queries
Calculated queries
Concatenation queries
Null queries
Cross-tab queries
Delete queries
Make table queries
Update queries
Append queries
Building Relationships Between Tables
Primary keys
Foreign keys
One-to-one relationships
One-to-many relationships
Many-to-many relationships
Referential integrity
Cascade update
Cascade delete
Lookups
Forms
Creating muti-table forms
Reports
Creating multi-table reports
This Training Course is offered "in house" at the following locations:
Brighton
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
