Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores the use of the Query Wizard and demonstrates how to create or modify a query in Design view in order to achieve specific results. This course also covers Expression Builder, calculated fields, grouping options for displaying query results, and crosstab, unmatched, and duplicate queries. The use of the Report, Report Wizard, Blank Report, Report Design, and Label options are covered, as well as how to add and bind controls, group and sort data, and modify sections of a report.
Target Audience
End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.
Prerequisites
Familiarity with a Windows environment
Lesson Objectives
Create Queries in Access 2007
- create a simple query in design view
- create a simple query using the Simple Query Wizard
Refine a Query in Access 2007
- modify a query in Access 2007
- create an expression with the Expression Builder
Add Calculations to a Query in Access 2007
- use calculated fields and grouping in Access 2007
Crosstab Queries in Access 2007
- create a crosstab query in Access 2007
- refine a crosstab query in Access 2007
Unmatched and Duplicate Queries in Access 2007
- find unmatched queries in Access 2007
- find duplicate queries in Access 2007
Creating and Modifying an Access 2007 Query
Creating and Using Reports in Access 2007
- create a basic report in Access 2007
Adding Controls to Access 2007 Reports
- add a control to an Access 2007 report
Organizing Access 2007 Reports
- recognize how to modify Access 2007 reports
- add a group and calculated summary to a report in Access 2007
Creating and Modifying an Access 2007 Report
|
Key Concepts:
|
|
Desktop Certifications, Microsoft, Microsoft Certified Application Specialist Certification, 77-605 Using Microsoft Office Access 2007, Desktop Curricula, Microsoft Office 2007, Microsoft Office 2007: Beginning Access
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Access 2007: Basics
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)
|
|
|
Courses you might be interested in:
|
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007
|