PC/Windows Users: Access 2010-2013-2016-365
Version Used in Class: Access 2016
Course Materials: FREE
Certificate of Completion (optional): $5
Course Length: 7 hours
RELATIONSHIPS, JOINS, & REFERENTIAL INTEGRITY:
Build a complex multi-table database. Create, edit, and delete relationships (links or connections between different tables.) Create and edit one-to-one, one-to-many, and many-to-many relationships. Learn about Joins vs. Relationships, and how Referential Integrity affects your data.
Create simple macros that automate basic actions such as running or printing queries and reports, and then attach these macros to buttons on forms.
Create forms with sub-forms. Add buttons to forms to run macros.
CALCULATED FIELDS (EXPRESSIONS):
Create Calculated Fields that use expressions to perform calculations in queries, forms, and reports. Add, subtract, multiply, and divide numeric data. Learn to create Calculated Fields using the Builder feature, the Zoom Box, or just by typing in the expression.
SWITCHBOARD (MAIN MENU):
Create a Switchboard (or main menu) with buttons and tabs to organize your tables, macros, queries and forms in one central place.
-Encrypt /Decrypt (Password Protect) Database
-Compile an AACBE Secured Copy of a Database to Distribute to Others