Match between columns Premises: Used to identify the fields.

The Answer of record and fields and field value and is...

Match between columns Premises: Allows you to enter a value or select a value from a list.

The Answer of expression and list box and lookup property is...

Exam 1: Microsoft Access Basics

Imagine that you are a Sales Manager at a Toy Company, and give an example of a business situation where you would use each of these database objects: query, report, and macro.

(Essay)

4.9/5

(40)

Question 101

Just as with forms, the tables or queries that contain the data used in a report are called the ____.

(Multiple Choice)

4.9/5

(37)

Question 102

To view more of a report, click the Close Shutter Bar button on the Navigation pane.

(True/False)

4.9/5

(29)

Question 103

You must add fields in a certain order to the design grid.

(True/False)

4.7/5

(35)

Question 104

A consistent design can be created with the use of properties .

(True/False)

4.8/5

(33)

Question 105

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Used to identify the fields.

Responses:

record

fields

field value

Correct Answer:

Verified

Used to identify the fields.

(Matching)

4.9/5

(31)

Question 106

Case AC 10-1 John is working on the annual sales report for the Rain Flower Media Corporation. After adding the currency format to the total sales field, John runs the report and directs the results to his monitor. To his dismay, the total sales column displays pound signs (#) instead of his sales total figures. The report is due tomorrow and he desperately needs your assistance. Why is John's sales report displaying the pound signs (#)?

(Multiple Choice)

4.8/5

(36)

Question 107

You can export data to a(n) _____ format.

(Multiple Choice)

4.7/5

(39)

Question 108

FIGURE AC 10-17 In Figure AC 10-17 above, the box where an expression will be entered is referenced by ____.

(Multiple Choice)

4.9/5

(34)

Question 109

Tab order refers to the order in which you move between the ____ in a form.

(Multiple Choice)

4.8/5

(35)

Question 110

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Allows you to enter a value or select a value from a list.

Responses:

expression

list box

lookup property

Correct Answer:

Verified

Allows you to enter a value or select a value from a list.

(Matching)

4.8/5

(34)

Question 111

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

(Multiple Choice)

4.8/5

(33)

Question 112

To have more than one field appear in a lookup field list, you need to create lookup properties using the ____________________.

(Short Answer)

4.9/5

(39)

Question 113

If a virus attaches itself to a macro, it can cause damage when you ____ the macro.

(Multiple Choice)

4.7/5

(35)

Question 114

You need to save a new record after entering it. Access does not save new records automatically.

(True/False)

4.8/5

(31)

Question 115

____ is a program known as a database management system (DBMS).

(Multiple Choice)

5.0/5

(35)

Question 116

You can set lookup properties using the Input Mask Wizard to take you step by step through the process.

(True/False)

4.9/5

(34)

Question 117

To print the form with the current record displayed, you must be in ____ view and navigate to the desired record.

(Multiple Choice)

5.0/5

(44)

Question 118

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Offers a list of values from another field or query that you can select.

Responses:

text box

list box

lookup property

Correct Answer:

Verified

Offers a list of values from another field or query that you can select.

(Matching)

4.7/5

(43)

Question 119

When you need to create a simple form quickly, you can use the ____________________, which helps you create a form by letting you select options in dialog boxes to specify the form's record source and layout.

(Short Answer)

4.8/5

(23)

Question 120

Showing 101 - 120 of 700

Imagine that you are a Sales Manager at a Toy Company, and give an example of a business situation where you would use each of these database objects: query, report, and macro.

Just as with forms, the tables or queries that contain the data used in a report are called the ____.

To view more of a report, click the Close Shutter Bar button on the Navigation pane.

You must add fields in a certain order to the design grid.

A consistent design can be created with the use of properties .

You can export data to a(n) _____ format.

FIGURE AC 10-17 In Figure AC 10-17 above, the box where an expression will be entered is referenced by ____.

Tab order refers to the order in which you move between the ____ in a form.

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

To have more than one field appear in a lookup field list, you need to create lookup properties using the ____________________.

If a virus attaches itself to a macro, it can cause damage when you ____ the macro.

You need to save a new record after entering it. Access does not save new records automatically.

____ is a program known as a database management system (DBMS).

You can set lookup properties using the Input Mask Wizard to take you step by step through the process.

To print the form with the current record displayed, you must be in ____ view and navigate to the desired record.

When you need to create a simple form quickly, you can use the ____________________, which helps you create a form by letting you select options in dialog boxes to specify the form's record source and layout.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters