Advanced Access Training Course

Advanced Access Training Course

The Advanced Access training course targets existing Access users they are already familiar with Access to construct tables and forms but want to use the Access to process and analyze data, or to prepare management reports. After finishing the course, delegates will be able to create queries to manage data and to create a one touch button reports

Advanced Access Training Course

You'll Learn

Using Access Query

  • Query overview
  • Running a Query
  • Creating Query using Query Wizard
  • Designing a customized Query

Using Advanced Query Features

  • Joining Tables in Queries
  • Creating a calculated field
  • On demand Query
  • Other Options-specify criteria, sort records, calculate totals, set properties
  • Aggregate queries
  • About aggregate functions ( group by , expression, where )

Using Action Queries

  • make-table queries,
  • delete queries,
  • append queries,
  • update queries

Report and Report Design

  • Report overview
  • Working with reports
  • Creating, Modifying a Report
  • Standard Report by Report Wizard (AutoReport)

Using Advanced Report Features

  • Designing Customized Report
  • Adding calculate totals and averages
  • Customize controls
  • Customzed headers and footers
  • Grouping and Sorting records
  • Creating On-Demand Reports

課程班別
 
AAC4042 - 廣東話 19 Apr enrol
 
AAC4044 - 廣東話 26 Apr enrol
 
AAC4052 - 廣東話 20 May enrol
 
AAC4053 - 廣東話 29 May enrol
 
AAC4064 - 廣東話 12 Jun enrol
相關課程
  Access
  Access SQL
  Access VBA Programming
  Advanced Access
  Excel VBA X ChatGPT/GPT
  Excel Dashboards and Reports
  Excel-Advanced
  Excel-formulas & functions