Mouse to Keys Access97 gives clear keyboard instructions on how to design and use a database.

Access97 has some great new features:

Automatically establishes relationships between tables and queries.

Provides Links to Word and Excel so that Reports can be designed in your preferred program.

 

MICROSOFT ACCESS 97

SECTION 1 DATABASE OBJECTS

TOPIC 1 DESIGNING A DATABASE

1.1 Steps In Designing A Database

1.2 Common design problems

1.3 Primary Key Fields and Relationships

TOPIC 2 TABLES

2.1 Create a Table in a Datasheet or use Wizards.

2.2 Create or Modify a Table in Design View

2.3 Field Properties

2.4 Relationships And Primary Keys

TOPIC 3 QUERIES

3.1 Create Queries using Wizards

3.2 Create a Query in Design View

3.3 Specifying Criteria

TOPIC 4 FORMS

4.1 Create a Form using the Form Wizard

4.2 Create a Form in Design View.

4.3 Subforms

TOPIC 5 REPORTS

5.1 Create a Report using the Wizard

5.2 Mail Label Wizard

5.3 Create a Report in Design View

5.4 Create a Report in a Word Document using Office Links

TOPIC 6 MACROS

6.1 Create a Macro

TOPIC 7 MODULES

7.1 Class Modules

SECTION 2 MENU BAR

TOPIC 1 FILE MENU

1.1 Create a New Database and Open a Database

1.2 Saving and Closing Objects

1.3 Printing Objects

TOPIC 2 EDIT MENU

2.1 Cut or Copy or Delete

2.2 Find and Replace

2.3 Cursor Movement Keys and Selecting Data

TOPIC 3 View Menu

3.1 View Menu in Database Window

3.2 View Menu in Object Windows

TOPIC 4 Insert menu

4.1 Insert Objects, Records, Fields

TOPIC 5 FORMAT MENU

5.1 In Open Table or Query.

5.2 In Form Design View and Report Design View

TOPIC 6 RECORDS MENU

TOPIC 7 QUERY MENU

TOPIC 8 Tools menu

8.1 Spell Checking

8.2 AutoCorrect

8.3 Analysing A Database

8.4 Securing a Database

8.5 Macro

8.6 User Options

TOPIC 9 Help

9.1 What's This?

9.2 Office Assistant

9.3 Index and Contents

9.4 Navigating Windows Help Screens.

TOPIC 10 SHORTCUT KEYS

Mouse to keys Price List

Mouse to Keys Windows95

Mouse to Keys Word97

Mouse to Keys Excel97

Return to Main Page