Microsoft Access 2016, Level 2

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

Code:3463RP
Dates:January 21, 2019 Check for other dates
Meets:One Mon., 9AM-4PM 01/21 (2016)
Location:CFU LOWRY: Near 1st & Quebec
Fee:$174
You could save $15.00 on this course by becoming a member of CFU Membership

There are still openings remaining at this time.

OR


A valid credit card will be required for payment. Please have your card information ready.



Enrollment Progress ...     What's This?

Return to Course Listing