Microsoft Access 2013 Advanced Essentials

Request more details:

Description:
This course builds upon basic Microsoft Access skills to help students become power users. In this advanced Microsoft Access 2013 course, students will delve deeper into the program by studying a dozen different topics. Modules in this course cover how to manage data and data entry; create forms, macros, and dialog boxes; create and use SQL queries; split databases; and much more.
Prerequisites:
To ensure the successful completion of this Advanced course, the completion of relevant Core or Intermediate courses - or equivalent knowledge - is recommended.
Managing Data:
Types of Relationships
Viewing Relationships
Viewing Object Dependencies
What is Referential Integrity?
Enforcing Referential Integrity
Using Cascade Delete and Cascade Update
Advanced Table Tasks:
Inserting Application Parts
Using the Table Analyzer Wizard
Creating Validation Rules
Configuring Validation Messages
Managing Data Entry in Tables:
Marking Fields as Required
Marking a Field for Indexing
Creating Lookup Fields
Creating Value Lists
Creating Input Masks
Creating Subforms:
Creating Subforms
Using Subforms
Linking Subforms with Parent Forms
Formatting a Subform within a Main Form
Creating Navigation Forms:
Creating a Navigation Form
Adding Tabs to a Navigation Form
Creating a Tab Hierarchy
Displaying the Navigation Form when the Database Opens
Advanced Query Tasks:
Understanding SQL Statements
Basic SQL Keywords
Creating SQL Queries
Using the Expression Builder
Creating Modal Dialog Boxes:
Creating a Modal Dialog Box
Adding Controls
Setting Properties
Formatting a Modal Dialog Box
Splitting the Database:
Backing Up the Database
Splitting the Database
Configuring Access 2013 for a Multi-User Database
Setting Record Locking Options
Using Access with SharePoint Server:
Linking Tables and Lists
Moving a Database to SharePoint
Saving a Database to SharePoint
About Access Web Apps
Creating Basic Macros:
Creating a Standalone Macro
Using the Action Catalog
Adding Comments to Macros
Using If-Then Actions
Handling Macro Errors
Advanced Macro Tasks:
Creating Event Procedures
Creating Data Macros
Creating Submacros
Grouping Submacros
Using Visual Basic for Applications:
Converting a Macro to Visual Basic
Using Visual Basic for Applications
Understanding Modules
Building Visual Basic Procedures