Microsoft Access 2013 Advanced
Private Class From
RM1100
/day
(2 Days)
COURSE OBJECTIVES

Upon completion of this program, participants should be able to:

  • Create and Format a Modal Dialog Box
  • Understand Types of Relationships
  • View Relationships and Object Dependencies
  • Establish and enforce Referential Integrity
  • Compact and Repair a Database
  • Encrypt a Database with a Password
  • Back Up Your Database
  • Backup a Database
  • Split a Database
  • Configure Access 2013 for a Multi-User Database
  • Split a Database
  • Create Basic Macros
AUDIENCE

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know, understand and want to further enhance their knowledge and practical uses of Microsoft Access


PREREQUISITES

REQUIRED PREREQUISITES:

Basic knowledge of Microsoft Access is essential with the following pre-requisites:

  • Have attended Microsoft Access – Foundation and Intermediate Level; OR
  • Able to switch between task applications
  • Able to Mark Fields as Required in a Table
  • Able to Use Input Masks to control table data entry
  • Able to Add Tabs to a Navigation Form
  • Able to Set a Tab Hierarchy
  • Able to Create Parameter Queries
  • Able to Create Action Queries
  • Make Table, Append, Delete & Update Queries
  • Able to Create a Report with the Wizard
  • Able to Create a Report from Scratch
  • Able to Understand Basic SQL Statements and Keywords
  • Able to Create a Report with the Wizard
  • Able to Create a Report from Scratch
  • Able to Group and Sort Form Data
  • Able to Insert Images, Logos, Headers and Footers

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise


  • Creating a Modal Dialog Box
  • Adding Controls
  • Setting Properties
  • Formatting a Modal Dialog Box
  • Types of Relationships
  • Viewing Relationships
  • Viewing Object Dependencies
  • What is Referential Integrity?
  • Enforcing Referential Integrity
  • Using Cascade Delete and Cascade Update


  • Compacting and Repairing a Database
  • Encrypting a Database with a Password
  • Backing Up Your Database
  • Exporting a Database and Database Objects
  • Printing Database Objects


  • Collapsing and Pinning the Ribbon
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes


  • Backing Up the Database
  • Splitting the Database
  • Configuring Access 2013 for a Multi-User Database
  • Setting Record Locking Options


  • Creating a Standalone Macro
  • Using the Action Catalog
  • Adding Comments to Macros
  • Using If-Then Actions
  • Handling Macro Errors