Exam 5: Workshop 5: Advanced Tables

The ________ data type stores an integer that Access creates automatically as you add new records and can be categorized as sequential or random.

Which of the following is true regarding the AutoNumber data type?

A(n)________ can display a user-friendly list that is either linked to another field in a related table or a value list.

Match the following Table Analyzer Wizard screens to their description: I.Create Primary Keys II.Review Grouping III.Create a Query IV.Solving the Problem V.Select Table A.How Access may split the table B.Bold fields C.What you want to analyze D.Where you create new tables E.Resembles your old table

When filtering data,the ________ type could be used,which displays only the rows in a table containing a value that matches a selected value in a row by filtering the Datasheet view.

You can create a(n)________ index for a combination of fields with a maximum of 10 fields.

If you create a(n)________,Access will not let you enter a new value in the field if that value is already entered in the same field within another record.

A caption is like an alias.A caption does not change the actual field name,just the way users see it.

If you create a(n)________,Access will not let you enter a new value in the field if that value is already entered in the same field within another record.

An ideal surrogate key is short,alpha-numeric,and never changes.

Which of the following is NOT true about the Required data property?

When filtering data,you might want to apply a filter that is a(n)________ in which you write the filter criterion yourself.

Which of the following is NOT true in regard to data validation rules?

The ________ Principle means that inconsistent or inaccurate data leads to inconsistent or inaccurate output.

Which of the following is TRUE about input masks?

The purpose of a multivalued field is to replace the display of a number such as an ID (or other foreign key value)with something more meaningful,such as a name.

The Caption property helps control the way data is entered.

The ________ property is like an alias.

Match the following custom format characters to their description: I.Forces left alignment II.Displays the character that follows III.Display a digit or blank IV.Fills the available space with the next character V.Display a digit or 0 A.\ B.! C.0 D.# E.*

After creating a Lookup Field,you need to rename the Lookup Field label because Access does not use appropriate names.