Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Advanced Microsoft Access

Version 2010 • 2013 • 2016

1 Day, 9:00-4:00, 6 Hours

This instructor-led course, through lecture and hands-on exploration, will teach students the skills needed to create complex queries to validate and analyze data, add advanced elements to existing forms and reports, and work with features that automate the database and allow for multi-user access. This course is geared for users who are comfortable creating basic tables, forms, queries, and reports.

Course Objectives:

  • Create advanced queries that generates crosstabs, find duplicates, and unions data
  • Customize subforms and add tab controls to layer data
  • Adjust report sources and add on-the-fly print titles
  • Create macros to run commands via a button
  • Create a ‘main menu’ that allows users to easily navigate through database functions
  • Understand best practices for working with a shared database

Creating Queries to Validate and
Analyze Data

  • Creating Crosstab Queries
  • Editing Crosstab Queries
  • Creating Crosstabs Using Dates
  • Finding Duplicate Records
  • Finding Matches and Non-Matches
    Between Tables
  • Creating Union Queries

Adding Advanced Form Elements

  • Changing the View of Subforms
  • Working with Tab Controls
  • Adding Tab Controls
  • Adding or Moving Fields into Tab Controls
  • Resizing Tab Controls
  • Modifying the Caption Property
  • Inserting and Deleting Page Tabs
  • Changing the Order of Page Tabs
  • Saving Forms as Reports

Adding Advanced Report Elements

  • Changing the Record Source of Objects
  • Including Parameters in Report Titles

Creating Basic Macros

  • Creating Macros to Preview Reports
    from Forms
  • Attaching Macros to Command Buttons
  • Running Macros

 

Creating a Switchboard or Main Menu

  • Creating Main Menu Switchboards
  • Adding Items to Switchboards
  • Opening Switchboards
  • Creating Additional Switchboards
  • Navigating Between Switchboards
  • Viewing Switchboard Items
  • Displaying Switchboards on Startup

Sharing and Maintaining a Database

  • Sharing Databases on a Network
  • Refraining from Design Changes
  • Finding Out if Other Users are in the Database
  • Opening Databases in Exclusive Mode
  • Setting Database Passwords
  • Linking Tables Between Databases
  • Compacting and Repairing Databases
  • Using the Back Up Database Feature
  • Printing Database Object Information

 

 

View Upcoming Schedule or Register for a Class

Not Sure What Level to Take?

Before taking the Intermediate or Advanced level class for this application, we ask that you determine whether you are comfortable with the topics covered in the Introductory level class. Or, feel free to contact our office at (202) 747-5000 to speak with a representative to discuss the prerequisites.

Back to Agenda

 

Investment

Public Class

$275 per student
Or one voucher

View Schedule or Register

Private Group Classes

Conducted at Your Office

$850 flat fee for up to 8 students
$950 for up to 12 students
$50 per additional student

Conducted at Softek’s Facility

$1000 flat fee for up to 8 students
$1100 for up to 12 students
$50 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Softek also offers a 3-hour series for this application. Visit our agendas page  to view our 3-hour classes. 

Why choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee