What the Access Advanced course covers
⊕ Expand full topic list
Unit 1: Relational Database Design
- Designing a Relational Database
- Scoping the System
- Determining the Inputs
- Normalising a Database
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Second Normal Form – Case Study
- Third Normal Form (3NF)
- Database Indexing
⊕ See more
Unit 2: Creating a Relational Database
- Creating a New Database File
- Creating Lookup Tables
- Defining a Primary Key
- Saving and Closing a Table
- Creating the Expense Type Table
- Creating the Transactions Table
- Creating the Details Table
⊕ See more
Unit 3: Setting Table Relationships
- Understanding Table Relationships
- Understanding Lookup Relationships
- Looking Up the Employees Table
- Looking Up the Expense Types Table
- Viewing Table Relationships
- Understanding Table Joins
- Editing the Employee Table Join
- Editing the Expense Type Table Join
- Creating a New Join
- Creating a Relationship Report
⊕ See more
Unit 4: Importing and Exporting Records
- Exporting Records to Microsoft Excel
- Exporting Records to a Text File
- Importing From Microsoft Excel
- Importing From a Text File
- Linking To an External Source
⊕ See more
Unit 5: Multi Table Queries
- Understanding Relational Queries
- Creating a Relational Query Design
- Filtering a Relational Query
- Filtering Related Fields
- Adding More Tables and Fields
- Utilising Hidden Fields
- Understanding Query Joins
- Creating an Inner Join
- Creating a Left Outer Join
- Creating a Right Outer Join
⊕ See more
Unit 6: Parameter Queries
- Creating a Parameter Query
- Displaying All Records
- Using Parameters to Display a Range
- Using Parameters in Expressions
- Using Parameters with Wildcards
⊕ See more
Unit 7: Calculations in Queries
- Creating a Calculated Field
- Formatting Calculated Fields
- Summarising Data Using a Query
- Changing the Grouping
- Calculating With Dates
- Using Criteria in Calculations
- Concatenating String Fields
⊕ See more
Unit 8: Aggregation Queries
- Creating an Aggregation Query
- Working with Aggregation Queries
- Multiple Aggregations
- Modifying Aggregation Headings
- Aggregating Calculated Fields
- Applying Criteria to Aggregates
- Understanding Nested Queries
- Creating an Assembly Query
- Creating the Nesting Query
⊕ See more
Unit 9: Action Queries
- Creating a Make Table Query
- Using a Make Table Query
- Understanding Expressions and Update Queries
- Preparing an Update Query
- Running an Update Query
- Updating Using Expressions
- Running an Expression-Based Update
- Creating a Delete Query
- Running a Delete Query
- Creating an Append Query
- Running an Append Query
- Turning Action Messages Off
⊕ See more
Unit 10: Modifying Forms
- Understanding Form Design and Layout
- Switching Between Form Views
- Selecting Form Objects
- Working With a Control Stack
- Changing Control Widths
- Moving Controls on a Form
- Aligning Controls
- Understanding Properties
- Changing Label Captions
- Adding an Unbound Control
- Adding a Control Source
- Formatting a Control
- Checking the Current Tab Order
- Changing the Tab Order
- Inserting the Date into the Form Header
⊕ See more
Unit 11: DIY Forms
- Creating a Multiple Item Form
- Adjusting the Layout of a Form
- Typing Into a Form Layout
- Disabling Fields
- DIY Sub Forms
- Removing SubForm Redundancy
- Splitting and Merging Layout Cells
- Adding an Easy Lookup Field
- Adding Buttons to a Form
- Adjusting Form Properties
⊕ See more
Unit 12: Creating and Using Macros
- Understanding Macros and VBA
- Creating a Macro
- Running a Macro
- Modifying an Existing Macro
- Interacting With the User
- Stepping Through a Macro
- Documenting Macros
⊕ See more
Unit 13: Macro Techniques
- Creating a Print Macro
- Using Conditions to Enhance a Macro
- Creating a Sequence of Conditions
- Understanding the Versatility of MsgBox
- Using the MsgBox Function
- Reconfiguring a Message Box
- Using the InputBox Function
⊕ See more
Unit 14: Macros on Forms
- Understanding Macros on Forms
- Creating Navigation Macros
- Accessing Event Macros
- Creating Unassigned Buttons
- Programming an Event
- Running an Event Macro
- Modifying an Event Macro
- Setting Echo Off
- Adding a Close Button
- Creating a Search Macro
- Running the Search Macro
- Understanding the Search Macro
- Naming Macros
- Referencing Macro Sheet Macros
⊕ See more
Unit 15: Database Wellness
- Compacting and Repairing a Database
- Understanding Database Splitting
- Using the Database Splitter
- Managing Linked Tables
- Checking Object Dependencies
- Analysing Database Performance
- Documenting a Database
⊕ See more
Unit 16: An Introduction to VBA
- Understanding VBA
- Coding VBA for an Event
- Running VBA Event Code
- Understanding MsgBox and InputBox
- Modifying an Existing Procedure
- Understanding the Modified Code
- Creating a Standard Module
- Loan Simulator Code
- Running the Code
- Understanding the Loan Simulator Code
- Creating a Button for the Simulator
- Attaching the Simulator Code
⊕ See more