Course Introduction and Exercise Files
- Course Topics and Flow
- Course Exercise Files - Download These First!
Access Overview - Quick Overview of Access Interface
- Opening Microsoft Access
- Access Quick Access Toolbar
- Working with the Access Ribbon
- Access Object Panel
- Access File Tab
- Access Security Prompt
Access Overview - Fundamentals of Access Objects
- Understanding the Purpose of Access Tables
- Building Relationships between Access Tables
- Using Access Queries to Select Specific Data
- Building a User Interface with Access Forms
- Reporting on Access Data with Access Reports
- Automate Access Tasks with Macros and VBA
Access Tables - Working with Table Data
- Working in Datasheet View within an Access Table
- Sorting the Datasheet View
- Filtering the Datasheet View with Filter by Selection
- Filter the Datasheet View with Advanced Filter
Access Tables - Creating Tables in Your Access Database
- Preview the "Student Course" Database Tables
- Creating an Access Database
- Designing Access Tables in Design View
- Adding Fields and Defining Common Data Types in an Access Table
- Field Size Property
- Field Caption Property
- Default Value Property
- Required Field Property
- Input Mask Property
- Custom Input Mask
- Working with the Lookup Wizard Data Type
- Edit a Table Field Drop Down
- Adding Field Descriptions
- Setting the Table's Primary Key Field
- Adding Records in the Datasheet View
Access Tables - Microsoft Access Table Exercise
- Table Exercise Introduction
- Building Additional Tables
Access Tables - Working with Access Table Relationships
- Understanding Access Table Relationships
- Creating Access Table Relationships
- Setting Up "Better" Table Relationships
- Setting the Relationship Properties
- Table Relationships Cascade Update/Delete
- Working with Sub Datasheets in Tables
- Creating Table Relationships with the Lookup Wizard
Access Queries - Working with Access Select Queries
- Creating an Access Select Query
- Adding Criteria to an Access Select Query
- Using AND Conditions in an Access Query
- Using OR Conditions in an Access Query
- Another OR Condition
- Sorting Data within an Access Select Query
- Multi-Level Query Sort
- Working with Date Criteria in an Access Select Query
- Using the "Between" Operator
- Access Query Tip -- Using Table Fields within Query Criteria
- Using Wildcards in Query Criteria
- Access Query Tip --- DATA TYPE MISMATCH
- Saving an Access Query
Access Queries - Query Calculated Fields
- Creating a Calculated Field in an Access Query
- Using the MONTH() and MONTHNAME() Functions
- Using the IF() Function in a Query Calculated Field
- Finding the Difference Between Two Dates Using the DateDiff() Function
Access Queries - Summarizing Data in an Access Query
- Working with an Access Total Query
- Grouping and Summarizing Data with a Total Query
- Adding a Calculated Field to a Total Query
- Saving a Total Query
- Total Query Exercise -- Post in the QA Section
- Total Query Example -- Products Table
- Summarizing Data with a Crosstab Query
Access Queries - Working with Access Action Queries
- Introduction to Access Action Queries
- Update Access Table Data with an Update Query
- Update Table Data with a Calculation
- Saving an Action Query
- Creating a New Table with an Access Make Table Query
- Deleting Table Data with an Access Delete Query
- Appending Records to an Exisiting Table with an Access Append Query
Access Queries -- Querying Multiple Tables with Query Joins
- Creating a Query with Multiple Tables
- Working with Query Joins
- Inner Join and Left Outer Join
Access Queries - Parameter Queries
- Parameter Query Preview
- Creating a Single Parameter
- Saving the Parameter Query
- Creating Date Parameters
- Creating Multiple Parameters
- Using Wildcards in Parameters
- Run a Parameter with a Shortcut
Access Forms - Building Data Entry Forms
- Starting with a Blank Form
- Adding Form Fields
- Moving Form Fields
