Exam 7: Access 2013 Getting Started With Access 2013

Case 3-1 You are just starting to create a new form and have begun to realize that there are a variety of mouse pointer shapes in use. In order to make creating the form easier, you decide to familiarize yourself with a few of them. Which of the following is the default mouse pointer in Layout View?

____________________ View is a spreadsheet-like view of the data in a table.

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?

In the accompanying figure, item 1 points to the ____ section.

The same expression in different sections of a report produces different calculations.

Which command is used to copy a control from one report section to another?

____________________ orientation is 8.5" wide by 11" tall.

In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

Which of the following is NOT available to you as you start Access?

The record selector button is to the right of a record in a datasheet. ____________________

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

The report section before a group of records is called the Group ____________________ section.

Access saves ____ automatically as you move from record to record.

Which of the following comparison operators means "greater than"?

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

Critical Thinking Questions Case 1-1 Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. Her crew manager will also be using the system. Hannah is considering whether to use Excel or Access. Which one of the following is NOT a benefit of using Access?

The [F2] key switches between Edit and Navigation modes.

The ____________________ Sheet of a control is a comprehensive listing of all characteristics that you can modify for that control.

The wildcard character that stands for any group of characters is the ____.