Microsoft Access 2016: (C) Advanced Features - EOD

Back to List

Course: 2112910 - Microsoft Access 2016: (C) Advanced Features - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn advanced options for creating and working with Access databases. Discover how to work with advanced queries, create and run macros, format and validate data and records. Link tables to external sources and split databases for multiple users. Set security options and passwords as well as create database switchboards. Find out how to link Access objects, optimize resources and set options and properties.

Prerequisites

Course Outline

  • Creating Subforms
  • Organizing Data with Tab Pages
  • Creating and Using a Navigation Form
  • Formatting Forms (Headers And Footers, Images, Auto-Order, Sort Records, Apply Themes, Insert Backgrounds, Change Margins)
  • Applying Conditional Formatting
  • Using Form and Record Validation
  • Creating Macros
  • Understanding Types of Macro Actions
  • Restricting Records Using Conditions (Macro Conditions, The Where Condition)
  • Validating Data Using a Macro
  • Using Embedded Macros
  • Automating Data Entry Using a Macro
  • Converting a Macro to VBA
  • Linking Tables to External Data Sources
  • Understanding Exclusive Mode
  • Using the Compact and Repair Database Option
  • Determining Object Dependency
  • Documenting a Database
  • Analyzing the Performance of a Database
  • Splitting a Database for Multiple User Access
  • Merging a Database
  • Implementing Security
  • Setting Passwords
  • Converting an Access Database to an ACCDE File
  • Creating a Database Switchboard
  • Modifying a Database Switchboard
  • Setting Startup Options
Course Type: In Classroom
CEU: 0.60
Sections:
Section#: 4600
Section Meeting Dates and Times:
1/30/2018: 8:30 AM - 11:30 AM
1/31/2018: 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