Acumen IT Training, Inc.

  • +63 917 714 4350 or DUO: (02) 7971 5203
  • 11th Floor, SM Aura Office Tower, 26th Street, Mckinley Parkway, Fort Bonifacio, Taguig City, Metro Manila, Philippines
Facebook Twitter Linkedin Instagram
  • +63 917 714 4350 or DUO: (02) 7971 5203
  • Main: 11th Floor, SM Aura Office Tower, 26th Street, Mckinley Parkway, Fort Bonifacio, Taguig City, Metro Manila, Philippines
    Satellite Office: 2nd Floor, Bonifacio Technology Center, 31st St. cor. 2nd Ave., Bonifacio Global City, Taguig City​
Facebook Twitter Linkedin Instagram

Microsoft Access 2016 Advanced

COURSE DESCRIPTION

This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what are deemed to be advanced data management skills. The participant shall understand the variety of ways that data can be related and organized. In addition the candidate shall be able to run and record simple macros and to import, export and link data.

COURSE OUTLINE

Module 1. Designing Advanced Queries

  • Setting Top Values in a Query
  • Creating a Calculated Field
  • Formatting a Calculated Field
  • Displaying a Totals Row in a Query
  • Creating a Function Query
  • Creating a Parameter Query
  • Using Multivalued Fields
  • Creating a Concatenation in a Query
  • Filtering a Query
  • Labs

 

Module 2. Creating Action Queries

  • Creating a Make-table Query
  • Creating an Update Query
  • Creating an Append Query
  • Creating a Delete Query
  • Labs

 

Module 3. Using Advanced Query Wizards

  • Using the Crosstab Query Wizard
  • Using the Find Duplicates Query Wizard
  • Using the Find Unmatched Query Wizard
  • Labs
Please contact us for the full course outline, schedules and for booking a private class.
Inquire Now
Back
;