Skip to Main Content

Microsoft Access 2013: Level 3

Hours: 6.00 | Estimated Cost: $175.00

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. Prerequisite: ‘Microsoft® Office Access® 2013-Levels 1 & 2’ or equivalent knowledge/experience.

Additional Information

Learn About
  • Implementing advanced form design
  • Data validation
  • Improving user interface design using Macros
  • Maintaining databases using advanced database management
  • Distributing and securing documents
  • Managing switchboards
Benefits & Outcomes
  • Microsoft Access unlocks the full value of your data. Learn to become more efficient and accurate
  • Microsoft Access is more than just a list or a table. It gives you full command of your data to retrieve it, sort it, analyze it, summarize it and report the results in moments
  • Gain advanced-level skills
Training Outline

** Implementing Advanced Form Design**

  • Add Controls to Forms
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation of Forms
  • Apply Conditional Formatting

** Using Data Validation**

  • Field and Record Validation
  • Form Validation

** Using Macros to Improve User Interface Design**

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA

** Using Advanced Database Management**

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

** Distributing and Securing a Database**

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

** Managing Switchboards**

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options
Business and Industry Services

Fox Valley Technical College
Business & Industry Services
D. J. Bordini Center
5 N. Systems Drive
P.O. Box 2277
Appleton, WI 54912-2277
View BIS Calendar

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771

Join us on LinkedIn