Skip to Main Content

Microsoft Access 2013: Level 1

Hours: 6.00 | Estimated Cost: $175.00

Understand basic database concepts, create and modify new databases and manipulate various objects using the Microsoft Access relational database application. Learn to make databases manageable. Prerequisite: Basic knowledge of Windows® is recommended.

Additional Information

Learn About
  • Creating a new database
  • Constructing data tables
  • Querying a database
  • Designing forms
  • Generating Reports
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
Training Outline

** Getting Started with Access **

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help in Microsoft Access

** Working with Table Data**

  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups

** Querying a Database **

  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

** Creating Advanced Queries**

  • Create Parameter Queries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Summarize Data

** Generating Reports**

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

** Customizing the Access Environment**

  • The Access Options Dialog Box
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