Microsoft Access

Learn how to do the following with Microsoft Access:

Creating Databases and Tables

This course acquaints the new user with the standard features of Access. It includes planning the database and tables; creating tables; modifying fields in a table; adding, editing, and formatting data; sorting; searching for data with the find feature; and printing data.

Queries

This course assumes that the Creating Databases and Tables course was taken, or that the user is sufficiently familiar with the features covered in that course. It discusses table relationships and demonstrates how to create them. The set up of queries manually, and the use of wizards is covered. Queries will be used to sort, and select records in the database tables.

Forms

This course assumes that the Creating Databases and Tables, and the Queries courses were taken, or that the user is sufficiently familiar with the features covered in those courses. The creation and the modification of forms are covered. Forms are used for viewing, inputting, and editing data.

Reports

This course assumes that the Creating Databases and Tables, Queries and Forms courses were taken, or that the user is sufficiently familiar with the features covered in those courses. The creation and the modification of printed reports are covered. Reports are created with wizards and customized. Standard reports are produced for all records, summaries or records, and mailing labels.

Converting Filemaker Lists

There are many lists that have, in the past, been maintained in different versions of FileMaker. The FileMaker program has many limitations and Access has become the standard database among the desktop applications. Access has greater capacity, power, and flexibility, and is much more compatible when integrating with other programs, particularly in the MS Office Suite. This course shows how to export existing lists from FileMaker, and then import them into MS Access.