Microsoft Access 2010: Advanced Level 3

Course Overview

In this advanced Microsoft Access 2010 training course, delegates will learn to:

• Understand Database Design
• Use Data Management Tools
• Use Access with Other Applications
• Create and Edit Macros
• Create Switchboards
• Understand Security and Use Security
• Compact and Repair a Database

CourseMonster specialises in offering Microsoft training to corporations and individuals alike, we are happy to help with any of your Microsoft training requirements.

Related Courses

• Microsoft Access 2010: Introduction for Beginners
• Microsoft Access 2010: Intermediate
• Microsoft Access 2010: Fundamentals
• Microsoft Access 2007/2010: Advanced
• Microsoft Access 2010: Specialised
• Microsoft Access 2010: Intermediate
• Microsoft Access 2010: Advanced
• Microsoft Access 2007/2010: Advanced Skills
• Microsoft Access 2007/2010: Introduction for Beginners
• Microsoft Access 2007 2010: VBA Programming

Audience

Delegates must have knowledge of Access to Intermediate level, or equivalent experience or attended the Access Fundamentals course.

Course Outline

Database Design

• Designing a Relational Database
• Normalisation of Data
• De-normalisation

Database Management Tools

• Documenting and Analyse the Database Structure
• Compacting and Repairing a Database
• Encrypting and Decrypting a Database

Importing, Exporting and Linking

• Importing Objects
• Exporting Objects
• Linking Access Objects

Macros

• What is a Macro?
• What are Macro Actions?
• Create a Macro
• Create a Macro Group
• Create an Embedded Macro
• Conditional Macros
• Running a Macro
• Creating Macros for Data Transfer

Managing Access' Front-End

• What is a Switchboard?
• Creating a Switchboard
• Adding, Editing and Deleting a Switchboard
• Displaying a Switchboard Automatically Upon Opening a Database

Security Fundamentals

• Security Overview
• Protecting Databases
• Set Passwords

• Understand Database Design
• Use Data Management Tools
• Use Access with Other Applications
• Create and Edit Macros
• Create Switchboards
• Understand Security and Use Security
• Compact and Repair a Database