Access Windows 97: For the Corporate User

Course Code: ACCW97-C Time: 7 hours

Prerequisites: Windows 95: Introduction

The Basics Starting Microsoft Access Access Screen Elements The Database Window Object Types Moving Around in Tables Navigation Buttons Using the Scroll Bars Sorting Data Viewing Table Design Adding and Editing Data Adding Data Saving Table Records Deleting Records Editing Data Queries and Calculations Queries 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 Queries Make Table Queries Delete Queries Update Queries Append Queries

Working With Reports AutoReports Review Creating a Report From Scratch Creating the Report Defining The Report Size Defining Report Sections Placing Controls on the Report What is a Control? The Field List The Toolbox Moving and Sizing Controls Previewing the Report Customize the Controls Control Properties Control Names Binding Controls to Fields Input Masks The Input Mask Wizard Calculated Controls Formatting Reports Fonts Format Attributes Alignment The Alignment Grid Lines and Rectangles Adding Images Editing Labels Grouping Moving Controls Between Bands Page Numbering Page Breaks 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