UUS Practice Tests⌕ Search
IT Certifications · 77-885

Exam 77-885: Access 2010 Practice Test

Access 2010 work centers on structuring relational data and using database objects to enter, retrieve, and present it. The available practice questions sample table design, field types and validation, primary keys and relationships, queries, forms, and reports. These tasks reflect common decisions when building or maintaining a small Access database.

Exam overview

Exam providerMicrosoft
Exam code77-885
CategoryIT Certifications

About the Exam 77-885: Access 2010 Exam

Database design questions involve selecting field types suited to values such as currency or long notes, assigning keys to identify records, and relating parent and child tables. Query work can include prompting users for criteria and suppressing duplicate values in results. Forms provide a structured way to enter or view records, with the Record Source property connecting a form to its underlying data. Report tasks focus on presenting grouped records and calculating category subtotals. These concepts connect database structure to routine work: keeping entries consistent, retrieving targeted information, and producing readable summaries. Practice with these areas can help distinguish what belongs in a table, what a query should return, and how forms and reports use stored data.

Sample Practice Questions

Review a selection from this exam's published US Practice Tests practice bank.

Question 1

A table stores prices that may include cents. Which field data type is generally best for storing these values accurately as monetary amounts?

  1. ACurrency
  2. BShort Text
  3. CYes/No
  4. DAttachment
Show answerCorrect answer: A

The Currency data type is intended for monetary values and stores them with fixed precision suitable for typical financial calculations.

Question 2

In Access 2010, what is the main purpose of a primary key in a table?

  1. ATo uniquely identify each record
  2. BTo sort records alphabetically
  3. CTo store a calculated total
  4. DTo prevent users from opening the table
Show answerCorrect answer: A

A primary key contains a value that uniquely identifies each record, helping prevent duplicate identities and supporting relationships with other tables.

Question 3

In Access 2010, which relationship type allows one record in a parent table to be associated with multiple records in a related table?

  1. AOne-to-one
  2. BOne-to-many
  3. CMany-to-many without an intermediary table
  4. DUnrelated
Show answerCorrect answer: B

In a one-to-many relationship, a record on the one side can correspond to multiple records on the many side. For example, one customer may have several orders.

Question 4

What is the purpose of a form's Record Source property?

  1. AIt specifies the table or query that supplies the form's data
  2. BIt sets the form's background color
  3. CIt determines the form's window size
  4. DIt selects the printer used for the form
Show answerCorrect answer: A

The Record Source property identifies the table, query, or SQL statement that provides the records displayed or edited through the form.

Question 5

In Access 2010, which report feature can display a subtotal for each category of records?

  1. AGrouping and sorting
  2. BAutoCorrect Options
  3. CDatabase Documenter
  4. DCompact and Repair
Show answerCorrect answer: A

Grouping records in a report creates sections for categories, where group headers or footers can include calculated values such as subtotals.

Question 6

A user wants a query to show each department only once, even when many employees belong to that department. Which query property can suppress repeated result values?

  1. ATop Values
  2. BUnique Values
  3. CReturns
  4. DOrientation
Show answerCorrect answer: B

Setting the query’s Unique Values property to Yes returns only distinct result rows, suppressing duplicate rows in the query output.

Question 7

In Access 2010, which field data type is designed to store a long block of descriptive text, such as detailed notes?

  1. AShort Text
  2. BLong Text
  3. CCurrency
  4. DAutoNumber
Show answerCorrect answer: B

Long Text (called Memo in earlier Access versions) is intended for lengthy text entries. Short Text is meant for shorter text values, while Currency and AutoNumber serve different purposes.

How to use this practice test

The free US Practice Tests practice session draws up to 20 random questions from the 50-question Access 2010 bank. Answer the set to see your results, then use missed items to identify concepts to revisit, such as field properties, relationships, query behavior, or report grouping.

Preparation tips

  • Compare Access field types and match each to realistic values, including currency amounts, short labels, and long descriptive notes.
  • Sketch one-to-many relationships and identify which table holds the primary key and which stores the related foreign key.
  • Build sample queries using criteria prompts and test how duplicate suppression changes the returned records.
  • Create a form from a table, then inspect its Record Source and test how a validation list restricts field entries.
  • Group report records by category and verify that subtotals reflect the records in each group.
Official sourceOfficial exam page ↗