- Copyright 1999
- Dimensions: 10 X 8
- Pages: 264
- Edition: 1st
-
Book
- ISBN-10: 0-7897-1902-9
- ISBN-13: 978-0-7897-1902-7
Easy Microsoft Access 2000 starts with the basics of the program and advances, in a series of increasingly more difficult tasks, to creating and using reports. This book gets you comfortable with Access by using clear, hands-on directions and engaging summaries. Learn to build and manipulate databases in a short period of time.
Table of Contents
I. LEARNING THE BASICS.
1. Installing Microsoft Access 2000. 2. Starting Access from the Start Button. 3. Opening an Existing Database. 4. Using Menu Commands. 5. Using Toolbar Buttons. 6. Using Object Buttons. 7. Selecting Objects. 8. Getting Help. 9. Navigating in Help. 10. Using Context-Sensitive Help. 11. Using the Answer Wizard. 12. Using the Index. 13. Choosing an Office Assistant. 14. Asking a Question. 15. Using Office on the Web. 16. Exiting Access. II. DESIGNING AND CREATING AN ACCESS DATABASE.
1. Adding a Folder for the Database. 2. Creating a New Database. 3. Using the Table Wizard. 4. Adding a New Field in Design View. 5. Working with Number Fields. 6. Adding a Yes/No Field. 7. Saving the New Table Definition. 8. Opening a Table. 9. Changing a Field Name. 10. Moving a Field Within a Table. 11. Inserting a Field. 12. Adding a New Field in Datasheet View. 13. Deleting a Field. 14. Building a Table from Scratch. III. ENTERING AND EDITING DATA.
1. Entering New Information Into a Table. 2. Completing the Supplier Table. 3. Copying Information from Another Record. 4. Editing Data in a Field. 5. Undoing an Edit. 6. Searching for Information. 7. Replacing Selected Information. 8. Sorting Records. 9. Using Filters. 10. Filtering by Form. 11. Deleting a Selected Record. 12. Resizing Rows and Columns. 13. Freezing and Unfreezing Columns. 14. Hiding and Unhiding Columns. IV. USING DATABASE FORMS.
1. Using an AutoForm. 2. Using a Wizard to Build a Form. 3. Opening the Form Design View Window. 4. Adding Fields to a Form. 5. Moving Fields in Form Design. 6. Creating Headers and Footers. 7. Creating Labels. 8. Using a Combo Box. 9. Adding a List Box. 10. Moving Objects. 11. Editing a Label. 12. Using an Option Button. 13. Adding a Calculated Field. 14. Adding Pop-Up Tip Text to Fields. 15. Using Color in the Form. 16. Saving Your New Form. 17. Opening a Form. 18. Entering and Editing Information with a Form. 19. Changing the Field Order. V. GETTING INFORMATION FROM THE DATABASE.
1. Opening Query Design View. 2. Running and Saving a Query. 3. Adding Fields to the Query Grid. 4. Selecting Records with Wildcards. 5. Selecting Records with an OR Criteria. 6. Selecting Records with More than One Criterion. 7. Using Arithmetic Operators. 8. Adding a New Field. 9. Calculating a Value with a Query. 10. Deleting Records with a Query. 11. Creating a Query That Prompts for a Criteria Variable. VI. CREATING AND USING REPORTS.
1. Building a Report with a Wizard. 2. Opening the Report Design View. 3. Adding Fields to the Report. 4. Using Titles. 5. Adding Automatic Page Numbers and Dates. 6. Grouping Records. 7. Sorting Records. 8. Moving Field Labels on the Report. 9. Moving Fields on the Report. 10. Using Calculated Fields in a Report. 11. Adding Special Effects to a Report. 12. Viewing a Report. 13. Saving a Report. 14. Printing a Report. VII. ADVANCED FEATURES.
1. Building Permanent Relationships. 2. Using a Query with Multiple Tables. 3. Creating a Report from a Query. 4. Exporting Information. 5. Importing Information. 6. Appending Data from One Table to Another. 7. Using Name AutoCorrect. 8. Viewing Data with Subdatasheets. 9. Creating Subdatasheets. 10. Creating a Data Access Page. 11. Working with Data on a Page. 12. Editing the Data Access Page Design.