Home Page Icon
Home Page
Table of Contents for
Index
Close
Index
by Faithe Wempen
Ten Minute Guide to Access 97
Copyright
Introduction
What Is a Database?
What Are Databases Good For?
How Access Stores Your Data
Reports
Queries
How the Parts Fit Together
Access Wizards Make Databases Easy
Planning your Database
Planning Is Important!
Determining What Tables You'll Need
What Forms Will You Use?
What Reports Will You Want to Produce?
Starting and Exiting Access
Starting Access
Parts of the Screen
Exiting Access
Getting Help
Help—What's Available?
Asking the Office Assistant
Using the Access Help Topics
Managing Help Topics You've Located
Getting Help with Screen Elements
Creating a New Database
Choosing the Right Way to Create Your Database
Creating a Blank Database
Creating a Database with Database Wizard
Saving, Closing, and Opening a Database
Saving a Database
Closing a Database
Opening a Database
Creating a Table with the Table Wizard
Why Create a Table?
Creating a Table Using the Table Wizard
Now What?
Creating a Table Without a Wizard
Why Not Use a Wizard?
Creating a Table in Table Design View
Understanding Data Types and Formats
Setting the Primary Key
Switching Between Design and Datasheet Views
Creating a Table in Datasheet View
Modifying a Table
Editing Fields and Their Properties
Adding Fields
Deleting Fields
Hiding a Field
Deleting a Table
Entering Data Into a Table
Entering a Record
Some Data Entry Tricks
Moving Around in a Table
Printing a Table
Closing a Table
Editing Data in a Table
Changing a Cell's Content
Replacing a Cell's Content
Editing a Cell's Content
Selecting Records
Inserting New Records
Deleting Records
Moving and Copying Data
Formatting a Table
Why Format a Table?
Changing Column Width and Row Height
Changing the Font
Creating a Simple Form
Why Create Forms?
Creating a Form with AutoForm
Creating a Form with Form Wizard
Creating a Form from Scratch
Entering Data in a Form
Modifying Your Form
Moving Fields
Adding Text
Viewing Headers and Footers
Changing Field Lengths
Formatting Text on a Form
Changing Tab Order
Creating Special Data Entry Fields on a Form
What Kinds of Controls?
Creating a List Box or Combo Box
Creating an Option Group
Adding Graphics to Forms
Importing a Graphic
Creating a New Picture
Searching for Data
Using the Find Feature
Using the Replace Feature
Other Ways to Find Data
Sorting and Filtering Data
Sorting Data
Filtering Data
Creating a Query
What Is a Query?
Creating a Simple Query Using Query Wizard
Printing Query Results
Other Query Wizards
Modifying a Query
Introducing Query Design View
Adding Fields to a Query
Deleting a Field
Adding Criteria
Sorting a Field in a Query
Showing or Hiding a Field
Viewing Query Results
Creating a Simple report
Why Create Reports?
Using AutoReport to Create a Report
Creating a Report with Report Wizard
Viewing and Printing Reports in Print Preview
Customizing a Report
Entering Report Design View
Working with Objects on Your Report
Adding and Removing Fields
Arranging Your New Fields
Adding Labels
Adding a Calculated Text Box
Rules for Creating Calculations
Creating a Chart
The Chart Advantage
Creating a Chart
Using Print Preview
Saving a Chart
Modifying a Chart in Microsoft Graph
Creating Mailing Labels
Easy Mailing Labels with Access
Creating Mailing Labels with the Label Wizard
Printing Labels
Saving Labels
Modifying Your Labels
Creating Relationships Between Tables
Why Create Relationships?
Creating a Relationship Between Tables
What is Referential Integrity?
Editing a Relationship
Removing a Relationship
Analyzing How Well Your Database Works
Introducing the Analysis Tools
Using the Table Analyzer Wizard
Using the Performance Analyzer
Using the Documenter
Using Access on the Internet
Some Internet Basics
Publish to the Web
Inserting Hyperlinks Into an Access Object
Keeping Your Data Safe
Data Security: What to Be Afraid Of
Setting Up Exclusive Use
Assigning Passwords to Database Files
User-Level Security (Network Only)
Creating an MDE File
Encrypting a Database
Data Protection on Forms
Backing up your Data
Repairing Damaged Database Files
Importing and Exporting Data
Why Share Data?
Importing Data from Other Programs
Importing from a Database Program
Exporting Data to Other Programs
Creating OLE Links
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Creating OLE Links
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset