Computer Based Training: …, Windows 95 & NT Basics/a1454501.iso/mo97a03/AA_AIM.TXT

Text File | 1997-05-06 | 1.2 KB | 47 lines

To introduce you to queries in general and select queries in particular in Microsoft Access
|
@B½╗@b explain what a query is in Access

@B½╗@b describe the different types of query you can
     define in Access

@B½╗@b explain how to define a select query with or
     without a wizard

@B½╗@b use the Simple Query Wizard to define a
     select query

@B½╗@b describe ways in which you can modify
     existing queries

@B½╗@b modify an existing query
@@
To introduce you to total, crosstab, and action queries
|
@B½╗@b explain the uses of total and summary queries,
     and describe how to create them

@B½╗@b describe what a crosstab query is

@B½╗@b create a crosstab query from an existing query

@B½╗@b describe the types and uses of action queries

@B½╗@b explain how to create and run an update query
@@
To introduce you to ways of automating your database using macros
|
@B½╗@b describe what macros are and how
     you can use them to automate tasks in Access 97

@B½╗@b explain how to create and test simple macros

@B½╗@b create and test a macro that will
     run automatically when you open your database

@B½╗@b describe some of the ways to run macros

@B½╗@b make changes to a macro group
@@