|
MOUS Essentials: Access 2000
Prentice Hall's MOUS Essentials were created specifically to meet the required guidelines established by Microsoft for the Microsoft Office User Specialist exams.
The authors follow the proven approach of Prentice Hall's Essentials series with an emphasis on step-by-step tutorials with large screen shots, outstanding student pedagogy, and
plenty of exercises. This text also includes a number of elements designed to help students study for the MOUS exams. As an additional test preparation tool, the series also includes live computer-based training and assessment with the MOUS Kelly PinPoint CD-ROM.
Key Features
* All MOUS Essentials books are certified to the Expert Level by Microsoft as approved test preparation guides for the MOUS exams.
* A unique appendix entitled Preparing for MOUS Certification provides information on how to register, what is covered in the tests, how the tests work, and levels of certification.
* Each Project opens with Required Activities for both levels of the exam objectives. These activities are indicated throughout the Projects by icons distinguishing core vs. expert objectives.
* Exam Notes and Instide Stuff sidebars provide students with extra tips and tricks on preparing for and taking the MOUS exams.
* MOUS PinPoint software provides computer-based training and assessment tools for students to complete the projects and practice for the MOUS exams. MOUS PinPoint includes Project Review Tests along with "Show Me" training for each MOUS Exam Skill Set covered within the Project. In addition, each MOUS PinPoint has a capstone final exam that mirrors the actual MOUS exams.
FEATURES:
* All MOUS Essentials are certified to the Expert level by Microsoft - As approved courseware for the MOUS Program.
* Provides students with the software skills necessary to help them compete in today's job market.
* Each Project opens with Required Activities - From the Microsoft exam guidelines. These activities are indicated by the MOUS icon where appropriate within the Project.
* Alerts students to the specific skills need to prepare for the MOUS exam.
Exam Notes.
* Provides students with tips and tricks on preparing for and taking the exams.
* A unique Student Test Preparation Guide.
* Provides general exam information for students, including information on how and where to register for an exam.
* MOUS PinPoint software - MOUS PinPoint includes Project Review Tests with "Show Me" training for each Microsoft MOUS Exam Skill Set covered within the Project. * In addition, each MOUS PinPoint has a capstone practice test that mirrors the actual MOUS examination.
* Provides a computer-based learning and assessment tools for students to complete the in-text project and practice for the MOUS exams.
* Instructor's resources - Include the Instructor's Resource CD-ROM and Companion Website. The IRCD contains Instructor's Manuals, PowerPoints, Test Manager, Student data files, and solution files for all four applications. This material can also be downloaded from the Website at www.prenhall.com/mousessentials.
CONTENTS:
1. Getting Started with Access 2000.
Copying and Renaming a Database File. Opening a Database and Using the Objects Bar. Opening and Closing Database Objects. Identifying Access Window Elements. Using the Office Assistant and the What's This? Feature. Closing a Database and Exiting Access.
2. Creating a Database.
Creating a New Database. Creating a Table Using Design View. Saving a Table Design and Creating a Primary Key. Adding Fields to a Table. Editing Fields. Changing Views and Moving Fields. Deleting Fields.
3. Entering and Editing Data.
Adding Records. Moving among Records. Editing Records. Copying, Pasting, and Deleting Record. Adjusting Column Widths and Hiding Columns. Finding Records. Sorting Records.
4. Querying Your Database.
Creating a New Query. Modifying and Sorting a Query. Matching Criteria and Using Multiple Criteria. Using Comparison Operators in a Query. Using Wildcards in a Query. Adding Calculated Fields into a Query. Summarizing Data Using the Total Function. Changing Query Properties.
5. Creating and Using Forms.
Creating an AutoForm. Entering and Editing Data Using a Form. Saving, Closing and Opening a Form. Creating a New Form in Design View. Adding Fields to Forms. Moving and Resizing Fields in Forms. Adding a Form Header and Label.
6. Creating and Printing Reports.
Printing the Table Data. Creating a Report Using the Report Wizard. Printing and Renaming a Report. Modifying a Report Design. Saving the Report with a New Name. Adding Labels to Reports.
7. Integrating Access with Other Sources of Data and the Internet.
Converting a Database from a Previous Version of Access. Linking an Access Table to a Form Letter in Word. Merging an Access Table with a Form Letter. Importing a Table from Excel. Saving a Form as a Data Access Page. Using a Browser to Interact with the Database.
8. Making Data Entry Easier and More Accurate.
Creating Consistent Data Formats. Creating Conditional Formats for Positive, Negative, and Null Values. Changing the Data Input Structure Using Input Masks. Restricting Entries Using Validation Criteria. Requiring Entry of Necessary Information. Preventing Duplicate Entries Using Indexed Fields. Creating a Lookup Column to Allow Selection from a List. Entering a Default Value.
9. Managing Data Using Smaller, Related Tables.
Designing Related Tables to Hold Repetitive Data. Defining the Relationship between the Tables. Printing Table Relationships and Displaying Subdatasheets in Tables. Creating Queries That Draw Data from Both Tables. Automatically Filling in Data from One of the Joined Tables. Updating Tables by Entering or Deleting Data in the Query. Finding Duplicate Records in an Existing Table.
10. Adding Useful Features to Your Forms.
Adding Formats in the Form Design View. Creating a List Box. Looking Up Valid Entries from a Table or Query Using a Combo Box. Using Information from a Query to Fill in Fields Automatically. Entering the Current Date in a Field Automatically. Adding the Current Date and Time to a Form Automatically. Changing the Tab Order. Creating Subforms. Printing the Form for Filing Purposes.
11. Special Purpose Reports and Advanced Report Procedures.
Creating Labels for Mailings. Creating Calculated Controls in a Report. Grouping and Sorting Data in a Report. Keeping Grouped Data Together in Reports. Adding Calculated Controls to Group Headers and Footers. Inserting a Graphic Background by Modifying Report Properties.
12. Automating Your Database with Macros.
Creating a Macro to Open Close a Form. Creating a Macro to Print a Report. Using the Macro Builder to Open a Form in Read Only Mode. Running a Macro from a Button on a Form. Creating a Switchboard Using the Switchboard Manager. Creating a Macro to Automatically Launch the Main Switchboard Form.
13. Managing Your Databases with Special Action Queries and Database Utilities.
Making Backup Copies of Your Data Using the Export Feature. Saving an Access 2000 Database as an Access 97 Database. Compacting and Repairing Files for Efficient Storage. Creating a Query That Creates an Archive Table. Modifying the Archive Setup Query to Delete Records from a Table. Creating a Query to Append Records to an Archive Table. Creating a Macro to Run Two Queries and Attaching It to a Switchboard Button. Transferring Access Data to Excel.
14. Using Access on the Web and Linking to Other Documents.
Adding Hyperlinks from Forms to Word Documents. Adding Hyperlinks from Forms to Excel Spreadsheets. Saving Database Objects as Static HTML Pages. Viewing HTML Pages on a Local Drive Using a Browser.
15. Designing a Complex Database.
Defining Desired Output. Organizing the Fields into Several Tables. Relating Tables Using One-to-One, and One-to-Many Relationships. Relating Two Tables Using a Third Table. Refining the Design to Eliminate Redundant Fields. Creating Queries and Testing the Design. Documenting the Design.
16. Making the Input Form More User-Friendly.
Changing the Color of Text, Backgrounds, and Borders Using Buttons. Using the Format Painter to Copy Formats between Controls. Formatting More Than One Control at a Time. Changing Colors Using Properties. Adding Status Bar Instructions in Form View. Adding Customized ControlTips to Controls. Creating a Custom Toolbar. Using the Macro Builder to Attach a Macro to a Form.
17. Managing Changing Data.
Replacing Data in a Table Using an Update Query. Replacing Portions of Fields Using an Update Query. Updating Tables with a Calculated Expression. Updating a Table Based on Values in Another Table. Updating Linked Tables Automatically.
18. Using Access Tools.
Customizing Data Entry Using AutoCorrect. Analyzing a Table. Analyzing Database Performance. Updating the Database Using Name AutoCorrect. Using Office Links to Analyze Data with Excel.
19. Analyzing and Reporting Data.
Using the Totals Tool in a Query. Creating Crosstab Queries Based on Multiple Tables. Adding a Subform to an Existing Form. Inserting Subreports into Reports Using the Subform/Report Wizard. Creating Charts as Forms Using the Chart Wizard.
20. Filtering Data in a Linked Table Using Parameters and Form Filters.
Using Data in Another Database. Selecting Records Using Filter by Selection. Selecting Records Using Filter by Form. Using Parameters as Matching Criteria in a Query. Use Parameters with Comparison Operators in a Query. Use Parameters with Wildcards as Criteria in a Query.
21. Sharing a Database with Others.
Assigning a Password to Your Database. Changing or Removing a Database Password. Encrypting a Database. Setting Startup Parameters. Setting Access Defaults.
|
