ms access - advanced

By attending MS Access - Advanced workshop, Delegates will learn to:

  • Restructure data into appropriate tables to ensure data dependency and minimize redundancy
  • Write advanced queries to analyze and summarize data
  • Create and revise Access macros
  • Display data more effectively in a form
  • Customize reports by using various Access features, thus making them more effective
  • Maintain database using tools provided by Access
  • Study about access printing issues

MS Access - Advanced class is for those individuals whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for those pursuing the MS Office Specialist Certification for MS Office Access.

MS Access - Advanced class is for those individuals whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for those pursuing the MS Office Specialist Certification for MS Office Access.

COURSE AGENDA

  • Create Subqueries, edit run and delete query
  • Create Unmatched and Duplicate Queries
  • Group and Summarize Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Analyze Tables
  • Create a Junction Table
  • Improve the Table Structure
  • Create a Macro
  • Attach a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Display a Calendar on a Form
  • Organize Information with Tab Pages
  • Display a Summary of Data in a Form
  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Create a Report Snapshot
  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database
  • Previewing a table, form or report
  • Changing orientation and paper size
  • Printing options within Access