Deck 69: Data-sheets and Forms

Question 1

You can locate a record in a table by typing search text in the Search box in Datasheet view.

Answer 1

True

Question 2

When a record is deleted from a table,the action can be reversed.

Answer 2

False

Question 3

In Access,the Expression Builder is used to create a table.

Answer 3

False

Question 4

An Access table that is closed and then reopened will sort and display its records by its ____.

A) primary key
B) foreign key
C) field
D) name

Question 5

When you create a lookup field list and enable the Limit to List check box,entries can be manually typed or selected from the lookup list.

Question 6

To remove a sort that you just applied,click the Remove Sort button.

Question 7

When table data is sorted in descending order,it is sorted ____.

A) by foreign key
B) by primary key
C) from A to Z
D) from Z to A

Question 8

A form can be used to add a new record to a database table.

Question 9

Access sorting tools are found on the ____ tab in the Sort & Filter group.

A) SORT
B) HOME
C) DATABASE TOOLS
D) FIELDS

Question 10

The Form Wizard supports adding only primary and foreign keys to a new form.

Question 11

Once a calculated field is completed,it can subsequently be changed.

Question 12

Changing the layout of a form changes the layout of its underlying table.

Question 13

When table data is sorted in ascending order,it is sorted ____.

A) by foreign key
B) by primary key
C) from A to Z
D) from Z to A

Question 14

A recently applied sorting action can be removed by clicking the Undo button in the Quick Access Toolbar.

Question 15

When a column is filtered,a(n)____ symbol appears in the column field header.

A) funnel
B) arrow
C) toggle
D) tunnel

Question 16

An Access subdatasheet displays records from the last database you created.

Question 17

In Access,when building a mathematical formula,an asterisk represents multiplication.

Question 18

A preform is a form within a form that contains data from a related table.

Question 19

After clicking the Form button to create a new form,its displayed fields and layout can be changed.

Question 20

To create a form using the Form Wizard,you should first select the row on which the form will be built.

Question 21

To quickly create a new form,click the CREATE tab on the ribbon and select ____ in the Forms group.

A) Quick Form
B) Blank Form
C) Form Wizard
D) Form Design

Question 22

To automatically create a new form containing all fields in a selected table,click the CREATE tab on the ribbon and select ____ in the Forms group.

A) Form
B) Blank Form
C) Form Wizard
D) Form Design

Question 23

Which of the following is a valid expression in an Access table calculation?

A) [UnitPrice] x [NumPartic]
B) (UnitPrice)* (NumPartic)
C) {UnitPrice} x {NumPartic}
D) [UnitPrice] * [NumPartic]

Question 24

In Access,a subform can be defined as ____.

A) two individual forms
B) one form inside of another form
C) wizard-created forms
D) a simple form

Question 25

You click the Customer table and select Form to create a new form.What happens next?

A) A new form appears with the primary and foreign key fields for the Customer table.
B) The Form Wizard appears to walk you through form creation.
C) A new form appears with all of the fields from the Customer table.
D) none of these

Question 26

When a calculated field is set to ____,the field is formatted with dollar signs and decimal places.

A) Number
B) Currency
C) Dollar
D) Money

Question 27

After you click the Form button,the ____ Tools tab becomes visible.

A) Table Layout
B) Database
C) Wizard
D) Form Layout