Access Windows 2000: Introduction

Course Code: ACCW00-1 Time: 7 hours

Prerequisites: Windows: Introduction

The Basics What is a Database? Flat File Databases Table Structure & Field Names Relational Databases Windows 95/98 Screen Elements Access Screen Elements Personalized Menus Shortcut Menus Office Assistant Viewing Data Opening a Database The Database Window Object Types Moving Around in Tables Manipulating Table Display Changing Column Size Freezing Column Display Rearranging Columns Finding Record Contents Replace Sorting the Table Table Design Viewing Table Design Creating a New Database Designing Tables Data Types Saving the Table Structure Modifying Table Design Inserting, Deleting & Moving Fields Primary Key Field Multiple Field Primary Keys Data Entry Adding and Editing Data Saving Table Records Adding Records in Data Entry Deleting Records Data Entry Shortcuts Field Properties

Queries What is a Query? Adding Fields to the QBE Grid Running the Query Saving and Closing The Query Displaying Query Design View Moving & Deleting Fields Sorting the Dynaset Query Criteria Show: The * Field Relational Operators Wildcard Operators Multi-table Queries Table Names Calculations in Queries Summary Functions Calculated Fields Tips on Developing Queries Using Forms Using Forms Reports Report Basics Report Wizards Creating an AutoReport Print Preview Report Design View A Report From Scratch Creating a Blank Report Adding Report Controls The Field List Moving and Sizing Controls The Toolbox Fonts, Lines and Rectangles Page Setup and Printing Quick and Easy Exit

Return to Course Listing | Home Page