Microsoft Access 2007 - Intermediate
Short course
In Carlisle
Description
-
Type
Short course
-
Location
Carlisle
-
Duration
1 Day
Facilities
Location
Start date
Start date
About this course
Course delegates would be expected to have basic IT skills and have used Access at least in a data input role. They would also need to understand the basic concepts of a database i.e. tables, records and fields.
Reviews
Subjects
- Microsoft Access
Course programme
Course Content
This one day course covers the following topics:-
Advanced queries:
Sum, Count, Group By, Average Values, Maximum and Minimum Values, Calculated Fields in Queries and Parameter queries
Relationships:
Applying a Primary Key, Applying Relationships, Referential Integrity, Updating and Deleting records and Viewing a Subdatasheet
Table Field Properties:
Lookup fields, Format Field Properties, Default Values, Validation Rules and Text, Input Masks, Other Field Properties and Autonumber
Advanced Forms:
Main/Subforms Form Wizard, Main/Subform Subform Wizard and Multiple Table Forms
Microsoft Access 2007 - Intermediate