Exam 5: Workshop 5: Advanced Tables

A Lookup field is used to replace a number such as an ID (or other foreign key value)with something more meaningful,such as a name.

The Yes/No data type allows you to set the Format property to either the Yes/No,True/False,or On/Off predefined formats or to a custom format for the Yes/No data type.

Which of the following is NOT true about the first part of a custom Yes/No field?

The only data types for which you can create a lookup field are Text and ________.

Indexes are created and used to decrease performance.

If you create a field in a table that combines the first name and last fields from the same table,you need to use the ________.

Some database designers say that adding calculated fields in a table violates ________ rules.

Which of the following is NOT true about the third part of a custom Yes/No field?

When using the Yes/No data type,the ________ is the default option to indicate that the option is selected.

Many databases contain a large amount of data.________ are created and used to increase performance.

By ensuring your data is consistent and accurate,you are enhancing the usability of your data.

________ is very useful where you can view and print only the desired and required information from your database.

When importing data,the Table Analyzer Wizard is unable to restructure all the imported data properly.

Which of the following is NOT true about indexes?

________ formats can also be created with the Yes/No data type.

You can enter different characters,such as placeholders,separators,literal characters,and colors,in the ________ of a field to create a custom format.

________ are created and used to increase performance.

A(n)________ is like an alias.Once this property is established,every object you create will display this instead of the field name.