Access 7

An overview of Access; defining a new database, creating tables; defining a new table; defining field properties; creating table indexes; entering and editing data; managing data; relationships between tables; defining the other tables in the database; designing a basic query sorting the dynaset; using query criteria; more complex queries; designing and using screen forms; customizing forms; forms without Wizards; using report Wizard and AutoReport; grouped reports; mailing label reports; customizing a report; types of form controls; adding controls to forms;using filters to select records; using controls in reports; adding lines and rectangles; style enhancements; special effects, colours and borders; control default properties; report and form templates; report and form graphs; forms and reports pictures; using multiple tables in a query; main/subforms and main/subreports; action queries; importing databases; importing text/spreadsheets; exporting a table; using the clipboard to transfer data; creating and editing macros; creating macro groups; assigning macros to keys; assigning macros to events; macros for data validation; a database applications. Quick reference 1 - basic Windows operations; quick reference 2 - data and data definitions; quick reference 3 - access toolbar buttons.