MS Access Level 1
Course Description
This course is designed for students who wish to learn the basic operations of MS Access to perform their day-to-day responsibilities, and to understand the advantages that using a relational database programme can bring to their business processes. The level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applicationsDuration: 1 day
An overview of Access
Understanding relational databasesExamine the Access environment
Open the database environement
Examine an Access table
Managing Data
Examine an Access formAdd and delete records
Sort records
Display record sets
Update records
Run a report
Establishing Table Relationships
Identify table relationshipsPrimary and foreign keys
Work with sub-data sheets
Querying the Database
Create a SELECT queryAdd criteria to a query
Add a calculated field to a query
Perform a calculation on a record group
Designing Forms
Examine form design guidelingsCreate a form using AutoForm
Create a form using the form wizard
Modify the design of a form
Producing Reports
Create an AutoReportCreate a report using the wizard
Examine a report in design view
Add a calculated field to a report
Modify the format properties of a Control
AutoFormat a report
Adjust the width of a report