Deck 24: Managing and Reporting Database Information

Question 1

When you finish the Report Wizard, the report is displayed in Design view.

Answer 1

False

Question 2

After you sort table data, you cannot use the Undo command.

Answer 2

False

Question 3

You should use the Replace All command only when you are confident about making all the replacements without reviewing them first.

Answer 3

True

Question 4

Entering data in a form is similar to entering data in a table in Datasheet view.

Question 5

The above figure shows an example of a(n) ____.

A) form
B) query
C) report
D) datasheet

Question 6

When you work with a form, ____ view is used for adding, editing, and viewing data.

A) Form
B) Datasheet
C) Layout
D) Design

Question 7

To create a form, use the Form button or the Form dialog box .

Question 8

When you print a database in Datasheet view, all of the data in the database is printed.

Question 9

Which of the following is NOT true about creating a form?

A) When you create a form using the Form button, it is predesigned.
B) You can modify the form using Layout view.
C) The Form button is located on the Insert tab.
D) You can modify the form using Design view.

Question 10

Creating a form adds a new object to the database.

Question 11

When you apply a theme to a form, the table style is also updated.

Question 12

Descending order sorts numerically from the highest to lowest number.

Question 13

When you create a form using the Form Wizard, all the fields from the table or query are automatically included on the form.

Question 14

When working with a form, Design view shows a detailed view of the structure of the form.

Question 15

When you work with a form, you can work in all of the following views, EXCEPT: ____.

A) Form
B) Datasheet
C) Layout
D) Design

Question 16

You can use the Mailing Wizard to prepare addresses and names for distribution.

Question 17

In Design view, you can change the appearance of a report by applying a different theme and/or colors and fonts.

Question 18

The Find command provides a quick and easy way to locate specific records.

Question 19

When you sort in ascending order, you sort alphabetically from Z to A.

Question 20

When you work with a form, ____ view is used to change the properties and add new fields.

A) Form
B) Datasheet
C) Layout
D) Design

Question 21

The Form ____________________ prompts you to select the fields and the form layout for the new form.

Question 22

When you create a(n) ____ you can locate multiple records that match specified criteria.

A) datasheet
B) report
C) form
D) query

Question 23

Which of the following is true about entering and editing data in a form?

A) You can use the Tab and arrow keys to move the insertion point among fields.
B) When you enter or edit a record in Form view, Access automatically updates the records in the table.
C) When entering text, the Edit Record icon is displayed in the upper-left corner of the form.
D) All of the above are true.

Question 24

Juan is working with a large database and trying to locate information in it. Juan wants to locate all records that contain a certain postal code, one at a time. He uses the ____ command.

A) Query
B) Replace
C) Find
D) Search

Question 25

When selecting fields for the Label Wizard, ____ to include it in the label.

A) double-click it
B) click the Select Single Field button
C) right-click it
D) Either A or B.

Question 26

The Sort & Filter group is located on the ____ tab.

A) Layout
B) Home
C) Layout
D) Design

Question 27

The Find button is located on the ____ tab.

A) Home
B) Database Tools
C) Table Tools Layout
D) Fields

Question 28

Which of the following is NOT true about reports?

A) The Report Wizard prompts you to specify the data to include.
B) Landscape orientation formats the report with the long edge of the page at the top.
C) The Report Wizard button is located on the Create tab.
D) You can only create a report based on a table.

Question 29

When you work with a form, ____ view enables you to make changes to the font styles and colors.

A) Form
B) Datasheet
C) Layout
D) Design

Question 30

Press ____+F4 to locate the next instance using the search criteria from the previous search without opening the Find and Replace dialog box.

A) Ctrl
B) Alt
C) Shift
D) Tab

Question 31

The above figure shows a query in ____ view.

A) Query
B) Design
C) Layout
D) Wizard

Question 32

To make all instances of Incorporated that appear in a company name appear as Inc. , use the ____________________ command.

Question 33

A(n) ____ provides a way for you to ask a question about the information stored in one or more database tables.

A) query
B) report
C) form
D) search

Question 34

Alaina is working on creating a large database for a non-profit organization she works for. Alaina has a lot of data to enter, and wants to make it easy to enter. She creates a(n) ____.

A) form
B) report
C) query
D) table

Question 35

When you create a form using the Form button, it opens in ____________________ view.

Question 36

When the ____ command is turned off, Access ignores capitalization in a search.

A) Any Part of Field
B) Match Case
C) Search Fields
D) All Caps

Question 37

A(n) ____________________ is a database object that allows you to organize, summarize, and print data.

Question 38

Juan is working with a large database and trying to locate information in it. Juan wants to locate all records that contain a certain postal code, and display them all at once. He creates a ____.

A) table
B) report
C) form
D) query

Question 39

Alaina is working on creating a large database for a non-profit organization she works for. Alaina wants to print selected data from the database so she can distribute it to donors. She creates a ____.

A) form
B) report
C) query
D) table

Question 40

A(n) ____________________ provides a more convenient way to enter and edit data.

Question 41

What is a form and what is it used for? What is a report and what is it used for? What can you use to create a report? What is a query and how does it help you? Come up with an example of a database, and describe a form, query, and report that you might create in the database.