ACC-207
 Access  2007 Intermediate

Course Length: 1 day

*Prerequisite*
Introduction to Access or equivalent working knowledge

Course Contents

Introduction

 

Modifying the Design of a Table

·       Specifying a required field/defining field value

·       Setting a primary key for a table

·       Adding a memo field to a table

 

Working with Multiple Tables

·       Displaying multiple tables on the Access desktop

·       Resizing and repositioning the table window

 

Relating Tables

·       Creating a relationship between two tables in a database

·       Displaying and using a subdatasheet

 

Working with a Custom Form

·       Designing a custom form

·       Adding a header and a footer to a form

·       Using a custom form to enter data

 

Intermediate Query Techniques

·       Creating a query to extract information from multiple tables

·       Creating a query to generate summary information

·       Creating a crosstab query

·       Creating a query to find unmatched records in a table

·       Creating a query to find duplicate records in a table

 

Intermediate Report Techniques

·       Creating a report of information in multiple tables

·       Adding a calculated control to a report

 

Additional Intermediate Access Features

·       Adding a lookup field to a table

·       Defining an input mask for a field

·       Viewing object dependencies

·       Exporting an Access datasheet to Microsoft Office Excel

 

 

 

 

 

Home
Solaris Programming Microsoft Desktop Linux Cisco Security
About SYSTEMS Computer Training
Contact Us

 

© 2003-2004 SYSTEMS Computer Training, A Testmasters Company

 

Solaris and Java are registered trademarks of Sun Microsystems.