Access 2013 Advanced - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Customize a form layout to improve usability and efficiency of data entry
  • Add user interface features to validate data entry
  • Use macros to improve user interface design
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy
  • Lock down and prepare a database for distribution to multiple users
  • Create and modify a database switchboard and set the startup options

Course Content

Lesson 1: Implementing Advanced Form Design

  1. Add Controls to Forms
  2. Create Subforms
  3. Organize Information with Tab Pages
  4. Enhance Navigation of Forms
  5. Apply Conditional Formatting

Lesson 2: Data Validation 

  1. Field Validation
  2. Form and Record Validation

Lesson 3: Using Macros to Improve User Interface Design

  1. Create a Macro 
  2. Restrict Records Using a Condition
  3. Validate Data Using a Macro
  4. Automate Data Entry Using a Macro
  5. Convert a Macro to VBA

Lesson 4: Using Advanced Database Management 

  1. Link Tables to External Data Sources
  2. Manage a Database
  3. Determine Object Dependency
  4. Document a Database
  5. Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database

  1. Split a Database for Multiple User Access
  2. Implement Security
  3. Set Passwords
  4. Convert an Access Database to an ACCDE File
  5. Pakcage a Database with a Digital Signature

Lesson 6: Managing Switchboards

  1. Create a Database Switchboard
  2. Modify a Database Switchboard
  3. Set Startup Options

Appendix A: Microsoft Office Access 2013 Exam 77-424
Appendix B: Microsoft Office Access 2013 Common Keyboard Shortcuts 

If you would like to customize this course, please call us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!