Filters
Question type

Study Flashcards

If you move the City column in a table datasheet, _____.


A) the City field also moves in Table Design view
B) you must switch to Table Design view and move the City field
C) you change the appearance of the table but not the structure
D) you must reassign properties for the City field

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

You can right-click the status bar to display the _____.


A) number of records in a table
B) Quick Access Toolbar shortcut menu
C) Database Views shortcut menu
D) Customize Status Bar shortcut menu

E) A) and D)
F) A) and B)

Correct Answer

verifed

verified

When you import Excel data, you create a link to the data in the Access database.

A) True
B) False

Correct Answer

verifed

verified

Characteristics, such as Field Name and Data Type, are_____ that define a field.


A) descriptions
B) definitions
C) properties
D) formats

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

You cannot set the Field Size property for Short Text fields in Table Datasheet view.

A) True
B) False

Correct Answer

verifed

verified

To move a field in Table Datasheet view, you select the column and then _____.


A) copy and paste it at the end of the table
B) drag it to a new location
C) click the Move button on the Fields tab
D) right-click the field and select a new location

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

In Table Datasheet view, you must use a property sheet to increase the decimal places in a Number field.

A) True
B) False

Correct Answer

verifed

verified

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.


A) A one-to-many relationship
B) A common field
C) Referential integrity
D) Data redundancy

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.


A) field
B) record
C) data type
D) property

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

Which of the following are possible entries for the Field Size property of a Number field? Select all the options that apply.


A) Currency
B) Long Integer
C) Byte
D) Single

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

What property do you use to set the Graduated text box in a form to display "Yes" in each new record?


A) Record Source
B) Limit to Default
C) Default Value
D) Opening View

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

Access sets the number of decimal places in a Number field, and you cannot change it.

A) True
B) False

Correct Answer

verifed

verified

False

Which field is always on the "one" side of a one-to-many relationship between two tables?


A) primary key field
B) foreign key field
C) AutoNumber field
D) first field in Table Design view

E) A) and B)
F) C) and D)

Correct Answer

verifed

verified

A

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?


A) Decrease the number of decimal places.
B) Increase the number of decimal places.
C) Apply the Percent format to the field.
D) Apply the Comma Number format to the field.

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

If you want the State field to display "Iowa" in each new form record, you set the Control Value property for the State field.

Correct Answer

verifed

verified

False - De...

View Answer

To delete a field in Table Datasheet view, you click _____.


A) any value in the field
B) the first value in the column
C) the record selector for any record
D) the column heading for the field

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

To move a field in Query Design view, you drag the field by its field selector.

A) True
B) False

Correct Answer

verifed

verified

The _____ property controls how many characters can be entered into the field.


A) Format
B) Required
C) Input Mask
D) Field Size

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

The goal of building one-to-many relationships between tables is to minimize _____ data.


A) misspelled
B) rarely used
C) numeric
D) redundant

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

D

To decrease the decimal places in a Number field in Report Design view, you can use the Decrease Decimals button or the Decimal Places property.

A) True
B) False

Correct Answer

verifed

verified

Showing 1 - 20 of 55

Related Exams

Show Answer