Microsoft Office Access 2003 QuickSteps

( 1 )

Overview

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 ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (49) from $1.99   
  • New (4) from $2.47   
  • Used (45) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$2.47
Seller since 2007

Feedback rating:

(1451)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2004-03-01 Paperback Book 1st New. No dust jacket as issued. Trade Paperback. Normal shelf and display wear...

Ships from: Des Moines, IA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$3.96
Seller since 2007

Feedback rating:

(558)

Condition: New
2004-03-01 Paperback New 2004 Paperback. You are buying a Book in NEW condition with very light shelf wear to include very light edge and corner wear.

Ships from: Wilmington, NC

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.18
Seller since 2008

Feedback rating:

(17544)

Condition: New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$12.19
Seller since 2007

Feedback rating:

(23362)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

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 Show Less

Product Details

  • ISBN-13: 9780072232295
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 2/25/2004
  • Series: Quicksteps Series
  • Edition number: 1
  • Pages: 224
  • Product dimensions: 8.00 (w) x 10.10 (h) x 0.45 (d)

Meet the Author

Series editors Martin and Carole Matthews each have more than thirty years of computing experience. They have written 57 U.S. editions of 32 titles, a number of which have been critically acclaimed. Among their more recent books are: Windows XP, A Beginner’s Guide; FrontPage 2002: The Complete Reference; Windows 2000, A Beginner’s Guide; Office 2000 Answers, Certified Tech Support; Windows 98 Companion; and Windows 98 Answers, Certified Tech Support.

Read More Show Less

Table of Contents

Acknowledgments vi
Introduction xii
Conventions Used in this Book xii
Chapter 1 Stepping into Access 1
Start Access 1
Starting Access 2
Use the Start Menu to Start Access 2
Tour the Database Window 3
Open a Database 5
Open Older Databases 9
Using Task Panes 10
Change the Default Access File Format 10
Find a Database 11
Personalize Access 12
Remove the Getting Started Task Pane 12
Select a Toolbar to Display 12
Customize a Toolbar 13
Using Toolbars 14
Show Full Menus 14
Using the Keyboard in Access 15
View Shortcut Keys 15
Rearrange Object Windows 15
Using the Keyboard in Windows 16
Using Help 18
Get Help 18
Open Help 18
End Your Access Session 19
Close a Database 19
Close Access 20
Chapter 2 Creating a Database 21
Create the Database Framework 21
Use a Database Template 23
Get Access Samples from Microsoft's Office Online 28
Build a Database on Your Own 32
Build the Framework with Tables 34
Start the Table Wizard 34
Selecting Tables and Fields from the Table Wizard 36
Create a Table with Data Entry 39
Build a Table in Design View 41
Assigning a Primary Key 44
Add Identifying Information 45
Identify Relationships 45
Define Relationships 45
Relate Tables 46
Enforce Referential Integrity 48
Chapter 3 Modifying Tables and Fields 49
Make Basic Changes to Tables and Fields 50
Delete a Table 50
Rename a Table 51
Change Field Names 51
Fine Tune the Fields 52
Switching Views 53
Choose a Data Type 53
Change Display of Data Through the Format Property 54
Create a Pattern for Data Entry with Input Masks 57
Editing and Entering Input Masks 58
Establish a Field's Default Value 60
Limit Field Values with a Validation Rule 60
Require Entry but Allow a Zero Length String 61
Use the Caption Field Property 62
Index a Data Field 63
Add Smart Tags 64
Use the Lookup Wizard 65
Display and Create Subdatasheets 69
View a Subdatasheet 69
Create a Subdatasheet 70
Chapter 4 Working in the Datasheet 73
Enter and Edit Data 75
Enter New Data in a Datasheet 75
Use Keyboard Shortcuts in a Datasheet 77
Moving Through Records 78
Selecting Records, Fields, and Columns with the Mouse 80
Insert Pictures 80
Copy and Move Data 81
Delete Records and Columns 83
Find and Replace Text 84
Verify Spelling 86
Acquire Data 88
Import Data from Outside Sources 89
Paste Data into a Datasheet 94
Arrange the Datasheet 95
Insert Columns 95
Adjust Column Width 96
Changing How the Current Datasheet Looks 97
Move a Column 98
Rename a Column 98
Hide and Unhide Columns 98
Lock and Unlock Columns 98
Adjust Row Height 99
Chapter 5 Retrieving Information 101
Sort Data 101
Sort Records in a Datasheet 102
Sort Records in a Form 104
Filter Data 105
Filter by Selecting a Value 105
Choosing a Filter 106
Filter by Form 107
Deleting or Removing a Filter 108
Filter for an Input 108
Use Operators and Wildcards in Criteria 109
Running and Modifying a Saved Advanced Filter 111
Use Advanced Filters 111
Work with Queries 113
Create a Simple Query with a Wizard 113
Create or Modify a Query in Design View 115
Using the Expression Builder 119
Set Query Properties 119
Chapter 6 Creating Forms and Using Controls 121
Create Forms 121
Creating a Form Using AutoForm 122
Get a Head Start with the Form Wizard 122
Creating a Two-Table Form 126
Create a Form in Design View 126
Add Fields 128
Explore the Toolbox Tools 129
Using the Toolbox 130
Modify the Form Design 130
Choosing the Control Type 133
Use Controls 133
Add Bound Controls 133
Add Unbound Controls 137
Copy or Delete a Control 140
Rearrange Controls 140
Modify Controls 144
Navigating in a Data Entry Form 146
Chapter 7 Working with Reports 147
Create Reports 147
Viewing Reports 148
Use AutoReport to Create a Report 149
Use the Report Wizard to Create a Report 150
Create a Report in Design View 154
Modify Reports
Group Data in Reports 157
Calculate a Value 158
Accomplishing Common Tasks in Reports 159
Create a Subreport 160
Create Labels 162
Create a Report Snapshot 164
Distribute a Report Snapshot 166
Chapter 8 Preparing Your Data for Presentation 167
Improve the Data's Appearance 167
Modify Images 168
Add a Chart 170
Using the Formatting Toolbar 173
Use Graphics 173
Modify the Form or Report Design 174
Print Your Data 176
Set Up the Print Job 176
Review Data Before Printing 180
Output the Print Job 183
Choosing What to Print 184
Chapter 9 Securing and Administrating Access 187
Establish User-Level Security 187
Deciding Who Needs What Permissions 188
Understand the User-Level Security Model 188
Secure the Database with the User-Level Security Wizard 188
Keeping Data Safe 195
Apply Global Database Protection to a Database 195
Use a Database Password 196
Remove Database Objects from View 198
Back Up and Restore a Database 199
Database Administration 203
Document a Database 203
Compact and Repair a Database 204
Chapter 10 Extending Access 205
Use Advanced Data Analysis Tools 205
Create a Crosstab Query with a Wizard 205
Create a PivotTable in Forms 208
Create the PivotTable Layout 210
Create a PivotChart 212
Share Data 213
Export Access Data 213
Link Files 214
Working with OfficeLinks 215
Integrate Web Technology 217
Add a Hyperlink field to an Existing Table 217
Creating a Hyperlink to a File or Web Page 218
Save Database Objects as Static Web Pages 218
Create a Data Access Page with a Wizard 220
Create a User Interface 221
Create a Custom Dialog Box 222
Add Command Button Controls to a Dialog Box 222
Set Dialog Box Properties 222
Index 223
Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted February 17, 2009

    Good Quick Start

    A good review and restart for people who have used Access in the past. Easy to follow; good foundation builder.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)