MS Access Advanced Book

Click Here To Download Book
Pages 18
Views 898
Size 518.1 KB
Download 40

Microsoft Access 2000 is a relational database management system. This sort of database allows a person to store, retrieve, manage and analyze data quickly and effectively. This particular handout, along with the Access Advanced class, is made to help users with some of the more advanced features of Access, such as for instance query join types, advanced forms of queries, SQL reports, automating a database with macros and compacting a database.

The goal with this workshop is to introduce participants to more advanced objects and ideas in Microsoft Access. After today’s workshop, participants will be able to:

Microsoft Access 2000 Features

Understand and change query join types

Create and run parameter queries

Create and edit the four forms of action queries

Create and edit reports based on SQL

Create and execute macros

Run the compact utility on a database