This document introduces users to more advanced functions of Microsoft Access. Participants will learn how to change join types of queries and build more advanced queries, such as action queries. They will learn how to create reports based off SQL statements and automate a database with macros. They will also learn how to run the repair and compact utility. It is used in conjunction with the Access: Advanced workshop. Introduction Microsoft Access 2000 is a relational database management system. This type of database allows a user to store, retrieve, manage and analyze data quickly and effectively. This particular handout, in conjunction with the Access Advanced class, is designed to help users with some of the more advanced features of Access, such as query join types, advanced types of queries, SQL reports, automating a database with macros, and compacting a database.