Access Windows 97: Intermediate

Course Code: ACCW97-2 Time: 7 hours

Prerequisites: Access Windows 97: Introduction

Queries and Calculations Query Review Query Criteria AND Conditions OR Conditions AND and OR Together The New Object Button Multiple Table Queries Editing Relationships Expressions Unique Values The All Fields Asterisk * "A Query Finds Things That Match"... NOT Null (and void?) Matching a List Parameters Calculations in Queries Calculated Fields Zooming In Summary Expressions Action Queries Manipulating Tables with Action Queries Make Table Queries Delete Queries Update Queries Append Queries Working With Forms AutoForms Review Creating a Form From Scratch Create the Form Define The Form Size Place the Controls on the Form What is a control? The Field List The Toolbox Moving and Sizing Controls Testing the Form

Customize the Controls Control Properties Control Names Tab Order Binding Controls to Fields Multi-Line Text Boxes Input Masks The Input Mask Wizard Validation Rules Validation Text Calculated Controls Using Filters with Forms Filter by Selection Filter By Form Advanced Filter/Sort Saving and Reusing Filters Printing Forms Creating a Command Button Tab Stops Formatting Forms Fonts Format Attributes Alignment The Alignment Grid Lines and Rectangles Adding Images Editing Labels Editing & Formatting Reports Grouping Moving Controls Between Bands Page Numbering Page Breaks Formatting a Report Fonts Format Attributes

Return to Course Listing | Home Page