Sams Teach Yourself Microsoft Access 2000 in 21 Days

Description

Sams Teach Yourself Microsoft Access 2000 in 21 Days is a hands-on tutorial for users who want to learn Access by working through solid examples. This book shows you how to develop solid databases from start to finish. Focusing on Access databases on the desktop, the book also addresses implementing Access in a networked or client/server environment. Key topics included relational databases and the Access 2000 architecture, designing, building, and maintaining full feature database applications, implementing Data Access Pages, working with Visual Basic for Applications and the Visual Basic Editor, and publishing Access content to the WWW or intranet.

Sample Content

Table of Contents

WEEK 1. AT A GLANCE.

Data Isn't Information. The Nature of Access Data. The Theory of Database Structure. The Practice of Database Structure. Access' Mission. Hardware Requirements. Maintaining Access Databases. Summary. Q&A. Workshop.

The Access User Interface. Views, Opening, and Closing Objects. Global Options. The Parts of Access. Analysis of Your Project. Getting Help--The Office Assistant. Toolbars. Using the Database Wizard to Create an Application. Summary. Q&A. Workshop.

The Nature of a Table. Creating Your First Table. Analyzing the Wizard's Table. Linking Fields--The Heart of the Relationship. The Outcome of a Relationship. Table and Field Properties. Indexing and More on Key Fields. Sorting and Filtering in Tables. Finding Data. Summary. Q&A. Workshop.

The Query in Access. A First Query. The Simple Query Wizard. Filtering and Sorting in Queries. Query Criteria. Multitable Queries. Multitable Queries Without Existing Links. Intermediate Criteria. Summary. Q&A. Workshop.

The Purpose of Forms in a Database. Creating a First Form. Form Design View. Form Headers and Footers. Other Form Format Properties. Tab Order. Finding, Filtering, and Sorting in Forms. Summary. Q&A. Workshop.

Reports in Access. The AutoReport Wizard. Report Wizard. The Report Design View. Grouping in Reports. Mailing Labels. Page Layout Settings. Sums, Subtotals, and Running Sums. Summary. Q&A. Workshop.

Macros and Access. Elements of a Macro. Macros and Events. Commonly Used Macro Actions. Conditional Macros. Summary. Q&A. Workshop.

WEEK 1. IN REVIEW.

WEEK 2. AT A GLANCE.

Access and the Web. Data Access Page Creation. The Need for Data Access Pages. The Design of Data Access Pages. Applied Data Access Pages. Summary. Q&A. Workshop.

Tables and Data Integrity. Data Validation in Tables. Data Lookup in Tables. Input Masks. Using OLE Objects and Hyperlinks in Tables. Saving Tables as HTML. Summary. The Millennium Bug. Q&A. Workshop.

Making Attractive Forms. Using Colors in Forms. 3D Effects and Object Order. Formats and System Tools. Adding Artwork. Summary. Q&A. Workshop.

General Math in Queries. Date and Time Math in Queries. Out of Order Sorting. Joins. Using Ranges in Queries. Summary. Q&A. Workshop.

Updates

Submit Errata