System IT - Microsoft Access 2007 - Intermediate (1 Day)
Price:Please call for latest pricing
Course duration: 1 Day
Available Course Dates:
Prerequisites:
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.
Course Details:
Course duration: 1 Day
Available Course Dates:
Prerequisites:
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.
Course Details:
Description: 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
