You can use Microsoft Access 2007 to manage your data efficiently using advanced techniques. There are many advanced methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates retrieving and validating data, using subforms and subreports, as well as applying conditional formatting in Access 2007 tables, forms, and reports. Advanced query methods make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a way that the data is easy to interpret and analyze. This course describes the various types of join and parameter queries that can be used in Access 2007 and provides demonstrations on the use of action queries, including update, append, delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries.
Target Audience
Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.
Prerequisites
The Skillsoft Microsoft Office 2007: Beginning Access learning path; familiarity with a Windows user environment
Lesson Objectives
Retrieve Related Data in Access 2007
- add a lookup field to an Access 2007 table
- add a subdatasheet to a table
Working with the Attachment Feature in Access 2007
- add attachments to Access 2007 records
Validate Data in Access 2007
- implement data validation in Access 2007
Retrieving and Validating Data in Access 2007
Use Subforms, Subreports, and Conditional Formatting in Access 2007
- add Subforms to an Access 2007 database
- add Subreports to an Access 2007 database
- apply conditional formatting to a form in Access 2007
Adding Subforms, Subreports, and Formatting to an Access 2007 Database
Joins and Parameter Queries in Access 2007
- create and edit joins in Access 2007 databases
- create and use simple parameter queries
Action Queries in Access 2007
- create and run update and append queries in Access 2007
- create and run a make table query
- delete data from an Access 2007 database
Access 2007 Queries and SQL
- create union queries in Access 2007
- recognize how to create or modify Access 2007 tables and indexes using data-definition queries
- perform SQL processing on a server
- edit the SQL of a SELECT query and use subqueries
Using Joins, SQL, and Action Queries in Access 2007
Using SQL in Access Queries
|
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: Advanced Access
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Access 2007: Advanced
• 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
|