Email a Friend
Print
Add to Outlook
Event Information
Date
11/18/2008 - 11/20/2008
Time
6:00 PM - 8:30 PM
Venue
Carmichael Hall
Cost
85.00
Audience
General Audience
Additional Information
You’ll learn to create effective data analysis functionality using queries and reports. Build effective queries that provide the basis for much of the user interface and reporting of data. Create professional reports to convey key data to individuals who need it most.
Target Audience Individuals who are new to computers or inexperienced with database design.
Designing Multiple Table Queries
Create a select query
Specify query criteria
Create a query using multiple tables
Sort queries on multiple fields
Understand and create AND/OR queries
Create a calculated field
Build a summary query
Create a parameter query
Creating & Using Reports
Plan and create a report
Use and discuss report sections
Modify reports in Design View
Group records in the report
Modify sort order
Add calculated fields
Align and format controls
Preview and print a report
Create mailing labels
Sharing Information & Improving Reports
Advanced report formatting
Create a summary report
Create reports based on queries
Format report data using calculated fields
Utilize concatenation
Export data for users of other applications
Class Activity
In addition to the instructor-led tutorials, students will create a report capable of displaying an invoice for a small retail business.
