Access Foundation

Sorry, there are currently no dates scheduled for this course.

Course outline

Day 1

Getting to know Access 2003
Open an existing database; Open tables in different views; Open and run queries; Open a form in different views; Open a report in different views
Creating a new database
Create a new database structure using a wizard; Check the work of the wizard; Create an empty database, and add tables using a wizard; Refine the way your data is displayed; Manipulate columns and rows in tables
Getting information into and out of a database
Import information from various programs and from other Access databases; Export information to other programs; Link database content to other databases
Simplifying data entry with forms
Create a form using a wizard; Refine the properties and layout of a form; Add controls and VBA code that help enter data; Create a form using AutoForm; Create a form based on more than one table
Smart Tags
Context sensitive buttons to choose different options

Day 2

Locating specific information
Sort information on one or more fields; Filter information in various ways; Create queries that find information in one or more tables; Create a query to perform calculations
Keeping your information accurate
Restrict the information entered in a database using the data type; Restrict the information entered in a database using various filed properties; Update information in a table; Delete information from a table
Working with reports
Create a report using a wizard; Modify a report; Create a report from scratch; Add a subreport to a report; Preview and print a report
Making it easy for others to use your database
Create a switchboard for easy access to forms and reports; Create a splash screen to convey useful information; Set startup options to control what users can do; Keep your database application in good repair