Access 2000 for Windows: Visual QuickStart Guide,9780201354348

Access 2000 for Windows: Visual QuickStart Guide

by ;
ISBN13: 9780201354348
ISBN10: 0201354349
Format: Paperback
Pub. Date: 1999-01-01
Publisher(s): Peachpit Press
Upgraded Edition: Click here!
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $17.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 $12.09

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

Are you looking for the best way to learn Access 2000, Microsoft's premier database program and part of its highly touted Office 2000 Suite? Access 2000 for Windows: Visual QuickStart Guideoffers a clear, easy-to-follow, task-based format that guides you through the information you need to get right to work. Learn how to get the most out Access's powerful data-handling features, from its user-friendly wizards and templates to its advanced customization options, by following the book's concise, step-by-step instructions and the hundreds of screenshots that accompany them. Long after you've mastered the basics, this book will continue to be a helpful reference you can turn to for a quick refresher on any topic.

Table of Contents

Introduction xi
Why Access? xii
Who Are You? xiii
What You Need to Know xiv
Anything Else You Should Know? xiv
Getting Started with Access
1(10)
What Is a Database?
2(1)
What Is a Relational Database?
3(1)
Starting Access
4(2)
Looking at the Access Database Window
6(2)
Access Database Objects
8(3)
Starting a Database
11(8)
Planning Content
12(1)
Planning Structure
13(1)
Planning Relationships
14(1)
Creating a Database Using a Wizard
15(3)
Saving Databases
18(1)
Working with Tables
19(18)
Looking at Tables
20(4)
Creating Tables with Wizards
24(2)
Entering, Editing, and Deleting Data
26(2)
Formatting Columns and Rows
28(1)
Moving Columns
29(1)
Freezing and Hiding Columns
30(2)
Adding Fields
32(1)
Understanding Data Types
33(3)
Printing Tables
36(1)
Working with Forms
37(30)
Look at Forms
38(2)
Design View of a Form
40(2)
Viewing Forms
42(2)
Deleting Records from Forms
44(1)
Copying Data from One Record to Another
45(1)
Using Autocompletion
46(1)
Creating Forms with a Wizard
47(2)
Organizing Forms for Efficiency
49(2)
Formatting Forms
51(1)
Specifying Properties in Forms
52(1)
Adding Controls
53(2)
Creating a Drop-Down Data-Entry List
55(2)
Modifying Controls
57(2)
Using Input Masks
59(2)
Validating Data Entry
61(2)
Creating Subforms
63(2)
Creating a Chart in a Form
65(2)
Working with Queries
67(24)
Looking at Queries
68(2)
Creating New Queries with a Wizard
70(3)
Viewing Queries in Design View
73(1)
Choosing Which Tables to Query
74(1)
Choosing Which Fields to Query
75(1)
Specifying Query Criteria
76(2)
Querying with Wildcards
78(1)
Using the Expression Builder
79(2)
Create an Advanced Criteria with the Expression Builder
81(3)
Introducing SQL
84(1)
Querying with SQL
85(1)
Creating Crosstab Queries
86(2)
Calculating in Queries
88(1)
Specifying Fields to Appear in Results
89(2)
Working with Reports
91(14)
Look at Reports
92(2)
Viewing Reports
94(1)
Modifying Existing Reports
95(1)
Creating New Reports with a Wizard
96(2)
Formatting Reports with AutoFormats
98(1)
Formatting Reports in Design View
99(1)
Fine-Tuning Your Reports
100(1)
Making Mailing Labels
101(2)
Printing a Report
103(1)
Saving a Report as a Word Document
104(1)
Finding, Filtering, and Sorting
105(18)
Choosing Filters or Queries
106(1)
Finding Records
107(2)
Finding and Replacing Data
109(1)
Finding Duplicates
110(2)
Finding Unmatched Records
112(2)
Filtering with Forms
114(2)
Filtering by Selection
116(1)
Filtering by Exclusion
117(1)
Sorting Query Results
118(2)
Sorting Table Records
120(1)
Creating an Advanced Filter or Sort
121(2)
Managing Relationships
123(12)
Establishing Relationships
124(4)
Enforcing Referential Integrity
128(2)
Changing Relationships
130(1)
Joining Tables in a Query
131(4)
Additional Table Capabilities
135(16)
Copying, Moving, and Renaming Fields
136(2)
Setting Primary Key Fields
138(2)
Using Lookup Fields
140(4)
Using Hyperlinks
144(4)
Using Object Linking and Embedding
148(3)
Using Specialized Queries
151(8)
Updating Records
152(2)
Finding High and Low Values
154(1)
Copying Data to a Table
155(1)
Querying to Delete Records from Tables
156(1)
Creating a Table from Query Results
157(2)
Working with Pivot Tables
159(10)
Creating Pivot Tables
160(3)
Relaunching the Pivot Table Wizard
163(1)
Pivoting a Pivot Table
164(3)
Filtering a Pivot Table
167(2)
Importing and Exporting Data
169(22)
Importing Data into Access
170(2)
Linking to Data
172(2)
Importing Data from Excel
174(4)
Creating a Mail Merge with Word
178(3)
Exporting Data from Access to Another Database
181(4)
Copying Data to Another Program
185(2)
Copying Data to Another Access Database
187(2)
Copying a Table Within a Database
189(2)
Publishing to the Web
191(18)
Deciding How to Publish
192(2)
Publishing Static Web Pages
194(1)
Publishing Dynamic Pages
195(2)
Publishing Data Access Pages
197(4)
Viewing and Modifying Data
201(2)
Changing Grouping Levels in a Page
203(2)
Adding a Pivot Table to a Page
205(2)
Viewing a Page in a Web Browser
207(2)
Honing Your Database
209(20)
Customizing Switchboards
210(3)
Customizing Toolbars and Menus
213(4)
Creating and Customizing Menus
217(3)
Writing Macros
220(3)
Customizing Objects with Access Macros
223(2)
Creating Custom Dialog Boxes
225(2)
Setting Passwords
227(2)
Going Beyond the Basics
229(12)
Making Your Database Run Faster
230(2)
Controlling Permissions for Multi-User Databases
232(6)
Upgrading to Projects
238(3)
Appendix A: Setting Options and Preferences 241(10)
View Options
242(1)
General Options
243(1)
Edit and Find Options
244(1)
Keyboard Options
245(1)
Datasheet Options
246(1)
Forms/Reports Options
247(1)
Advanced Options
248(1)
Tables/Queries Options
249(2)
Appendix B: Field Types Properties 251(2)
Basic Access Data Types
251(1)
Number Data Subtypes
252(1)
Data/Time Data Types
252(1)
Currency Data Types
252(1)
Index 253

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.