Skip to content

Sams Teach Yourself Microsoft Access 2000 in 24 Hours

Spend $50 to get a free DVD!

ISBN-10: 0672312891

ISBN-13: 9780672312892

Edition: 1999

Authors: Timothy Buchanan, Craig Eddy

List price: $24.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Aimed at the user of the new Access 2000, this title discusses the main features, without going on to discuss more advanced features. Readers will be able to create simple databases, and the main issues regarding data management are covered.
Customers also bought

Book details

List price: $24.99
Copyright year: 1999
Publisher: Sams
Publication date: 4/29/1999
Binding: Paperback
Pages: 432
Size: 7.25" wide x 9.00" long x 1.25" tall
Weight: 1.584
Language: English

Introduction
Introduction to Access 2000
Introduction to Relational Databases
Access 2000: Not Just a Desktop Database Anymore
What Is a Relational Database, Anyway?
The How and Why of Indexes
Components of an Access Database
The Limitations of Access 2000's Data Store
What's New in Access 2000
Summary
Workshop
A Quick Tour of Access 2000
Before You Install Access 2000
Installing Access 2000
Choosing Your Database Platform
Starting Access 2000 and Opening a Database
The Access Window
The Seven Main Access Database Objects
Relationships
Saving, Backing Up Databases, and Exiting Access
Summary
Workshop
Getting Help with Help Systems
Examining Ways to Get Help
Using the Office Assistant
Using the Help Topics Dialog Box
ToolTips
Summary
Workshop
Editing Data in an Existing Database
Understanding Someone Else's Database
Viewing the Splash Screen
Opening a Microsoft SQL Server Database
Looking at the Types of Security
Working with Encrypted Databases
Examining Relationships
Using the Database Documenter
Summary
Workshop
Using the Datasheet View
An Overview of the Datasheet Windows
Toolbars Used
Sorting the Datasheet
Finding and Filtering Records
Working with Records in the Datasheet
Data Entry Shortcuts
Working with Subdatasheets
Formatting the Datasheet
Printing the Datasheet
Closing the Datasheet
Summary
Workshop
Using an Existing Table
Opening Tables
Using the Design and Datasheet Views
Examining the Basic Structure of Tables
Examining Table Properties
Summary
Workshop
Using Existing Queries
Opening Queries
Using Queries in Datasheet View
Using Queries in Design View
Looking at the Basic Structure of Queries
Using Toolbars
Closing Queries
Summary
Workshop
Editing Data in Forms
Understanding Forms
Using Forms Versus Using Datasheets
Viewing Forms
Working with Data in Forms
Finding Records Using Forms
Printing Data from Forms
Closing and Saving Forms
Summary
Workshop
Displaying Data in Reports
Examining Report Fundamentals
More Ways to Open and View Reports
Printing Reports
Closing and Saving Reports
Summary
Workshop
Modifying an Existing Database
Modifying an Existing Table
Changing the Table Design
Understanding Primary Keys and Indexes
Saving the Table Design
Editing Table Relationships
Summary
Workshop
Modifying and Using Existing Queries
Using the Field List
Using the Design View's Grid
Specifying the Sort Order and Showing Fields
Specifying Criteria
Querying Multiple Tables
Setting Join Properties
Saving Queries
Summary
Workshop
Modifying an Existing Form Design
Using Form Controls
Using Advanced Control Types
Using Control Properties
Customizing Forms
Using Subforms
Summary
Workshop
Modifying an Existing Report
The Report Window
The Report Components
Report Properties
Using Expression in Reports
Summary
Workshop
Creating a Database Using Wizards
Creating a Database Using Wizards
Planning a Simple Database
Using the Database Wizard
Using the Table Wizard
The Table Analyzer Wizard
Summary
Workshop
Adding Additional Components to a Database Using Wizards
Using the Table Wizard
Using the Form Wizard
Using AutoForm to Create a Form
Using Query Wizards
Using Report Wizards
Using AutoReport to Create a Report
Using Database Wizards
Summary
Workshop
Creating a Database From Scratch
Planning and Designing Your Database
Relational Databases
The Three Types of Keys
Referential Integrity
The Three Types of Relationships
Steps to Creating a Relational Database
Choosing a Back-End Database: The Integrated Store or SQL Server
Summary
Workshop
Creating Tables
Many Means to the Same End
Creating a New Table
Data Types
Field Properties
Creating Table Indexes
Setting Relationships Between Tables
Summary
Workshop
Creating Queries
Ways to Create Queries
The Query Design View
Steps in Creating a Query
Using Advanced Selection Options in Queries
Creating Queries that Accept Parameters
Adding Calculated Fields
Additional Query Features
Summary
Workshop
Creating Forms
Types of Forms
Types of Controls
Adding Controls
Summary
Workshop
Creating Reports
Designing Reports
Designing and Creating a New Report
Summary
Workshop
Creating Macros
What Is a Macro?
The Macro Window
Creating and Editing Macros
Running Macros
Conditional Macros
Debugging Macros
Events
Integrating Macros and Forms
Summary
Workshop
Additional Topics
Exchanging Data with Word 2000, Excel 2000, and Other Applications
Using Access Data for Microsoft Word Mail Merges
Publishing Access Components Using Microsoft Word
Analyzing Access Data Using Microsoft Excel
Using the Label Wizard to Produce Labels
Exporting Data to Other Sources
Summary
Workshop
Database Administration
Compacting a Database
Repairing a Database
Backing Up a Database
Encrypting and Decrypting a Database
Converting a Database
Securing a Database
Summary
Workshop
Advanced Topics
Access 2000 and the Web
Setting Up a Web Server on Your Computer
Introducing Web Folders
Exporting Data to an HTML File
Creating Dynamic Web Pages
Data Access Pages
Summary
Workshop
Appendix
Quiz Answers
Hour 1
Hour 2
Hour 3
Hour 4
Hour 5
Hour 6
Hour 7
Hour 8
Hour 9
Hour 10
Hour 11
Hour 12
Hour 13
Hour 14
Hour 15
Hour 16
Hour 17
Hour 18
Hour 19
Hour 20
Hour 21
Hour 22
Hour 23
Hour 24
Index