Microsoft Office Access 2003 QuickSteps / Edition 1

Microsoft Office Access 2003 QuickSteps / Edition 1

4.0 1
by John Cronan, Virginia Andersen, Brenda Andersen

ISBN-10: 0072232293

ISBN-13: 9780072232295

Pub. Date: 02/25/2004

Publisher: McGraw-Hill Professional Publishing

Learn Instantly from Step-by-Step Graphics!

We know a picture is worth a thousand words—so we went heavy on pictures and light on words in this easy-to-use guide. Color screenshots and brief instructions show you how to use all the powerful Access features in no time. Follow along and learn to create and use databases, enter and retrieve data, present your

…  See more details below


Learn Instantly from Step-by-Step Graphics!

We know a picture is worth a thousand words—so we went heavy on pictures and light on words in this easy-to-use guide. Color screenshots and brief instructions show you how to use all the powerful Access features in no time. Follow along and learn to create and use databases, enter and retrieve data, present your information in forms and reports, and so much more. Each chapter’s “How to” list and color-coded tabs make it easy to flip straight to the tasks you need to do. Get the book that gets you started using Access right away.

In Each Chapter:

  • Shortcuts for accomplishing common tasks
  • Helpful reminders or alternate ways of doing things
  • Bonus information related to the topic being covered
  • Errors and pitfalls to avoid
  • Screenshots with callouts show and explain exactly what you’ll see on your computer screen while you’re doing a task

John Cronan has been writing and editing computer-related materials for more than 12 years and is the author of Microsoft Office Excel QuickSteps.

Virginia Andersen has written or contributed to more than 35 computer books, including Access 2003: The Complete Reference and How to Do Everything with Access 2003. She has more than 25 years of computer experience.

Brenda Bryant Anderson has spent more than 10 years training individuals on a wide range of Microsoft products. She is currently an instructor of beginner through advanced computer applications at the collegiate level.

Read More

Product Details

McGraw-Hill Professional Publishing
Publication date:
Quicksteps Series
Product dimensions:
8.00(w) x 10.10(h) x 0.45(d)

Table of Contents

