Deck 24: Managing and Reporting Database Information

Question 1

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

Answer 1

False

Question 2

The accompanying figure shows an example of a ____.

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

Answer 2

A

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

Creating a form adds a new object to the database.

Question 8

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

Question 9

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

Question 10

An easy way to locate multiple records that match specific criteria is to use the Query Wizard.

Question 11

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 12

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 13

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

Question 14

Descending order sorts numerically from the highest to lowest number.

Question 15

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

Question 16

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

Question 17

An Access template with a globe icon will create traditional desktop databases.

Question 18

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 19

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

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

Question 20

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

Question 21

When you create a ____, you can locate multiple records that match specified criteria.

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

Question 22

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 then display them all at once. He creates a ____.

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

Question 23

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 24

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

Question 25

You must be in _____ mode to encrypt a database file.

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

Question 26

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 27

Labels identify all the ____________________ included in a table.

Question 28

You can share a database using all of the following ways EXCEPT: _____.

A) SkyDrive
B) e-mail
C) the Cloud
D) Wizard

Question 29

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

Question 30

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

Question 31

Alaina is creating a large database for the non-profit organization where she works. 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 32

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 33

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 34

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 35

The Find option can be activated using the _____ shortcut keys.

A) Ctrl+F
B) Shift+F
C) Alt+F
D) Fn+F

Question 36

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

A) LAYOUT
B) HOME
C) TABLE
D) DESIGN

Question 37

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

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

Question 38

A ____ is created to organize, summarize, and print all or part of the data in a database.

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

Question 39

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

Question 40

Alaina is creating a large database for the non-profit organization where she works. Alaina has a lot of data to enter, and she wants to make the process easier. She creates a ____.

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

Question 42

Explain the purpose of a form and what it is used for. Define a form, a report, and a query, and explain how each is used. Give an example of a database, and then describe a form, a query, and a report that you might create in this database.