Access Ch.2 Using Design View, Data Validation, and Relationships
The maximum size of a short text field is: a. 255 characters b. 64 characters c. unlimited characters d. 96 characters e. 244 characters
a. 255 characters
When you need to change field properties in an existing table, open: a. datasheet view b. field view c. database tools d. design view e. a new table
a. datasheet view
Which of the following is used to enter records into a table? a. datasheet view b. design view c. lookup view d. validation view e. object view
a. datasheet view
When you need to create a new table from scratch in your database, use: a. design view b. datasheet view c. lookup view d. table view e. object view
a. design view
When you limit entries to a certain range of values or make sure entries match a specified format, you use: a. field validation rules b. datacheck c. parameters d. access rules e. navigators
a. field validation rules
Which of the following properties indicates the way a field displays in a table? a. format property b. lookup property c. required property d. caption property e. cell property
a. format property
Which of the following contains a unique value for each record? a. primary key b. lookup filed c. input mask d. metadata e. cell number
a. primary key
How does access store a "yes" response for the yes/no data type? a. -2 b. -1 c. 0 d. 1 e. 2
b. -1
The overall descriptions about what the different data fields represent and their formats is called: a. details b. validation c. metadate d. summary e. primary data
c. metadata
The property which specifies that a user must enter a value in a field is called: a. mandatory b. complete c. required d. primary e. limited
c. required
Which of the following displays the contents of a filed and also allows the user to type a value into that field? a. input field b. lookup field c. text box d. input mask e. combo box
c. text box
When you set field properties, the available properties vary based on the: a. field length b. field target type c. field name d. field data type e. list properties
d. field data type
The field in common between two tables is called the: a. common denominator b. identifier c. linking field d. foreign key e. memo field
d. foreign key
Which of the following must you do before adding a field between existing fields? a. enter a field name in the field list b. enter a data type c. select a primary key\ d. insert a new row in the field list e. insert a new column in the field list
d. insert a new row in the field list
If you change the required property of a filed from No to Yes, access: a. deletes the empty fields b. flags the empty fields c. accepts the change without error d. automatically runs a data integrity test e. warns that data integrity rules have changes
e. warns that data integrity rules have changed