Conventions Used in this Bookxii
Chapter 1Stepping into Access1
Start Access1
Starting Access2
Use the Start Menu to Start Access2
Tour the Database Window3
Open a Database5
Open Older Databases9
Using Task Panes10
Change the Default Access File Format10
Find a Database11
Personalize Access12
Remove the Getting Started Task Pane12
Select a Toolbar to Display12
Customize a Toolbar13
Using Toolbars14
Show Full Menus14
Using the Keyboard in Access15
View Shortcut Keys15
Rearrange Object Windows15
Using the Keyboard in Windows16
Using Help18
Get Help18
Open Help18
End Your Access Session19
Close a Database19
Close Access20
Chapter 2Creating a Database21
Create the Database Framework21
Use a Database Template23
Get Access Samples from Microsoft's Office Online28
Build a Database on Your Own32
Build the Framework with Tables34
Start the Table Wizard34
Selecting Tables and Fields from the Table Wizard36
Create a Table with Data Entry39
Build a Table in Design View41
Assigning a Primary Key44
Add Identifying Information45
Identify Relationships45
Define Relationships45
Relate Tables46
Enforce Referential Integrity48
Chapter 3Modifying Tables and Fields49
Make Basic Changes to Tables and Fields50
Delete a Table50
Rename a Table51
Change Field Names51
Fine Tune the Fields52
Switching Views53
Choose a Data Type53
Change Display of Data Through the Format Property54
Create a Pattern for Data Entry with Input Masks57
Editing and Entering Input Masks58
Establish a Field's Default Value60
Limit Field Values with a Validation Rule60
Require Entry but Allow a Zero Length String61
Use the Caption Field Property62
Index a Data Field63
Add Smart Tags64
Use the Lookup Wizard65
Display and Create Subdatasheets69
View a Subdatasheet69
Create a Subdatasheet70
Chapter 4Working in the Datasheet73
Enter and Edit Data75
Enter New Data in a Datasheet75
Use Keyboard Shortcuts in a Datasheet77
Moving Through Records78
Selecting Records, Fields, and Columns with the Mouse80
Insert Pictures80
Copy and Move Data81
Delete Records and Columns83
Find and Replace Text84
Verify Spelling86
Acquire Data88
Import Data from Outside Sources89
Paste Data into a Datasheet94
Arrange the Datasheet95
Insert Columns95
Adjust Column Width96
Changing How the Current Datasheet Looks97
Move a Column98
Rename a Column98
Hide and Unhide Columns98
Lock and Unlock Columns98
Adjust Row Height99
Chapter 5Retrieving Information101
Sort Data101
Sort Records in a Datasheet102
Sort Records in a Form104
Filter Data105
Filter by Selecting a Value105
Choosing a Filter106
Filter by Form107
Deleting or Removing a Filter108
Filter for an Input108
Use Operators and Wildcards in Criteria109
Running and Modifying a Saved Advanced Filter111
Use Advanced Filters111
Work with Queries113
Create a Simple Query with a Wizard113
Create or Modify a Query in Design View115
Using the Expression Builder119
Set Query Properties119
Chapter 6Creating Forms and Using Controls121
Create Forms121
Creating a Form Using AutoForm122
Get a Head Start with the Form Wizard122
Creating a Two-Table Form126
Create a Form in Design View126
Add Fields128
Explore the Toolbox Tools129
Using the Toolbox130
Modify the Form Design130
Choosing the Control Type133
Use Controls133
Add Bound Controls133
Add Unbound Controls137
Copy or Delete a Control140
Rearrange Controls140
Modify Controls144
Navigating in a Data Entry Form146
Chapter 7Working with Reports147
Create Reports147
Viewing Reports148
Use AutoReport to Create a Report149
Use the Report Wizard to Create a Report150
Create a Report in Design View154
Modify Reports
Group Data in Reports157
Calculate a Value158
Accomplishing Common Tasks in Reports159
Create a Subreport160
Create Labels162
Create a Report Snapshot164
Distribute a Report Snapshot166
Chapter 8Preparing Your Data for Presentation167
Improve the Data's Appearance167
Modify Images168
Add a Chart170
Using the Formatting Toolbar173
Use Graphics173
Modify the Form or Report Design174
Print Your Data176
Set Up the Print Job176
Review Data Before Printing180
Output the Print Job183
Choosing What to Print184
Chapter 9Securing and Administrating Access187
Establish User-Level Security187
Deciding Who Needs What Permissions188
Understand the User-Level Security Model188
Secure the Database with the User-Level Security Wizard188
Keeping Data Safe195
Apply Global Database Protection to a Database195
Use a Database Password196
Remove Database Objects from View198
Back Up and Restore a Database199
Database Administration203
Document a Database203
Compact and Repair a Database204
Chapter 10Extending Access205
Use Advanced Data Analysis Tools205
Create a Crosstab Query with a Wizard205
Create a PivotTable in Forms208
Create the PivotTable Layout210
Create a PivotChart212
Share Data213
Export Access Data213
Link Files214
Working with OfficeLinks215
Integrate Web Technology217
Add a Hyperlink field to an Existing Table217
Creating a Hyperlink to a File or Web Page218
Save Database Objects as Static Web Pages218
Create a Data Access Page with a Wizard220
Create a User Interface221
Create a Custom Dialog Box222
Add Command Button Controls to a Dialog Box222
Set Dialog Box Properties222

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network


Most Helpful Customer Reviews

See all customer reviews >

Microsoft Office Access 2003 QuickSteps 4 out of 5 based on 0 ratings. 1 reviews.
Bird48327 More than 1 year ago
A good review and restart for people who have used Access in the past. Easy to follow; good foundation builder.