Advanced Data Management in Access 2007

Overview/Description
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

Expected Duration (hours)
3.5

Lesson Objectives

Advanced Data Management in Access 2007

add a lookup field to an Access 2007 table

add a subdatasheet to a table

add attachments to Access 2007 records

implement data validation in Access 2007

add a lookup field to a table

add a subdatasheet to a table |w

use Expression Builder to construct a rule

add Subforms to an Access 2007 database

add Subreports to an Access 2007 database

apply conditional formatting to a form in Access 2007

add a subform to an existing form

apply conditional formatting to a form

add a subreport to a database

create and edit joins in Access 2007 databases

create and use simple parameter queries

create and run update and append queries in Access 2007

create and run a make table query

delete data from an Access 2007 database

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

specify a join in a query

create and run a parameter query

create and run an update query

edit the SQL of a SELECT query

use SQL to create Access 2007 queries