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