Skip to Main Content

Microsoft Access Level 3

Hours: 6.00 | Estimated Cost: $175.00

Create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports and by performing database maintenance. Prerequisite: ‘Microsoft Access-Levels 1 & 2’ or equivalent knowledge/experience.

Additional Information

Learn About
  • Structuring existing data
  • Writing advanced queries
  • Simplifying tasks with macros
  • Creating and producing effective forms
  • Making reports more effective
  • Maintaining an Access database
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, summerize it and report the results in moments
Training Outline

**Implementing Advanced Form Design**

  • Add Controls to Forms
  • Enhance Navigation and Organization of Forms
  • Apply Conditional Formatting

**Sharing Data Across Applications**

  • Import Data into Access
  • Export Access Data
  • Link Tables to External Data Sources
  • Create a Mail Merge

**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

**Using VBA**

  • Getting Started with VBA
  • Enhance Access Using VBA

**Using Advanced Database Management**

  • Manage a Database
  • Determine Object Dependency
  • Document a Database

**Distributing and Securing a Database**

  • Splitting a Database for Multiple User Access
  • Implement Security
  • 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 (BIS)
D. J. Bordini Center
5 N. Systems Drive
Appleton, WI 54914-1655
View BIS Calendar

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

Join us on LinkedIn