Microsoft Access 2016: Level 2 (Online)

In Level 2 customize reports, join tables, modify table design and field properties, share data across applications.

Prerequisite: Microsoft Access Level 1 or equivalent knowledge.

Target Student: 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. 

Overview: In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. 

Course Objectives: In this course, you will work with relational database structure, relationships, efficiency, integrity, and customization. You will: 

• Design a relational database.
• Join tables to retrieve data from unrelated tables.
• Organize a database for efficiency and performance, and to maintain data integrity.
• Share data among Access and other applications.
• Customize reports to organize the displayed information and produce specific print layouts.

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design 

Topic B: Create a Table 

Topic C: Create Table Relationships 

Lesson 2: Joining Tables 

Topic A: Create Query Joins 

Topic B: Join Tables That Have No Common Fields 

Topic C: Relate Data within a Table 

Topic D: Work with Subdatasheets 

Topic E: Create Subqueries 

Lesson 3: Organizing a Database for Efficiency 

Topic A: Data Normalization 

Topic B: Create a Junction Table 

Topic C: Improve Table Structure 

Lesson 4: Sharing Data Across Applications 

Topic A: Import Data into Access 

Topic B: Export Data to Text File Formats 

Topic C: Export Access Data to Excel 

Topic D: Create a Mail Merge 

Lesson 5: Advanced Reporting 

Topic A: Organize Report Information 

Topic B: Format Reports 

Topic C: Include Control Formatting in a Report 

Topic D: Add a Calculated Field to a Report 

Topic E: Add a Subreport to an Existing Report

Note:

This course will be offered via Zoom. Register now and then the day before class the instructor will send you the link to attend. Look for an email with "CFU Zoom class" in the subject line. A good internet connection and a computer or device with a camera and mic are needed.

 Look for an email from your instructor with the subject line CFU Zoom class for the link. Be ready to log on and join the meeting 5-10 minutes prior to the class start time so you will be ready when class begins. If you have trouble using the link, just go to Zoom.us, click "Join a Meeting" and enter the meeting ID provided in the instructor's email.