Microsoft Office Access 2007, Exam 77-605, with Student CD-ROM and Six-Month Office Trial CD-ROM / Edition 1

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
  • All (9) from $1.99   
  • New (1) from $109.86   
  • Used (8) from $1.99   


The Microsoft Official Academic Course (MOAC) Program contains the official products for Microsoft Programs in higher education.  These learning products are created especially for the academic market and combine the business world focus and market research of Microsoft with 200 years of successful higher education publishing from Wiley.

The program is based upon the same curriculum as the Microsoft IT Certifications to build the skills students need to succeed at work and the preparation they need to validate those skills and get the jobs they seek.

All the support instructors need to deliver great courses on Microsoft software is in the program.  Microsoft Updates will bring you the latest information on new products and curriculums and are a part of the program.  MOAC is a great way for instructors to get ready to teach.

This text is for an introductory course in Microsoft Office Access 2007 mapping to MCAS exam 77-605

Read More Show Less

Product Details

  • ISBN-13: 9780470069509
  • Publisher: Wiley
  • Publication date: 6/15/2007
  • Series: Microsoft Official Academic Course Series, #259
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 480
  • Product dimensions: 8.84 (w) x 10.90 (h) x 0.61 (d)

Table of Contents

Chapter 1. Database Essentials.
What is a Database?
Starting Access and Opening an Existing Database.
Defining Data Needs and Types.
Defining Table Fields.
Defining Data Types for Fields.
Defining Database Tables.
Chapter 2. Create Database Tables.
Creating a Database.
Creating a Blank Database.
Using a Template to Create a Database.
Creating a Database Table.
Creating a Table from a Template.
Creating a Table from Another Table.
Saving a Database.
Chapter 3. Work with Tables / Database Records.
Creating and Modifying Primary Keys.
Defining and Modifying a Primary Key.
Defining and Modifying a Multi-field Primary Key.
Entering, Editing, and Deleting Records.
Navigating Among Records.
Finding and Replacing Data.
Attaching and Detaching Documents.
Sorting Data Within a Table.
Filtering Data Within a Table.
Removing a Filter.
Understanding Table Relationships.
Defining Table Relationships.
Modifying Table Relationships.
Printing Table Relationships.
Chapter 4. Modify Tables and Fields.
Modifying a Database Table.
Modifying Table Properties.
Renaming a Table.
Deleting a Table.
Creating Fields and Modifying Field Properties.
Modifying Field Properties.
Creating Fields.
Creating and Modifying Multi-Value Fields.
Creating and Modifying Attachment Fields.
Chapter 5. Create Forms. 
Creating a Simple Form. 
Creating a Form in Design View. 
Creating a Datasheet Form. 
Applying AutoFormat. 
Sorting Data within a Form. 
Filtering Data within a Form. 
Chapter 6. Create Reports. 
Creating a Simple Report. 
Using the Report Wizard. 
Creating a Report in Design View. 
Applying AutoFormat. 
Sorting Data within a Report. 
Filtering Data within a Report. 
Chapter 7. Use Controls in Reports and Forms. 
Adding a Control. 
Binding a Control to a Field. 
Defining Control Tab Order. 
Formatting Controls. 
Arranging Controls. 
Creating Conditional Formatting on Controls. 
Chapter 8. Create and Modify Queries. 
Creating a Query. 
Creating a Query from a Table. 
Creating a Query from Multiple Tables. 
Modifying a Query. 
Adding a Table to a Query. 
Removing a Table from a Query. 
Adding Criteria to a Query. 
Sorting Data Within a Query. 
Filtering Data Within a Query. 
Chapter 9. Advanced Tables. 
Creating a Custom Table. 
Using the Table Analyzer. 
Summarizing Table Data. 
Chapter 10. Advanced Forms. 
Creating a Multi-Item Form. 
Creating a Split Form. 
Creating a Subform. 
Creating a PivotTable Form. 
Creating a Form Using Layout View. 
Chapter 11. Advanced Reports. 
Defining Group Headers. 
Creating Aggregate Fields. 
Creating the Print Layout. 
Using the Label Wizard. 
Chapter 12. Advanced Queries. 
Creating AdvancedQueries.
Creating Action Queries. 
Creating Crosstab Queries. 
Creating a Subquery.
Saving a Filter as a Query. 
Advanced Query Modification.
Creating a Join. 
Creating a Calculated Query Field. 
Adding an Alias to a Query Field. 
Creating Aggregated Queries. 
Chapter 13. Display and Share Data. 
Creating a Chart. 
Formatting a Chart. 
Formatting a Chart. 
Changing Chart Types. 
Saving a Database Object as Another File Type. 
Printing a Database Object. 
Chapter 14. Import and Export Data. 
Importing Data. 
Importing Data from a Specific Source. 
Linking to an External Data Source. 
Saving and Running Import Specifications. 
Exporting Data. 
Exporting from a Table. 
Exporting from a Query. 
Saving and Running Export Specifications. 
Chapter 15. Database Tools. 
Backing Up a Database. 
Compacting and Repairing a Database. 
Saving as a Previous Version. 
Splitting a Database. 
Managing a Database. 
Using the Linked Table Manager. 
Encrypting a Database 
Setting Database Properties 
Identifying Object Dependencies 
Using the Database Documenter

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)