Deck 2: Formatting Workbook Text and Data

Question 1

_____ 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

Answer 1

C

Question 2

You can use the _____ to copy data from Excel to Access.

A) Linking Spreadsheet Wizard
B) Import Spreadsheet Wizard
C) Edit Relationships dialog box
D) Copy Data dialog box

Answer 2

B

Question 3

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

A) Import the data into a new table.
B) Append the data to an existing table.
C) Link to the workbook by creating a linked table.
D) Import the data into a new report.

Answer 3

A,B,C

Question 4

You can set the Field Size property for a field with a Short Text data type.

Question 5

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

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

Question 6

The _____ key field is the linking field on the "many" side of the relationship.

A) primary
B) referential
C) AutoNumber
D) foreign

Question 7

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

Question 8

Which of the following are good candidates for a primary key field for a Customer table? Select all the options that apply.

A) CustomerNumber
B) LastName
C) CustomerID
D) IdentificationNumber

Question 9

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

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

Question 10

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

A) properties
B) links
C) tables
D) keys

Question 11

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

Question 12

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

Question 13

You can import table data from _____.

A) another Access database
B) a PDF file
C) a Word document
D) an email message

Question 14

____ makes a duplicate copy of the data in the Access database.

A) Linking
B) Compacting
C) Importing
D) Relating

Question 15

If the query design grid contains three fields named ProductName,Price,and DateOrdered,how does the datasheet list records if you add a descending sort to the Price field?

A) in alphabetic order by ProductName
B) from the most recent to the oldest DateOrdered
C) from lowest to highest Price
D) from highest to lowest Price

Question 16

Which of the following statements are true about one-to-many relationships? Select all the options that apply.

A) The primary key field is on the "one" side of a one-to-many relationship.between two tables.
B) A linking table connects the two related tables.
C) A record in one table may be related to many records in another table.
D) The foreign key field is on the "many" side of a one-to-many relationship.

Question 17

When can you rename a table?

A) immediately after you open the table
B) after you close the table
C) when you open the table in Datasheet view
D) when you open the table in Design view

Question 18

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

Question 19

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

Question 20

You can import Access table data from which of the following Office apps? Select all the options that apply.

A) PowerPoint
B) Access
C) Excel
D) Outlook

Question 21

What data type should you assign to a WeeklySalary field?

A) Currency
B) Salary
C) Number
D) Date/Time

Question 22

How do you rename a table?

A) Right-click the object tab in the Access window,and then click Rename.
B) Right-click the table in the Navigation Pane,and then click Rename.
C) Click the table in the Navigation Pane,and then click the Rename button.
D) Open the table in Table Datasheet view,and then click the Rename button.

Question 23

What Field Size should you set for a State field that stores two-character state abbreviations?

A) 255
B) 5
C) 2
D) 0

Question 24

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

Question 25

Which of the following properties can you apply to a Number field in Report Design view? Select all the options that apply.

A) Format = Currency
B) Decimal Places = 0
C) Decimal Places = 1
D) Format = Conditional

Question 26

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

Question 27

To rename a table,you must use the Navigation Pane.

Question 28

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.

Question 29

Changing the _____ property for a field does not change the actual data stored in the field.

A) Short Text
B) Primary Key
C) Decimal Places
D) Number

Question 30

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.

Question 31

For a State field that stores two-letter state abbreviations,you can set the _____ property for the field in Table Datasheet view.

A) Default Value
B) Format
C) Field Size
D) Lookup

Question 32

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

Question 33

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

Question 34

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

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

Question 35

Which of the following are properties you can set for a Currency field? Select all the options that apply.

A) Format
B) Decimal Places
C) Default Value
D) Field Size

Question 36

What happens if you delete a field from a table that contains data?

A) Access stores the deleted data in a new table.
B) Access stores the deleted data in a new field in the same table.
C) You can append the deleted data to an existing table.
D) You delete all the data in the field.

Question 37

If a field named Price displays values with three decimal places,what should you do to display the values accurately?

A) Increase the number of decimal places.
B) Re-enter the field values.
C) Change the data type of the field.
D) Decrease the number of decimal places.

Question 38

You typically increase the decimal places from 1 to 2 for a(n)_____ field.

A) Currency
B) AutoNumber
C) Long Text
D) Money

Question 39

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

Question 40

If you set the Decimal Places property to 0 for a Price field,and then enter 750.25 in the field,what does Access display in the datasheet?

A) 750.25
B) 750.2
C) 750
D) 751

Question 41

To relate two fields in a one-to-many relationship,you connect them using a _____.

A) subdatasheet
B) common field
C) field key
D) data type

Question 42

To move a field in the query design grid,click its_____,and then drag it left or right.

A) field tag
B) field key
C) field string
D) field selector

Question 43

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

Question 44

To import data from Excel to Access,you would begin by clicking the ____.

A) Edit Relationships button
B) Property Sheet button
C) Relationships tab
D) External Data tab

Question 45

The Import Spreadsheet Wizard helps you import Excel data into Access.

Question 46

You use the Insert Rows button on the Query Tools Design tab to _____.

A) insert a row in the query design grid
B) insert a row in the selected field list
C) insert a row in the query datasheet
D) insert a new query design grid

Question 47

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Question 48

Which process is most like copying and pasting?

A) importing
B) relating
C) querying
D) linking

Question 49

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

Question 50

When a record from one table is related to several records in another table,the tables have a one-to-many relationship.

Question 51

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

Question 52

If a City field displays the value "Chicago" for a new record,that means the Default Value property for the City field has been set.