Microsoft Access Level II
Expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extend your knowledge of Microsoft Access 2013 for a more robust, functional database for your users.
This class is taught in Microsoft Office 2013. The UWM-SCE computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.
Who Should Attend
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.
Course Content Microsoft Access Level II
Lesson 1: Designing a Relational Database
Relational Database Design
Create a Table
Create Table Relationships
Lesson 2: Joining Tables
Create Query Joins
Join Tables That Have No Common Fields
Relate Data Within a Table
Work with Subdatasheets
Lesson 3: Organizing a Database for Efficiency
Create a Junction Table
Improve Table Structure
Lesson 4: Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Lesson 5: Advanced Reporting
Organize Report Information
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Access 2010/2013 – Level I (or equivalent experience)
Public courses on Microsoft Excel and Access are taught in Office 2013. If you are using Office 2010 – the functions and features you will learn are similar to 2013 and can be applied in the 2010 environment. If you would like group training on any MS Office 2010 programs, please contact Pam Nellen at firstname.lastname@example.org or 414-227-3208
Great course! Hannah was very knowledgeable. I am looking forward to taking Access III.
— student, 2014
Hannah is very knowledgeable and really allowed us time to ask our very specific questions.
— Student, 2015