Sams Teach Yourself Microsoft Access 2000 in 24 Hours

I. INTRODUCTION TO ACCESS 2000.

Hour 1. 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.

HOUR 2. 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.

Hour 3. Getting Help With Help Systems.


Examining Ways to Get Help. Using the Office Assistant. Using the Help Topics Dialog Box. ToolTips. Screen Tips. Summary. Workshop.

II. EDITING DATA IN AN EXISTING DATABASE.

Hour 4. 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.

Hour 5. 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.

Hour 6. Using An Existing Table.


Opening Tables. Using the Design and Datasheet Views. Examining the Basic Structure of Tables. Examining Table Properties. Summary. Workshop.

Hour 7. 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.

Hour 8. 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.

Hour 9. Displaying Data In Reports.


Examining Report Fundamentals. More Ways to Open and View Reports. Printing Reports. Closing and Saving Reports. Summary. Workshop.

III. MODIFYING AN EXISTING DATABASE.

Hour 10. Modifying An Existing Table.


Changing the Table Design. Understanding Primary Keys and Indexes. Saving the Table Design. Editing Table Relationships. Summary. Workshop.

Hour 11. 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.

Hour 12. Modifying An Existing Form Design.


Using Form Controls. Using Advanced Control Types. Using Control Properties. Customizing Forms. Using Subforms. Summary. Workshop.

Hour 13. Modifying An Existing Report.


The Report Window. The Report Components. Report Properties. Using Expressions in Reports. Summary. Workshop.

IV. CREATING A DATABASE USING WIZARDS.

Hour 14. Creating A Database Using Wizards.


Planning a Simple Database. Using the Database Wizard. Using the Table Wizard. The Table Analyzer Wizard. Summary. Workshop.

Hour 15. 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.

V. CREATING A DATABASE FROM SCRATCH.

Hour 16. 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.

Hour 17. 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.

Hour 18. 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.

Hour 19. Creating Forms.


Types of Forms. Types of Controls. Adding Controls. Summary. Workshop.

Hour 20. Creating Reports.


Designing Reports. Designing and Creating a New Report. Summary. Workshop.

Hour 21. 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.

VI. ADDITIONAL TOPICS.

Hour 22. 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.

Hour 23. 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.

VII. ADVANCED TOPICS.

Hour 24. 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.

VIII. APPENDIX.

A: 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.