Skip to Main Content

Microsoft Access 2013: Level 2

Hours: 6.00 | Estimated Cost: $175.00

Expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications and customize reports. Prerequisite: ‘Microsoft® Office Access® 2013-Level 1’ or equivalent knowledge/experience.

Additional Information

Learn About
  • Constructing relational databases
  • Performing database maintenance
  • Improving forms
  • Creating advanced queries and reports
  • Integrating Access with other programs
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 intermediate-level skills
Training Outline

**Designing a Relational Database**

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

** Joining Tables **

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data Within a Table
  • Work with Subdatasheets
  • Create Subqueries

** Organizing a Database for Efficiency**

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

** Sharing Data Across Applications**

  • Import Data in Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

** Advanced Reporting**

  • Organize Report Information
  • Format Reports
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report
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