Microsoft Access

Modules and Macros in Access

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

Reports in Access

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

Forms in Access

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

Queries in Access

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

Data and Tables in Access

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