Register your product to gain access to bonus material or receive a coupon.
Using Microsoft Access 2000 leads you through a quick series of chapters to get you up and running with Access and its new interface quickly, avoiding intimidation with a complex product and providing quick satisfaction. Then you'll review more in-depth concepts, such as table relationships, datatypes, data entry techniques, and data access pages in real-world examples and tasks. Finish by learning complex database design strategies, interacting with a server, publishing to Web, and programming for customized applications.
I. LEARNING THE ACCESS ESSENTIALS.
1. Starting with a Properly Normalized Design.The Importance of a Good Design. Refining the Design.
2. Understanding Access Objects.What Are Objects? What Are Tables? What Are Queries? What Are Forms? What Are Reports? What Are Modules? Reviewing the Screen Object. Reviewing the DoCmd Object. Naming Conventions.
3. New User Features in Access 2000.Converting to Prior Versions. Announcing the New Database Window. Using the File Dialog Box. Enhancing the Windows Clipboard. Updating with Name AutoCorrect. Improved Conditional Formatting. Reviewing Unicode. Working with Subdatasheets. Printing the Relationships Window. Compacting Access Data on Closing.
II. CREATING A DATABASE AND ITS OBJECTS.
4. Creating a Database.Getting Started. What's a Wizard? Reviewing the Database Wizard. Documenting the Database.
5. Creating Tables.Designing Tables. Working with the Table in Design View. Assigning Table Names That Describe Their Function. Making Tables Efficient Objects Within the Database. Setting Primary Keys. Indexes. Using the Table Wizard.
6. Creating Queries.Reviewing Queries. Working with the Query Design Grid. Using the Simple Query Wizard. Using the Crosstab Query Wizard. Using the Find Duplicates Query Wizard. Using the Find Unmatched Query Wizard.
7. Creating Forms.Understanding Forms. Working in Design View. Standardizing Forms. Quickly Creating Forms with a Wizard.
8. Creating Reports.Introducing Reports. Using the Report Wizards. Viewing Reports in Design View. Setting Report Properties. Standardizing Reports. Creating a Report Template. Inserting a Chart into a Report with the Chart Wizard. Printing Your Report.
9. Creating Controls and Setting Properties.Reviewing Control Wizards. Reviewing Control Properties. The List Box Control. Using the List Box Wizard. Creating the List Box from Scratch. Working with Combo Box Controls. Using Command Button Controls. Working with the Option Group Control.
III. STORING, CONTROLLING, AND MANIPULATING DATA.
10. Looking Up Values and Lists.What's a Lookup? Using the DLookUp() Function.
11. Defining and Working with Relationships.Bringing Your Information Together. Using the Relationships Window.
12. Managing External Data.Importing and Linking. Using the Import Spreadsheet Wizard. Using the Import Text Wizard.
13. Designing and Using Queries.Creating a Sample Database for This Chapter. Creating a Select Query Without Using a Wizard. Grouping Data and Performing Calculations with Crosstab Queries. Working with Action Queries.
14. Building Parameter Queries.Setting Parameters in the Query Design Grid's Criteria Section. Creating an Input Box for User-Requested Criteria. Using Wildcards in Parameters.
15. Advanced Uses for Queries.Querying Another Query. Creating a SQL Statement for a Macro RunSQL Action. Creating a SQL Statement for Use in VBA.
IV. CREATING THE INTERFACE: INPUT AND OUTPUT.
16. Adding Controls to Forms and Reports.Working with the Toolbox. Working with the Grid. Inserting Controls. Positioning Controls. Sizing Controls. Selecting Multiple Controls. Working with Bound Controls.
17. Using Forms to Enter and Review Data.Working in Form View. Navigating Records. Controlling Navigation in Forms. Sorting in a Form. Searching in a Form.
18. Refining Forms: Efficient Data Entry and Beyond.Verifying Data. Forcing an Entry. Formatting Data with the Format Property. Applying Input Masks. Controlling Access. Using Expressions in Controls to Display Additional Data. Inserting Custom Controls.
19. The World of Subforms.Working with Subforms. Creating a Subform. Referring to Subforms and Their Controls. A Subform Alternative: The Tab Control.
20. Advanced Form Techniques.Working with the Form Module. Responding to Form Events. Linking Forms with VBA Code. Linking Forms with a Macro. Printing Form Data Without the Form. Reducing Data-Entry Tasks. Working with Pop-Up Forms.
21. Making Your Point with Reports.Grouping and Sorting Data. Calculating Totals with Controls. The Art of Page Numbering. Inserting Graphics.
22. Displaying Detailed Data with a Subreport.What's a Subreport and Why Do You Need One? Adding a Subreport to an Unbound Main Report.
23. Creating Labels and Mail-Merge Documents.Using the Label Wizard. Printing Multiple Labels. Merging Access Data with Word Documents.
V. AUTOMATING THE DATABASE.
24. Creating Macros.When to Use Macros. The Macro Design Window. Generating Macros with Multiple Actions.
25. Running Macros.Methods Used to Run Macros. Debugging Macros. Working with the AutoExec and AutoKeys Macros.
26. Introducing Visual Basic for Applications.When to Use VBA. Understanding Modules. The VBA Programming Environment. Using the Visual Basic Editor.
27. Programming Access with VBA.Familiarizing Yourself with the Access Applications Model. Using the Object Browser. Learning to Speak VBA. Working with Variables and Data Types. Understanding Scope. Writing Procedures.
28. Using VBA for Interactive Input.Passing Arguments to Your Code. Letting the Code Make Decisions. Displaying Information with a Message Box. Soliciting Information with Input Boxes. Looping in VBA. When Your Code Doesn't Work.
29. A Primer on ADO.The ADO Advantage. Using ADO Objects. Using Recordsets.
VI. BEYOND THE DESKTOP.
30. Using Builders, Utilities, and Add-ins to Increase.Efficiency. Using the Expression Builder for Complex Expressions. Using Access Database Utilities. Database Splitter. Installing and Using Add-ins.
31. Access on the Internet.How Access and the Web Unite. Hyperlinks Within Access. Web-Publishing Basics.
32. Applying Security to the Database.Why Have Security? Securing Native Access Databases (*.mdb). Securing an Access Project.
33. Multiuser Considerations.Sharing Your Data. The Client/Server Database Environment. Performance Issues.
34. Using Access Projects.Understanding Access Projects. Comparing an Access Project and a Database. Working with a Project's Objects. Securing an Access Project.
35. Taking the Next Step.What's a Class Module? Creating Your Own Objects. Understanding ActiveX Technology.
Glossary.