asdeducation.net

Access

     

 

 

Intermediate Access Skill Sets

 

       

 

 

Entering Data II

Entering data into a table using forms

Searching records using fields in forms

Creating new records using forms

Updating records using forms

Deleting records
 

 

 

Manipulating Tables

Creating a subdatasheet

Filtering table records

Joining Tables

Restricting records in a join

Adding a new filed

Deleting a field from a table

Using a an update query

Using a delete query to delete a set of records
 

 
 
 
 
 
 
 
 
 

 

 

Filtering Data in Queries

What is a data filter

How to create a data filter in a query

How to filter dates in a query

How to sort data in fields in a query
 

 

 

Queries II

Writing query results in a new table

How to create an update query

How to create a crosstab query

Identifying the purpose of a query

Multiple queries

Using text for a query

Using numeric data in criteria

Using AND criteria

Using OR criteria
 

 

 

Working with Fields

Field properties

Primary keys

Index ex
 

 

 

Working with Forms II

Adding and deleting form controls

Modifying control properties

Adding a sub form

Modifying sub form views
 

 

Creating Data Reports II

How to filter results in report.

Reports that sort data in fields.

How to create a report with a parametric filter.

inserting report controls

formatting report controls

sizing to the grid

aligning to the grid

adjusting spaces between controls

copying controls

grouping controls

deleting controls
 

 

 

  Publishing Reports

publishing a report on paper

publishing to word

publishing to email
 

 

 

Importing & Exporting Data

Importing data from Excel

Exporting data from Excel

Exporting to Outlook/Excel

Using mail merge
 

 

 

 

 

© 2002 - 2006 The American School of Durango Education Network. All Rights Reserved
| PRIVACY | Terms of Use