MS Access Level 2
Course Description
Access Level 2 is designed for the student who wishes to learn intermediate level operations of the Access programme. It is designed for those whose job responsibilities include creating new databases, tables and relationships, as well as working with and revising intermediate level queries, forms and reports. It also introduces the student to integrating Access data with other applications such as MS Word and ExcelDuration: 1 day
Planning a Database
Design a relational databaseIdentify the database’s purpose
Review existing data
Determine fields
Group fields into tables
Normalize the data
Set primary and foreign keys
Building a Database
Create a new databaseCreate a table using a wizard
Create tables in design view
Create relationships
Controlling Data Entry
Restrict data entryCreate an input mask
Create a lookup field
Finding and Joining Data
Find data with filtersCreate query joins
Join unrelated tables
Relate data within a table
Create Flexible Queries
Set SELECT query propertiesCreate parameter queries
Improving your Forms
Enhance the appearance of formsRestrict data entry in forms
Add a Command button
Create a sub-Form