Microsoft Office Access 2003 Step by Step,9780735615175

Microsoft Office Access 2003 Step by Step

by
Edition: 1st
ISBN13: 9780735615175
ISBN10: 0735615179
Format: Paperback
Pub. Date: 2003-08-27
Publisher(s): Microsoft Press
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $24.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $3.85

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

This practical, hands-on tutorial expertly builds your skills with Microsoft Office Access 2003one step at a time! With STEP BY STEP, you work at your own pace through easy-Hey, you know your way around a databaseso now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It's all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery! Build on what you already know about Access and quickly dive into what's new Design your database the way the experts doand sidestep common mistakes Import data from spreadsheets, text files, databases, and other sources Write simple to sophisticated queries to manipulate data Learn advanced techniques for building forms and reports Develop PivotTable and PivotChart dynamic views Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures Implement database security features Deliver dynamic data on the Web with data access pages and XML *Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pagesCD features: Complete eBook in PDF format Insider Extrasincluding fully functional sample databases, VBA code, and sample web pages Catalog of Access resources with links to third-party tools and demos Microsoft resources and demos, including Insider's Guide to Microsoft Office OneNote 2003 eBook Microsoft Computer Dictionary, Fifth Edition, eBook10,000+ entries

Author Biography

Online Training Solutions, Inc. (OTSI) is a traditional and electronic publishing company with years of experience in the creation, production, and delivery of computer software training. OTSI is also the author of several Step by Step books about Office System applications.

Table of Contents

What's New in Microsoft Office Access 2003 iii
Getting Help ix
Getting Help with This Book and Its CD-ROM
ix
Getting Help with Microsoft Office Access 2003
ix
More Information
xii
Using the Book's CD-ROM xi
What's On the CD-ROM?
xiii
Minimum System Requirements
xiii
Installing the Practice Files
xiv
Using the Practice Files
xv
Uninstalling the Practice Files
xvi
Conventions and Features xix
Taking a Microsoft Office Specialist Certification Exam xxi
About the Microsoft Office Specialist Program
xx
What Does This Logo Mean?
xxi
Selecting a Microsoft Office Specialist Certification Level
xxi
Microsoft Office Specialist Skill Standards
xxii
The Exam Experience
xxii
For More Information
xxiv
Microsoft Office Specialist Skill Standards xxv
About the Authors xxvii
Quick Reference xxix
Chapter 1: Getting to Know Microsoft Access 2003
xxix
Chapter 2: Creating a New Database
xxx
Chapter 3: Getting Information Into and Out of a Database
xxxi
Chapter 4: Simplifying Data Entry with Forms
xxxiii
Chapter 5: Locating Specific Information
xxxv
Chapter 6: Keeping Your Information Accurate
xxxvii
Chapter 7: Working with Reports
xxxix
Chapter 8: Making It Easy for Others to Use Your Database
xlii
Chapter 9: Keeping Your Information Secure
xliii
Chapter 10: Working with Pages and Modules
xlv
1 Getting to Know Microsoft Access 2003 1(30)
Understanding Databases
2(1)
Discovering What's Special About Access
3(1)
Opening an Existing Database
4(2)
Exploring Tables
6(4)
Exploring Queries
10(4)
Exploring Forms
14(4)
Exploring Reports
18(3)
Exploring Other Access Objects
21(1)
Previewing and Printing Access Objects
22(9)
2 Creating a New Database 31(26)
Creating a Database Structure the Simple Way
32(4)
Checking the Work of a Wizard
36(5)
Creating Tables the Simple Way
41(3)
Refining How Data is Displayed
44(7)
Manipulating Table Columns and Rows
51(6)
3 Getting Information Into and Out of a Database 57(26)
Importing Information from Excel
58(3)
Importing Information from a Delimited Text File
61(2)
Importing Information from a Fixed-Width Text File
63(3)
Importing Information from an Access Database
66(2)
Importing Information from Other Databases
68(1)
Importing Information from an HTML File
69(2)
Importing Information from an XML File
71(2)
Exporting Information to Other Programs
73(3)
Linking a Database to Information in Another Database
76(2)
Other Ways to Share Access Data
78(5)
4 Simplifying Data Entry with Forms 83(34)
Creating a Form by Using a Wizard
84(2)
Refining Form Properties
86(6)
Refining Form Layout
92(3)
Adding Controls to a Form
95(5)
Using Visual Basic for Applications to Enter Data in a Form
100(4)
Creating a Form by Using an AutoForm
104(2)
Adding a Subform to a Form
106(11)
5 Locating Specific Information 117(28)
Sorting Information
118(3)
Filtering Information in a Table
121(2)
Filtering by Form
123(3)
Locating Information that Matches Multiple Criteria
126(3)
Creating a Query in Design View
129(9)
Creating a Query with a Wizard
138(2)
Performing Calculations in a Query
140(5)
6 Keeping Your Information Accurate 145(30)
Using Data Type Settings to Restrict Data
146(4)
Using Field Size Properties to Restrict Data
150(2)
Using Input Masks to Restrict Data
152(5)
Using Validation Rules to Restrict Data
157(3)
Using Lookup Lists to Restrict Data
160(6)
Updating Information in a Table
166(4)
Deleting Information from a Table
170(5)
7 Working with Reports 175(26)
Creating a Report by Using a Wizard
176(4)
Modifying a Report
180(6)
Creating a Report from Scratch
186(5)
Adding a Subreport to a Report
191(6)
Previewing and Printing a Report
197(4)
8 Making It Easy for Others to Use Your Database 201(24)
Creating a Switchboard by Using Switchboard Manager
202(5)
Creating a Splash Screen
207(5)
Setting Startup Options
212(5)
Keeping Your Application Healthy
217(8)
9 Keeping Your Information Secure 225(34)
Encrypting and Decrypting a Database
226(2)
Assigning a Password to a Database
228(3)
Sharing a Database
231(2)
Replicating a Database
233(5)
Splitting a Database
238(2)
Setting Up a Workgroup
240(7)
Maintaining a Workgroup
247(6)
Preventing Changes to a Database
253(1)
Securing a Database for Distribution
254(5)
10 Working with Pages and Modules 259(34)
Creating Static Web Pages
261(2)
Exploring Visual Basic for Applications (VBA)
263(5)
Using VBA to Create a Web Page
268(8)
Creating a Data Access Page with Autopage
276(7)
Creating a Data Access Page Using the Page Wizard
283(4)
Allowing Others to Analyze Data On the Web
287(6)
Glossary 293(10)
Index 303

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.