CTS Training

This course is designed for people who are basic users of Access databases whoc wish to create effective queries and present the data in professional reports.

Duration:

1 Day

Audience:

This course is for individuals who are working with an existing database and needs to learn how to create queries and build reports..

Prerequisites:

Access Introduction or experience using an Access database. Basic understanding of Access structure, records, fields and data.

Course Content:

Creating Queries

• Select Queries
• Using And, Or, Not and Between operators
• Creating a Calculated Field
• Using data from multiple tables

Action Queries

• Update queries
• Append queries
• Delete queries
• Make table queries

Interacting with the User

• Parameter queries
• Using data from a form field inside a query

Reporting

• Using queries for Reports
• Grouping and Sorting Data in  a report
• Using Headers and Footers
• Report Layouts 
• Creating Calculated fields in the report

Advanced Report Techniques

• Using parameter information in the Report heading
• Using Subreports
• Grouping techniques
• Forcing page breaks in a report
• Troubleshooting

Putting it all together Workshop

• This workshop activity is designed to give participants time to transfer what they have learned into practical use.