MICROSOFT OFFICE 2003 – DATABASES INTERMEDIATE
Module 2 – Intermediate - Microsoft Access
SECTION 1 – REPORTS |
The Purpose of a Report |
Creating a Report Using the Wizard |
Creating an AutoReport |
Creating a Blank Report |
Amending Report Design |
Printing A Report |
SECTION 2 – SUB FORMS |
SubForms |
Using the Subform/Subreport Wizard |
Using an Existing Form as a Subform |
Using the Form Wizard to create a Form with Subform |
SECTION 3 – ENHANCING FORM PRESENTATIONS |
Enhancing Form Presentation |
SECTIONs |
Rulers and Grid |
Sizing a Control |
Moving a Control |
Deleting a Control |
Adding Text Labels |
Changing the Appearance of a Control |
Changing Properties |
Changing the Tab Order |
Adding Command Buttons |
SECTION 4 – ACTION QUERIES |
Action Queries |
Update Query |
Make Table Query |
Delete Query |
Append Query |
Calculated Fields in Queries |
Creating Calculated Field |
Using the Expression Builder |
Update Query – New Field |
Cross Tab Query |
SECTION 5 – PARAMETER QUERIES |
Parameter Queries |

