Data and Tables in Access

Fundamental

Get started with Access 2016 by learning the fundamentals of database features. This class will explore how to use Access efficiently and introduce you to the concepts of good Relational Database design. It’s a maxim that all data is stored in Tables in Access, but not all Tables are equal. …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.

Queries in Access

Intermediate

Understanding Queries in Access 2016 begins with learning how to ask simple questions about your data, like “how many?” and “which ones?” As you explore topics like relationships and referential integrity, however, you’ll learn how to select, update and delete records using queries. This class will also introduce you to …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.

Forms in Access

Intermediate

Access 2016 uses a special object type called Forms to represent data visually on screen. Forms are a great method to add exciting front-end user functionality to boring databases and offer ways to protect your data from well-intentioned mistakes. Starting with simple forms and the Forms Wizard, you will quickly …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.

Reports in Access

Intermediate

Reports give you the ability to aggregate the data you are interested in and print it out in creative and professional looking documents. You will start with form letters, but quickly move to adding charts and graphs based on your data. You will also learn the tips and tricks to …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.

Modules and Macros in Access

Advanced

Every good database designer needs a tool belt with lots of tricks, and Macros are the 5-star tool you need to automate repetitive tasks. You will be introduced to writing Macros using the Visual Basic Editor and learn how to use Temporary variables and constants, as well as how to …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.