Access 2002/3 Queries & Reports

Target Audience

New or inexperienced users of Microsoft Access, those upgrading from a previous version of Access or migration from another relational database package wanting to work with an existing database application to generate queries and reports.

Pre-requisites

To fully benefit from this course, attendees are expected to be familiar with Windows and use of the keyboard and mouse. Knowledge of a previous relational database package would be useful, although not essential.

On completion of the course, delegates will be able to:

• Understand some elementary database theory
• Start and exit Access and understand how Access works
• Make changes to data in a table
• Format data in tables
• Sort and filter data in a table
• Create and use queries to locate and display data
• Create a form for data entry or data viewing in Access
• Create reports in Access
• Work with forms
• Create, modify, and save reports
• Preview and print a range of objects
• Produce reports with calculations
• Add records to a relational database
• Import data into an Access table from a variety of sources
• Work with records in a relational database
• Use a range of data validation techniques to protect data integrity
• Create simple queries using more than one table
• Create select queries for a relational database
• Understand table and query relationships

Access Basics

Database Theory • The Standard Access Layout  • Other Possible Screen Layouts

Data Tables

Navigating in a Table • Editing/Deleting Records • Sub-Datasheets • Moving/Freezing/Hiding/Unhiding Columns • Formatting a Data Table  • Sorting & Filtering • Saving Records v Saving Layout/Design Changes

Select Queries

Define a Select Query  • Set Sort Options  • Use Filter Options  • Use Totals to Summarise Data

Relational Queries

Understand Table Joins  • Modifying Join Types

Forms

Create a Form from a Table or Query  • Create a Sub Form Using the Wizard  • Entering Data in Form View  • Using Filter By Form • Add/Edit/Delete Records in Form View  • Find Records

Reports

Create a Report from a Table or Query  • Use the Report Wizard  • Create a Grouped Report • Report Formatting Basics  • Use a Text Box for Calculations in a Report

Printing

Print a Datasheet or Report  • Change the Page Setup options  • Print Part of a Datasheet or Report

You may also be interested in some of the following related courses below:

Microsoft - Access 2002/3 - Creating Databases
Microsoft - Access 2002/3 - Power User
Microsoft - Access 2002/3 - VBA

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.