Office Access 2003 Step by Step

Contents
What’s New in Microsoft Office Access 2003 Getting Help
Getting Help with This Book and Its CD-ROM Getting Help with Microsoft Office Access 2003 More Information
Using the Book’s CD-ROM
What’s On the CD-ROM? Minimum System Requirements Installing the Practice Files Using the Practice Files Uninstalling the Practice Files
Conventions and Features
Taking a Microsoft Office Specialist Certification Exam
About the Microsoft Office Specialist Program
What Does This Logo Mean?
Selecting a Microsoft Office Specialist Certification Level
Microsoft Office Specialist Skill Standards
The Exam Experience
For More Information
Microsoft Office Specialist Skill Standards
About the Authors
Quick Reference
Chapter 1: Getting to Know Microsoft Access 2003
Chapter 2: Creating a New Database
Chapter 3: Getting Information Into and Out of a Database
Chapter 4: Simplifying Data Entry with Forms
Chapter 5: Locating Specific Information
Chapter 6: Keeping Your Information Accurate
Chapter 7: Working with Reports
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


1 Getting to Know Microsoft Access 2003 1
Understanding Databases
Discovering What’s Special About Access
Opening an Existing Database
Exploring Tables
Exploring Queries
Exploring Forms
Exploring Reports
Exploring Other Access Objects
Previewing and Printing Access Objects

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
Importing Information from a Delimited Text File
Importing Information from a Fixed-Width Text File
Importing Information from an Access Database
Importing Information from Other Databases
Importing Information from an HTML File
Importing Information from an XML File
Exporting Information to Other Programs
Linking a Database to Information in Another Database
Other Ways to Share Access Data

4 Simplifying Data Entry with Forms 83
Creating a Form by Using a Wizard 84
Refining Form Properties 86
Refining Form Layout 92
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
Filtering Information in a Table
Filtering by Form
Locating Information that Matches Multiple Criteria
Creating a Query in Design View
Creating a Query with a Wizard
Performing Calculations in a Query

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

9 Keeping Your Information Secure 225
Encrypting and Decrypting a Database
Assigning a Password to a Database
Sharing a Database
Replicating a Database
Splitting a Database
Setting Up a Workgroup
Maintaining a Workgroup
Preventing Changes to a Database
Securing a Database for Distribution

10 Working with Pages and Modules 259
Creating Static Web Pages
Exploring Visual Basic for Applications (VBA)
Using VBA to Create a Web Page
Creating a Data Access Page with AutoPage
Creating a Data Access Page Using the Page Wizard
Allowing Others to Analyze Data On the Web
Glossary
Index


Download this book click here
Another Database books click here