Skill Level: Advanced
The traditional definition of a database is a collection of related data organized into fields, records and tables that has been created for a particular purpose. A Microsoft Access database not only consists of data, fields, records, and tables but also includes those queries and reports created as a result of manipulating those fields, records, and tables. As such Microsoft Access is more than a tool used to store data - it is a complete database management system (DBMS).
This class is designed to pick up where our Microsoft Access Level 1 course ended. We will begin with a quick review of our database rules and structure. We will continue to work with Relational Database Tables and Queries. We learn how to design more in depth Relational Tables, Queries, Command Button and more!
Some of the things you will learn in this class:
- Correct Database Structure
- Configuring Relationships between Tables & Queries
- Append, Update and Delete Queries
- Crosstab Queries
- Make Table Queries
- Importing & Exporting database information
- Command Buttons
- And more!
Scheduled Classes:
Click here to view the Calendar for a complete class schedule.
All classes are 1 day classes, held during the day (9:00am-3:30pm) unless otherwise noted.
Cost of Class: $160.00