Access 2000 for Windows: Visual QuickStart Guide

by Ray, Deborah S.; Ray, Eric J.

• ISBN13: 9780201354348
• ISBN10: 0201354349
• Format: Paperback
• Copyright: 1999-01-01
• Publisher: Peachpit Press

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