Cover image for Microsoft Access 2002 : 10 minute guide
Title:
Microsoft Access 2002 : 10 minute guide
Author:
Habraken, Joseph W., 1954-
Personal Author:
Publication Information:
Indianapolis, Ind. : Que, [2002]

©2002
Physical Description:
v, 213 pages : illustrations ; 21 cm.
General Note:
Includes index.
Language:
English
Title Subject:
Subject Term:
ISBN:
9780789726315
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 H247 2002 Adult Non-Fiction Central Closed Stacks
Searching...
Central Library QA76.9.D3 H247 2002 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Because most people don't have the luxury of sitting down uninterrupted for hours at a time to learn Excel, this 10-Minute Guide focuses on the most often used features, covering them in lessons designed to take 10 minutes or less to complete. In addition, this guide teaches the user how to use Excel without relying on technical jargon, and by providing straightforward, easy-to-follow explanations and lists of numbered steps that tell the user which keys to press and which options to select.


Author Notes

Joe Habraken is a computer technology professional and best-selling author with more than fifteen years of experience in the information technology field as a network administrator, consultant, and educator. His recent publications include Microsoft Office XP 8-in-1, The Absolute Beginner's Guide to Networking (Second Edition), and Practical Cisco Routers. Joe currently serves as the Director of UNEit, an IT training center for computer industry professionals at the University of New England in Portland, ME.


Table of Contents

Introductionp. 1
1 What's New in Access 2002p. 5
Understanding Access 2002p. 5
Introducing Other Access Objectsp. 6
What's New in Access 2002p. 7
Introducing Task Panesp. 8
Introducing Voice Dictation and Voice Commandsp. 9
2 Working in Accessp. 16
Planning a Databasep. 16
Starting Accessp. 21
Parts of the Access Screenp. 23
Exiting Accessp. 25
3 Creating a New Databasep. 26
Choosing How to Create Your Databasep. 26
Selecting a Database File Typep. 27
Creating a Blank Databasep. 28
Closing a Databasep. 30
Creating a Database from a Templatep. 30
Opening a Databasep. 36
4 Creating a Table with the Table Wizardp. 38
Tables Are Essentialp. 38
Working with the Table Wizardp. 38
5 Creating a Table from Scratchp. 43
Creating Tables Without the Wizardp. 43
Creating a Table in Table Design Viewp. 44
Setting the Primary Keyp. 47
Understanding Data Types and Formatsp. 49
Creating a Table in the Datasheet Viewp. 51
6 Editing a Table's Structurep. 53
Editing Fields and Their Propertiesp. 53
Adding, Deleting, and Moving Fieldsp. 57
Deleting a Tablep. 58
7 Entering Data into a Tablep. 59
Entering a Recordp. 59
Moving Around in a Tablep. 60
Hiding a Fieldp. 61
Freezing a Columnp. 63
Using the Spelling Featurep. 64
Closing a Tablep. 65
8 Editing Data in a Tablep. 66
Changing a Field's Contentp. 66
Moving and Copying Datap. 69
Inserting and Deleting Fieldsp. 69
Inserting New Recordsp. 70
Deleting Recordsp. 71
9 Formatting Access Tablesp. 74
Changing the Look of Your Tablep. 74
Changing Column Width and Row Heightp. 74
Changing the Font and Font Sizep. 77
10 Getting Help in Microsoft Accessp. 80
Help: What's Available?p. 80
Using the Ask a Question Boxp. 80
Using the Office Assistantp. 82
Using the Help Windowp. 84
Getting Help with Screen Elementsp. 89
11 Creating Relationships Between Tablesp. 90
Understanding Table Relationshipsp. 90
Creating a Relationship Between Tablesp. 91
Enforcing Referential Integrityp. 94
Editing a Relationshipp. 97
Removing a Relationshipp. 97
12 Creating a Simple Formp. 98
Creating Formsp. 98
Creating a Form with AutoFormp. 99
Creating a Form with the Form Wizardp. 100
Creating a Form from Scratchp. 103
Entering Data into a Formp. 108
13 Modifying a Formp. 109
Cleaning Up Your Form: An Overviewp. 109
Moving Field Controlsp. 109
Moving Controls and Field Labels Independentlyp. 111
Changing Label and Control Sizesp. 112
Viewing Headers and Footersp. 113
Adding Labelsp. 115
Formatting Text on a Formp. 117
Changing Tab Orderp. 118
14 Adding Special Controls to Formsp. 121
Using Special Form Controlsp. 121
Creating a List Box or a Combo Boxp. 123
Creating an Option Groupp. 126
Adding Command Buttonsp. 129
15 Searching for Information in Your Databasep. 132
Using the Find Featurep. 132
Using the Replace Featurep. 135
16 Sorting, Filtering, and Indexing Datap. 137
Finding and Organizing Your Datap. 137
Sorting Datap. 137
Filtering Datap. 140
Indexing Datap. 143
17 Creating a Simple Queryp. 145
Understanding Queriesp. 145
Using the Simple Query Wizardp. 146
Using Other Query Wizardsp. 149
Understanding Access Query Typesp. 150
18 Creating Queries from Scratchp. 152
Introducing Query Design Viewp. 152
Adding Fields to a Queryp. 155
Deleting a Fieldp. 156
Adding Criteriap. 157
Using the Total Row in a Queryp. 159
Viewing Query Resultsp. 161
19 Creating a Simple Reportp. 163
Understanding Reportsp. 163
Using AutoReport to Create a Reportp. 163
Creating a Report with the Report Wizardp. 165
Viewing and Printing Reports in Print Previewp. 168
20 Customizing a Reportp. 170
Entering Report Design Viewp. 170
Working with Controls on Your Reportp. 172
Placing a Calculation in the Reportp. 175
21 Taking Advantage of Database Relationshipsp. 178
Reviewing Table Relationshipsp. 178
Viewing Related Records in the Datasheet Viewp. 180
Creating Multi-Table Queriesp. 181
Creating Multi-Table Formsp. 183
Creating Multi-Table Reportsp. 186
22 Printing Access Objectsp. 189
Access Objects and the Printed Pagep. 189
Printing Reportsp. 189
Printing Other Database Objectsp. 191
Using the Print Dialog Boxp. 193
Indexp. 195

Google Preview