Delegates explore the concept of relational databases using MS Access to build their own database, learning along the way to view data, produce simple reports and interrogate files. Knowledge of Windows 95/98/2000/NT is assumed to attend this two day course.
Getting Started The Opening Screen, Accessing a Database
Tables Creating & Linking Tables, Field Types, Primary Key, Restructuring
Forms Build Forms, View Add & Save Records, Set Properties, Calculation & Validation
Queries Create Query, Join Tables, Sort Filter & Find, Print a Dynaset
Reports Create & Save Reports, Group Data, Preview & Print, Mailing Labels
Graphs Add a Graph to a Report, Edit Graphs
Introducing Macros Create a Macro, Save & Run, Command Button Macros