Home Page Icon
Home Page
Table of Contents for
III. Appendixes
Close
III. Appendixes
by Scott Palmer, Kate J. Chase
Access 2003 for Starters: The Missing Manual
A Note Regarding Supplemental Files
The Missing Credits
About The Authors
About the Creative Team
Acknowledgements
The Missing Manual Series
Introduction
What’s a Database?
Database Management Software
About Access Databases
About This Book
About the Outline
About → These → Arrows
The Very Basics
Example Databases
About MissingManuals.com
Safari Enabled
I. Building a Database
1. Creating Databases
A Tour of an Access Database
The Access Window
Tables
Forms
Queries
Reports
Putting It All Together
Creating a New Database
Starting with a Wizard
Phase 1: Choosing Your Template
Phase 2: Choosing Table Fields
Phase 3: Choosing Styles for Forms and Reports
Phase 4: Adding a Title and a Picture
Modifying the Wizard’s Database
Opening a Database
Navigating with the Switchboard
Adjusting Table Designs
Adding Records Using a Form
Printing a Report
Starting from a Blank Database
2. Creating Tables to Hold Data
Planning Your Tables
Creating Tables with the Wizard
Phase 1: Starting the Table Wizard
Phase 2: Choosing Fields for Your Table
Phase 3: Naming Your Table and Setting a Primary Key
Phase 4: Creating Your Table
Creating Tables in the Design Window
Adding Fields
Choosing Data Types
Text
Memo
Number
Date/Time
Currency
Autonumber
Yes/No
OLE Object
Hyperlink
Lookup Wizard
Setting Field Properties
Adding and Editing Table Data
Adding Records to a Datasheet
Editing Records in a Datasheet
Changing How a Table Displays Data
3. Creating Forms to Add and Display Data
Form Basics
Form Layouts
Controls
Properties and the Property Sheet
Creating Autoforms
Creating Forms with the Form Wizard
Phase 1: Choosing a Record Source
Phase 2: Choosing Fields
Phase 3: Choosing a Form Layout
Phase 4: Choosing a Form Style
Phase 5: Naming and Saving the Form
Modifying the Form Design
Editing the Labels
Adding a Title in the Form Header
Dragging a Control
Creating Forms in Design View
Phase 1: Starting Your Design
Phase 2: Choosing a Data Source
Phase 3: Adding Fields to the Form
Phase 4: Adding Images to the Form
Phase 5: Adding a Form Style
Phase 6: Naming and Saving the Form
4. Linking Tables to Combine Data
Why Relate?
A Relational Database Tour
Common Fields
Subdatasheets and Subforms
Linking Tables in the Relationships Window
Adding Tables to the Relationships Window
Adding Relationships Between Tables
Modifying or Deleting Relationships
Printing Relationships
Using Subdatasheets to View Related Items
Creating Subforms
Adding Information in a Subform
5. Sorting and Filtering
Sorting Database Records
Ascending Sorts
Descending Sorts
Sorting on Multiple Fields
Moving fields for multiple choice sorts
Saving Your Sorting Choice
Finding Data with Filters
How to save or discard a filter
Filtering by Selection: The Quick Way to Filter
Adding a filter by selection
Filtering by exclusion
Filtering by Form
Adding filter criteria
Filtering with Wildcards, Operators, and Expressions
Using wildcards in filters
Using operators in filters
Using expressions in filters
Applying and removing filters
Using Advanced Filter/Sort
Adding filter criteria
Applying and removing Filter/Sort
6. Finding Data with Queries
Types of Queries
Select Query
Crosstab Query
Parameter Query
Action Query
Autolookup Query
SQL Query
Setting Query Properties
Creating Queries with the Query Wizard
Creating a Simple Query
Creating a Crosstab Query
Using a Query to Check for Duplicate Records
Creating a Find Unmatched Query
Saving, Deleting, and Printing Queries
7. Creating Custom Queries
Creating Queries in the Query Design Window
Using Criteria in Queries
Crafting a Custom Query Using the Query Design Window
Tweaking Your Custom Query
Getting Sums, Totals, and Averages from Your Database
Calculating averages
Using the numbers in two columns to create a third one
Creating a subtotal, total, or grand total
Using Expression Builder
Looking at total sales for a specific date
8. Generating Reports
Report Basics
How Reports Differ from Forms
Types of Access Reports
Two Ways to Create Reports
Wizards
Design window
Displaying and Printing Reports
Parts of a Report
Report Design Sections
Report header and footer
Page header and footer
Group header and footer
Detail section
Using the Report Wizard
Starting the Wizard
Choosing the Report Type
Choosing the Data Source
Choosing the Fields
Grouping the Report Data
Sorting the Report Data
Choosing a Report Layout
Choosing a Report Style
Adding a Report Title
III. Appendixes
A. Help and Installation
Installing Access 2003
Installing Office
Installing Access Only
Access Help
Where to Look for Help
Screen tips
Menu bar
Office Assistant
Help Task Pane
Visiting Microsoft Office Online
Learning with Tutorials
Finding Help Articles and Training Tutorials Not Listed
Locating and Downloading Access Templates
Asking Questions and Finding Answers
B. Access FAQ
Importing and Exporting
Importing a Word File into Access
Importing an Excel Spreadsheet into Access
Validation
Finding Find
C. Access 2003, Menu by Menu
File Menu
New
Open
Get External Data
Close
Save
Save As
Back Up Database
Export
File Search
Page Setup
Print
Send To
Database Properties
[Recent Files]
Exit
Edit Menu
Undo
Undo Current Field/Record
Redo
Cut
Copy
Office Clipboard
Paste
Paste Special
Paste as Hyperlink
Paste Append
Duplicate
Create Shortcut
Delete
Rename
Groups
Add to Group
Delete Record, Delete Column
Select Record
Select All
Select All Records
Select Form
Find, Replace
Go To
OLE/DDE Links
View Menu
Design View
SQL View
Form View
Datasheet View
PivotTable View
PivotChart View
Table Names
Totals
Subform in New Window
Database Objects
Large Icons, Small Icons
List
Details
Arrange Icons
Line Up Icons
Properties
Field List
Code
Ruler, Grid
Toolbox
Page Header/Footer, Form Header/Footer
Task Pane
Object Dependencies
Indexes
Join Properties
Toolbars
Zoom
Pages
Refresh
Insert Menu
New Record
Column, Row
Lookup Column/Lookup Field
Subdatasheet
Page Numbers, Date and Time
Chart
Object
ActiveX Control
Hyperlink
Hyperlink Column
Tab Control Page
Format Menu
Font
Datasheet
Row Height, Column Width
Hide Columns, Unhide Columns
Freeze Columns, Unfreeze All Columns
Subdatasheet
AutoFormat
Conditional Formatting
Align
Size
Horizontal Spacing
Vertical Spacing
Group
Ungroup
Bring To Front, Send to Back
Records Menu
Filter
Sort
Apply Filter/Sort, Remove Filter/Sort
Save Record
Refresh
Data Entry
Tools Menu
Spelling
Office Links
Online Collaboration
Speech
Relationships
Analyze
Database Utilities
Security
Replication
Startup
Macro
Add-Ins
ActiveX Controls
AutoCorrect Options
Customize
Options
Window Menu
Tile Horizontally, Tile Vertically
Cascade
Hide
Arrange Icons
[Window Names]
Help Menu
Index
About the Authors
Colophon
Copyright
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
8. Generating Reports
Next
Next Chapter
A. Help and Installation
Part III. Appendixes
Appendix A
Appendix B
Appendix C
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