Sams Teach Yourself Microsoft Access 2000 in 21 Days with Cdrom

830 Pages·1999·10.26 MB·English

by  Paul Cassel

To access the contents, click the chapter and section titles.
Sams Teach Yourself Microsoft Access 2000 in 21 Days
(Publisher: Macmillan Computer Publishing)
Author(s): Paul Cassel
ISBN: 0672312921
Publication Date: 05/03/99

Brief Full
Advanced
Search this book:
Search
Search Tips

Introduction
About the Author
PART 1—At a Glance
Chapter 1—Understanding Relational Database
Concepts
Data Isn’t Information
Changing Data into Information
Getting Complex
The Key to the Transformation
Not Fun, but Necessary
The Nature of Access Data
The Theory of Database Structure
The Practice of Database Structure
Choosing the Primary Key
Relationship Types
Getting to Normalization
Access’ Mission
Microsoft Extends Access
Hardware Requirements
Maintaining Access Databases
Repairing in Place
Summary
Q&A
Workshop
Quiz
Chapter 2—From Idea to Project
The Access User Interface
Navigating the Database View Window
Groups
Views, Opening, and Closing Objects
Just Like Everyday Windows
Global Options
The Parts of Access
Tables
Queries
Forms
Reports
Pages
Macros
Modules
Analysis of Your Project
Don’t Be a Slave to Convention
Don’t Worry Yet
Getting Help—The Office Assistant
Real Experts Shun Help—Ha!
The Ways of Help
What’s This?
Toolbars
Using the Database Wizard to Create an Application
Summary
Q&A
Workshop
Quiz
Exercises
Chapter 3—Exploring the Data
Foundations—The Table
The Nature of a Table
Examining a Table
Creating Your First Table
Table Design Basics
Using the Table Design Grid
Using the Datasheet View to Make a Table
The Table Wizard
Analyzing the Wizard’s Table
Flat Model Instead of Relational
Possible Wrong Field Types
Linking Fields—The Heart of the Relationship
Shortcut to Data Entry
The Outcome of a Relationship
The Best Is Yet to Come
Not Convinced?
Seeing It Yourself
Table and Field Properties
Indexing and More on Key Fields
Sorting and Filtering in Tables
Sorting
Filtering
Finding Data
Find Cautions
Summary
Q&A
Workshop
Quiz
Exercises
Chapter 4—Using Queries for Data Retrieval
The Query in Access
A First Query
The Simple Query Wizard
Filtering and Sorting in Queries
Query Criteria
Quick Query Facts
Multitable Queries
Multitable Queries Without Existing Links
Intermediate Criteria
Wildcards and Like
Summary
Q&A
Workshop
Quiz
Exercises
Chapter 5—Creating Simple Forms for Data
Access
The Purpose of Forms in a Database
Control and Record Source Properties
Creating a First Form
Task: Using the Form Wizard
Form Design View
Task: Using the Form Design View
Option Group
Form Control Alignment
Form Headers and Footers
Other Form Format Properties
Tab Order
Finding, Filtering, and Sorting in Forms
Summary
Q&A
Workshop
Quiz
Exercises
Chapter 6—Generating Basic Reports
Reports in Access
The AutoReport Wizard
Report Wizard
Report Preview Details
The Report Design View
Grouping in Reports
The Group
Properties
Mailing Labels
Expression Details Explained
Page Layout Settings
Sums, Subtotals, and Running Sums
Summary
Q&ampA
Workshop
Quiz
Exercises
Chapter 7—Automating Your Access App: A
Macro Primer
Macros and Access
And the Point Is?
Elements of a Macro
The Macro Design Grid
A Very Simple Macro
Deleting Macro Actions
Macros and Events
Commonly Used Macro Actions
Further Actions
Conditional Macros
Summary
Q&ampA
Workshop
Quiz
Exercises
PART 1—In Review
PART 2—At a Glance
Chapter 8—Data Access Pages
Access and the Web
The Problem and the Problem Solved
Data Access Page Creation
The Need for Data Access Pages
The Design of Data Access Pages
Applied Data Access Pages
Summary
Q&ampA
Workshop
Quiz
Exercise
Chapter 9—Refining Your Tables
Tables and Data Integrity
The Rule
Data Validation in Tables
Data Lookup in Tables
Input Masks
Using OLE Objects and Hyperlinks in Tables
Inserting OLE Objects
Hyperlinks
The Hyperlink Edit Catch-22
Free-Floating Hyperlinks
Saving Tables as HTML
Summary
The Millennium Bug
Q&A
Workshop
Quiz
Exercises
Chapter 10—Designing Customized Forms
Making Attractive Forms
Using Colors in Forms
Altering Object Color
Form Object Pictures
Command Buttons
3D Effects and Object Order
Formats and System Tools
Adding Artwork
Summary
Q&A
Workshop
Quiz
Exercises
Chapter 11—Sorting Data with Queries and
Joins
General Math in Queries
Date and Time Math in Queries
Out of Order Sorting
Joins
Self-Join
Inner to Theta Joins
Using Ranges in Queries
Summary
Q&ampA
Workshop
Quiz
Exercises
Chapter 12—Developing Reports with Graphics
and Expressions
Examining Complex Reports
Exploring the Report Property Sheet
Examining the Properties Box
Tips for Adjusting Width
Changing the Text Box’s Border
Examining the Data Properties
Introducing the Event and Other Properties
Adding Images to Reports
Adding a Repeating Image
Using the Image Control
Adding Images from a Table
Adding a Chart
Modifying the Properties
Modifying the Chart
Using Expressions in Reports
Creating an Expression
Using the Expression Builder
Concatenating Fields with an Expression
Evaluating Data with an Expression
The Syntax for IIF
Working with Subreports
Creating a Subreport
Creating the Main Report
Integrating the Subreport
Creating Reports with Multiple Columns
Summary
Q&A
Workshop
Quiz
Exercises
Chapter 13—Introducing VBA
Understanding VBA
Exploring Uses for VBA
Introducing the Control Wizards
Examining the Structure of VBA
Understanding Modules
Understanding Procedures
Exploring the Visual Basic Editor
Viewing Your Code
Examining the Project Explorer Window
The Code Window
Examining the Properties Window
Examining the Locals Window
Examining the Watches Window and the
Immediate Window
Introducing Language Elements
Examining the Control Wizard’s Results
Understanding Declarations and Options
Using Procedures
Understanding Scope
Understanding Error Handling
Using Variables
Declaring Variables
Visual Basic Data Types
Using Constants
Understanding Methods
Using Objects
Getting Help
Summary
Q&ampA
Workshop
Quiz
Exercises
Chapter 14—Understanding SQL
What Is SQL?
Understanding the Structure and Syntax of SQL
Exploring the Simple SELECT Statement
Examining SELECT
Examining FROM
Examining Joins
Examining IN
Examining GROUP BY
Examining HAVING
Examining WHERE
Examining ORDER BY
Examining WITH OWNERACCESS OPTION
Using the WHERE Clause
Entering SQL
Working with the Different Field Types
Working with Operators
Using a Comparison Operator
Combining Expressions Using Logical
Operators
Using Between
Using a Wildcard
Working with Missing Data
Understanding the Restrictions
Summary
Q&ampA
Workshop
Quiz
Exercises
PART 2—In Review
PART 3—At a Glance
Chapter 15—Examining Special-Use Queries
Understanding Action Queries
Using Update Queries
Setting Up an Update Query
Running an Update Query
Using a Built-In Function with an Update
Query
Task: Changing the Case in a Field
Examining the Update Query SQL
Statement
Using Append Queries
Creating an Append Query
Running an Append Query
Examining the Append Query SQL
Statement
Using Delete Queries
Creating a Delete Query
Running a Delete Query
Examining the Delete Query SQL
Statement
Using Make Table Queries
Creating a Make Table Query
Running a Make Table Query
Examining the Make Table SQL Statement
Using Crosstab Queries
Using the Crosstab Query Wizard
Examining the Crosstab Query SQL Statement
Refining a Crosstab Query