Access Windows 2: Introduction

Course Code: ACCW2-1 Time: 7 hours

Prerequisites: Windows: Introduction

The Basics What is a Database? Card File Starting Microsoft Access Windows Screen Elements Mouse, Menu, Keyboard, Icons Viewing Database Tables Opening a Database Database Window Objects Opening a Table Moving Through the Table Navigation Buttons Navigating Using the Scroll Bars Navigating Using the Menu Navigating Using the Keyboard Freezing/Unfreezing Column Displays Changing Column Size Selecting Multiple Columns/Rows Moving Around in Dialog Boxes Find Using Help Sorting the Table Creating a Table Datasheet View vs Design View Table Design Designing Database Tables Creating a New Table Using Wizard Modifying Table Design Key Fields Adding Fields in Design View Moving Fields in Design View Deleting Fields in Design View Creating a Table Using New Table Field Properties

Adding and Editing Data Adding and Saving Data Data Entry Shortcuts Inputting Data Moving Around and Editing Inserting and Deleting Records Editing Data Selectively Retrieving Information What is a Query? Defining a New Query Selecting Fields Table Names Manipulating Fields Replacing, Inserting, Moving or Deleting Sorting the Dynaset Show: Specifying Criteria Comparison Operators Wildcard Operators OR Criteria Saving and Running a Query Multi-table Queries Calculations in Queries Summary Functions Calculated Fields Tips on Developing Queries Using Forms Using Forms Using Tabular AutoForm Wizard Reports The Report Wizards Report Design Report Sections Manipulating Report Controls Quick and Easy Exit

Return to Course Listing | Home Page