Microsoft Access 2016: (B) Enhancing Functionality - EOD

Back to List

Course: 2112908 - Microsoft Access 2016: (B) Enhancing Functionality - EOD

Course Description:

EMPLOYEE & ORGANIZATIONAL DEVELOPMENT: Learn more about Microsoft Access database design and presentation options. Organize your tables to reduce redundant data and ensure it is stored logically. Locate and eliminate orphaned records, create lookup fields, use subdatasheets, join tables within queries, use calculated fields, and summarize and group values. Learn how to design more advanced forms with bound and unbound controls, graphics, calculated values, combo boxes and more. Find out how to create labels, export data, and create a mail merge dataset. Adding charts to forms and reports will also be covered.

Prerequisites

 

Course Outline

  • Exploring Data Normalization
  • Understanding First Normal Form, Second Normal Form, Third Normal Form and Denormalization
  • Creating Junction Tables
  • Using Many-to-Many Relationships
  • Joining Tables using Query Joins, Inner Joins, and Outer Joins
  • Joining Tables with No Common Fields
  • Relating Data within a Table
  • Working with Subdatasheets
  • Creating Subqueries
  • Creating Parameter Queries
  • Using Wildcards in a Parameter Query
  • Creating Action Queries
  • Creating Find Duplicate and Find Unmatched Queries
  • Summarizing Data with Crosstab Queries and Multiple Table Queries
  • Adding Controls to Forms
  • Using Command Buttons
  • Using Quick Start Fields and Calendar/Datepicker Control
  • Establishing Tab Order
  • Setting and Removing Form Controls
  • Modifying Data Sources
  • Setting Form Control Properties
  • Using Data Validation (Field Properties, Input Masks, Lookup Lists, and the Expression Builder)
  • Organizing Report Information
  • Using the Group, Sort, and Total Pane
  • Adding a Background Image to a Report
  • Formatting Reports (Tools, Properties, Pagination)
  • Including Data Bars and Charts in reports
  • Adding Calculated Fields in Reports
  • Adding Subreports
  • Creating Mailing Labels (Report)
  • Publishing a Report as PDF
  • Importing Data into Access
  • Using Delimiters
  • Exporting Data to Text File Formats
  • Exporting Access Data to Excel
  • Creating a Mail Merge
Course Type: In Classroom
CEU: 0.60
Sections:
Section#: 4031
Section Meeting Dates and Times:
6/7/2017: 8:30 AM - 11:30 AM
6/8/2017: 8:30 AM - 11:30 AM

Location:
Suite 2201 - Lab 2202
General Services Complex (GSC)
750 Agronomy Rd.
Description:

Category: Technology Training - Database

Register and View Schedule

Add to Course Waitlist