CTS Training

This course is designed for people who are existing users of Access databases and wish to be able to modify and enhance existing databases. The course covers the features that are used to create more advanced queries, forms and reports, and expressions to effectively manipulating data.

Duration:

2 Days

Audience:

Students who need to learn skills required to create or modify queries, forms and reports in an existing database.

Prerequisites:

Access Introduction or experience using an Access database. To gain the most from the course, participants must be familiar with database structure, tables, fields and properties.

Course Content:

Creating Complex Reports

• Using queries for Reports
• Grouping Data in a report
• Adding Headers and Footers
• Report Layouts - stepped & blocked
• Creating a Running Summary
• Using Columns in report
• Using the Keep Together property
• Sorting Report output
• Creating Labels

SubForms & SubReports

• Using sub-forms and sub-reports to display data from two different tables or - queries.
• Using Link Child and Link Master fields

Expressions & Expression Builder

• Manipulating Text with expressions
• Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
• Using Conditional IIF() expressions
• Aggregate Functions - Sum(), Avg(), Count()
• Referring to subform/subreport controls in expressions

Automating Forms with Buttons

• Using the Control wizard to add a command button to a form
• Form Operations
• Record Operations
• Report Operations
• Formatting command buttons