The Basics
What is a Database?
Flat File Databases
Table Structure
Field Names
Relational Databases
Starting Microsoft Access
Windows 95 Screen Elements
Access Screen Elements
Shortcut Menus
Help!
The Help Button
Searching for Help
Viewing Data
Opening a Database
The Database Window
Object Types
Moving Around in Tables
Navigation Buttons
Navigating Using the Scroll Bars
Navigating Using the Menu
Navigating Using the Keyboard
Manipulating Table Display
Changing Column Size
Freezing Column Display
Rearranging Columns
Finding Record Contents
Sorting the Table
Table Design
Viewing Table Design
Designing Tables
Data Types
Saving the Table Structure
Modifying Table Design
Inserting and Deleting Fields
Deleting Fields
Moving Fields
Primary Key Field
Multiple Field Primary Keys
Data Entry
Adding and Editing Data
Adding Data
Saving Table Records
Adding Records in Data Entry
Deleting Records
Editing Data
|
Data Entry Shortcuts
Field Properties
Field Size
Format
Queries
What is a Query?
Starting the Query Process
Adding Fields to the QBE Grid
Running the Query
Saving and Closing the Query
Displaying Query Design View
Moving Fields
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
Manipulating Overall Report Design
A Report from Scratch
Creating a Blank Report
Adding Report Controls
The Field List
The Toolbox
Moving and Sizing Controls
Fonts
Lines and Rectangles
Page Setup and Printing
Quick and Easy Exit
|