UpcomingAccess 2013 Level 2

Rosalina Legaspi

Price Qty*
August 22, 2018 show details + $351.75 (CAD)  

  • August 22, 2018
    8:30 am - 4:00 pm

Course Length: 1 day (8:30 a.m. – 4:00 p.m.)                       Instructor Led Training

Course Overview
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.

Course Content

Module 1: Managing Data
Types of Relationships
Viewing Relationships
Viewing Object Dependencies
What is Referential Integrity?
Enforcing Referential Integrity
Using Cascade Delete and Cascade Update
Module 2: Advanced Table Tasks
Inserting Application Parts
Using the Table Analyzer Wizard
Creating Validation Rules
Configuring Validation Messages
Module 3: Managing Data Entry in Tables
Marking Fields as Required
Marking a Field for Indexing
Creating Lookup Fields
Creating Value Lists
Creating Input Masks
Module 4: Creating Subforms
Creating Subforms
Using Subforms
Linking Subforms with Parent Forms
Formatting a Subform within a Main Form
Module 5: 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
Module 6: Advanced Query Tasks
Understanding SQL Statements
Basic SQL Keywords
Creating SQL Queries
Using the Expression Builder
Module 7: Creating Modal Dialog Boxes
Creating a Modal Dialog Box
Adding Controls
Setting Properties
Formatting a Modal Dialog Box
Module 8: Splitting the Database
Backing Up the Database
Splitting the Database
Configuring Access 2013 for a Multi-User Database
Setting Record Locking Options
Module 9: Using Access with SharePoint Server
Linking Tables and Lists
Moving a Database to SharePoint
Saving a Database to SharePoint
About Access Web Apps
Module 10: Creating Basic Macros
Creating a Standalone Macro
Using the Action Catalog
Adding Comments to Macros
Using If-Then Actions
Handling Macro Errors
Module 11: Advanced Macro Tasks
Creating Event Procedures
Creating Data Macros
Creating Submacros
Grouping Submacros
Module 12: Using Visual Basic for Applications
Converting a Macro to Visual Basic
Using Visual Basic for Applications
Understanding Modules
Building Visual Basic Procedures
Rosalina LegaspiUpcomingAccess 2013 Level 2