MODULE 1: Advanced Data Management
Learning outcomes: A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database.
- Referential Integrity
- Table Relationships
- An Introduction to SQL
- Modal Dialog Boxes
MODULE 2: Advanced Form Tasks
Learning outcomes: Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface.
- Using Subforms
- Creating a Navigation Form
- Advanced Form Controls
- Exporting a Form
- Other Form Tasks
MODULE 3: Automating Reports
Learning outcomes: Create Reports in Access that can return data quickly by using a form to control and launch reports. Look at modifying form properties including combo boxes and link a query to a form.
- Creating the Report Form
- Building Query Criteria
MODULE 4: SQL and Microsoft Access
Learning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.
- Understanding SQL
- Using the SELECT Statement
- Using Subqueries
- Using SQL Joins
MODULE 5: Macros and Visual Basic for Applications (VBA)
Learning outcomes: Using Macros and Visual Basic to create some advanced functionality to your Access Database.
- Macro Basics
- More about Macros
- Access and VBA
- Building Advanced Procedures
- Using VBA in a Database
MODULE 6: Finishing the Application
Learning outcomes: Look at finishing touches to control how users interact with a database using start-up and sharing options. Identify security measures by creating an ACCDE and encrypting a database with a password.
- Setting Start Up Options
- Sharing/Splitting the Database
- Creating an ACCDE
- Encrypting the Database with a Password
- Some of the lessons are quite technical, so you MUST have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.