Advanced Access

Mobile

Course: Advanced Microsoft Access

Microsoft Access is a reknown and powerful software for designing and developing database applications. Our hands-on, instructor-led courses in the greater New York City area include topics for the beginner to the more advanced user.

The advanced Microsoft Access courses will help you become skilled at creating databases, manipulating and querying data and designing advanced data analysis reports. (see also Introduction to Access)

Course Details

icon
iPhone

Start Date: Please Call for Dates
Fee: $475.00
Number of Sessions: 2
Course Location: 1 Martine Avenue, White Plains, NY

 
icon

Course Description

 

This course is ideal for Access users who are familiar with the basic concepts and design of tables, queries, forms, and reports and want to enhance and expand their skills. This course is designed to enhance the skills you have learned in Introduction to Microsoft Access or with equivalent experience. You will extend your knowledge into more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining the database. This course will take you to the next level of database functionality.

 

icon

You Will Learn To

  • Create a Lookup Field
  • Set field properties including Input Masks, Validation, etc.
  • Create advanced forms with Tabbed Controls, Combo Boxes, etc.
  • Create Imbedded Forms
  • Use Grouping and Parameters in queries
  • Create advanced reports with Calculated Fields, Can Grow, Page Breaks
  • Customize Quick Access Toolbar
  • Create Macros, Command Buttons and a Switchboard
  • Create and use Query by form
icon

Who Should Enroll

 

Access users who are familiar with the basic concepts and design of tables, queries, forms, and reports and want to enhance and expand their skills.

Prerequisite: Introduction to Access or equivalent knowledge

 

icon

Course Format

 

Two Days (9am- 4pm); offered Monday-Friday; Instructor-led. Class runs from 9am-4pm.

COST: $475

 

icon

Questions?

Please contact us at (888) 561-7223 () or continuinged@pace.edu

Course Outline for Advanced Microsoft Access

CUSTOMIZING ACCESS
  • Customizing the Quick Access Toolbar
  • Access Options
  • The Trust Bar
FIELD PROPERTIES
  • Lookup Tables
  • Input Masks
  • Validation Rules
  • Captions, Defaults, and Required
  • Indexes
  • Formats
ADVANCED FORMS
  • Embedded Forms
  • Customizing a Form using Design View
  • Aligned Controls
  • Tabbed Controls
  • Tab Order
  • Combo Boxes
  • Option Buttons
  • Toggle Buttons
ADVANCED QUERIES
  • Calculations in Queries
  • Summary Calculations and Grouping
  • Update Queries
  • Parameter Queries
ADVANCED REPORTS AND THE EXPRESSION BUILDER
  • Calculated Fields and their Properties
  • The Expression Builder
  • Hide Duplicates
  • Can Shrink
  • Can Grow
  • Page Breaks and Force New Page
MACROS, COMMAND BUTTONS, AND THE SWITCHBOARD MANAGER
  • Command Buttons
  • Embedded Macros
  • The Switchboard Manager
  • Stand Alone Macros
  • Running Macros with Toolbar Buttons
  • Multiple Macros on One Sheet
QUERY BY FORM
  • Query by Form
  • Conditional Macros