Skip Ribbon Commands
Skip to main content
Microsoft Office Access 2013 Advanced
Course Number:(ALTO-091006)
Course Length:1 Day
Course Price:$495
Or Register by Phone 1-888-600-ALTO (2586)

 Upcoming Classes

TBA

 Course Description

You have covered many of the basic functions of Microsoft® Office Access® and now you are ready to learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. The training today added to that which you have gained from the previous two days and will round out your Access education and provide you with marketable job skills. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

 Course Outline

Target Student:

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills.

This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.

Prerequisites:

To ensure your success in your course you should have experience working with Microsoft Access 2013, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

  • Microsoft® Office Access® 2013: Part 1
  • Microsoft® Office Access® 2013: Part 2

    Lesson 1: Implementing Advanced Form Design

    Topic A: Add Controls to Forms

    Topic B: Create Subforms

    Topic C: Organize Information with Tab Pages

    Topic D: Enhance Navigation of Forms

    Topic E: Apply Conditional Formatting

    Lesson 2: Using Data Validation

    Topic A: Field and Record Validation

    Topic B: Form Validation

    Lesson 3: Using Macros to Improve User Interface Design

    Topic A: Create a Macro

    Topic B: Restrict Records Using a Condition

    Topic C: Validate Data Using a Macro

    Topic D: Automate Data Entry Using a Macro

    Topic E: Convert a Macro to VBA

    Lesson 4: Using Advanced Database Management

    Topic A: Link Tables to External Data Sources

    Topic B: Manage a Database

    Topic C: Determine Object Dependency

    Topic D: Document a Database

    Topic E: Analyze the Performance of a Database

    Lesson 5: Distributing and Securing a Database

    Topic A: Splitting a Database for Multiple User Access

    Topic B: Implement Security

    Topic C: Set Passwords

    Topic D: Convert an Access Database to an ACCDE File

    Topic E: Package a Database with a Digital Signature

    Lesson 6: Managing Switchboards

    Topic A: Create a Database Switchboard

    Topic B: Modify a Database Switchboard

    Topic C: Set Startup Options

    ​​​