Original PDF Flash format Table-of-Contents-from-Microsoft-Office-Access-2003-Step--by-Step  


Table Of Contents From Microsoft Office Access 2003 Step By Step

a03t615179.fm Page iii Sunday, July 27, 2003 1:49 PM
Contents
Contents
What’s New in Microsoft Office Access 2003
vii
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
xiii
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
xvii
Conventions and Features
xix
Taking a Microsoft Office Specialist Certification Exam
xxi
About the Microsoft Office Specialist Program
xxi
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
iii
a03t615179.fm Page iv Sunday, July 27, 2003 1:49 PM
Contents
1
Getting to Know Microsoft Access 2003
1
Understanding Databases
2
Discovering What’s Special About Access
3
Opening an Existing Database
4
Exploring Tables
6
Exploring Queries
10
Exploring Forms
14
Exploring Reports
18
Exploring Other Access Objects
21
Previewing and Printing Access Objects
22
2
Creating a New Database
31
Creating a Database Structure the Simple Way
32
Checking the Work of a Wizard
36
Creating Tables the Simple Way
41
Refining How Data Is Displayed
44
Manipulating Table Columns and Rows
51
3
Getting Information
57
Into and Out of a Database
Importing Information from Excel
58
Importing Information from a Delimited Text File
61
Importing Information from a Fixed-Width Text File
63
Importing Information from an Access Database
66
Importing Information from Other Databases
68
Importing Information from an HTML File
69
Importing Information from an XML File
71
Exporting Information to Other Programs
73
Linking a Database to Information in Another Database
76
Other Ways to Share Access Data
78
4
Simplifying Data Entry with Forms
83
Creating a Form by Using a Wizard
84
Refining Form Properties
86
Refining Form Layout
92
iv
a03t615179.fm Page v Sunday, July 27, 2003 1:49 PM
Contents
Adding Controls to a Form
95
Using Visual Basic for Applications to Enter Data in a Form
100
Creating a Form by Using an AutoForm
104
Adding a Subform to a Form
106
5
Locating Specific Information
117
Sorting Information
118
Filtering Information in a Table
121
Filtering by Form
123
Locating Information that Matches Multiple Criteria
126
Creating a Query in Design View
129
Creating a Query with a Wizard
138
Performing Calculations in a Query
140
6
Keeping Your Information Accurate
145
Using Data Type Settings to Restrict Data
146
Using Field Size Properties to Restrict Data
150
Using Input Masks to Restrict Data
152
Using Validation Rules to Restrict Data
157
Using Lookup Lists to Restrict Data
160
Updating Information in a Table
166
Deleting Information from a Table
170
7
Working with Reports
175
Creating a Report by Using a Wizard
176
Modifying a Report
180
Creating a Report from Scratch
186
Adding a Subreport to a Report
191
Previewing and Printing a Report
197
8
Making It Easy for Others
201
to Use Your Database
Creating a Switchboard by Using Switchboard Manager
202
Creating a Splash Screen
207
Setting Startup Options
212
Keeping Your Application Healthy
217
v
a03t615179.fm Page vi Sunday, July 27, 2003 1:49 PM
Contents
9
Keeping Your Information Secure
225
Encrypting and Decrypting a Database
226
Assigning a Password to a Database
228
Sharing a Database
231
Replicating a Database
233
Splitting a Database
238
Setting Up a Workgroup
240
Maintaining a Workgroup
247
Preventing Changes to a Database
253
Securing a Database for Distribution
254
10
Working with Pages and Modules
259
Creating Static Web Pages
261
Exploring Visual Basic for Applications (VBA)
263
Using VBA to Create a Web Page
268
Creating a Data Access Page with AutoPage
276
Creating a Data Access Page Using the Page Wizard
283
Allowing Others to Analyze Data On the Web
287
Glossary
293
Index
303
vi