Access Windows 2000: Intermediate

Course Code: ACCW00-2 Time: 7 hours

Prerequisites: Access Windows 2000: 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 * NOT Queries Null (and void?) Matching a List Parameters Calculations in Queries Calculated Fields Zooming In Summary Expressions Action Queries Manipulating Tables with Queries Make Table Queries Delete Queries Update Queries Append Queries Working With Forms AutoForms Review Creating a Form From Scratch 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 & Text Calculated Controls Filters Filter by Selection Filter Excluding 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 Lines and Rectangles Adding Images Editing Labels Editing & Formatting Reports Grouping Moving Controls Page Numbering Page Breaks Formatting a Report with Fonts Format Attributes Appendix Database Security Creating a New Workgroup Activating the Logon Procedure Outsmarting the Admin The Security Wizard Assigning User Permissions

Return to Course Listing | Home Page