Advanced Access

Advanced Microsoft Access

Mobile

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

 

Date: Please call for dates

Days: 2

Fee: $475.00

Location: 1 Martine Avenue, White Plains, NY

Course Number:

Date: Please call for dates

Days: 2

Fee: $475.00

Location: 551 Fifth Ave., NYC

Course Number:

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.

Click for Detailed Course Description

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

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

 

 

 

Other Courses That May Interest You

icon

Access

  icon

Excel

icon

Microsoft Project

  icon

Outlook

 

 

icon

PowerPoint

  icon

Windows 8.1

 

 

Word