Exam 5: Workshop 5: Advanced Tables

A(n)________ stores the location of your records based on the field or fields that you select.

Access can also store images inside a database field by using the ________ data type.

You can have Access check data as it is entered to help improve its accuracy and consistency by using ________.

Access can store e-mail addresses inside a database field by using the ________ data type.

When a table contains repeating information in one or more fields,such as a city or state,you can use the Table Analyzer Wizard to move the data into related tables.This process is called ________.

When filtering data,the ________ type could be used,which allows you to filter data in a form or datasheet.

When Access creates new tables in the Table Analyzer Wizard,it is looking for a way to maximize storage space in the analyzed table by storing data more efficiently.

Data validation text prevents bad data from being entered and consequentially stored in your database.

When a table contains repeating information in one or more fields,such as a city or state,you can use the Table Analyzer Wizard to move the data into related tables.This process is called normalization.

Custom number formats can have one to four sections with ________ separating each section.

Which of the following do advanced data types NOT allow for?

If all the field values contain data with a consistent pattern,you should define a(n)________.

A(n)________ field helps you keep track of multiple related facts about a subject.

Match the following terms to their definition: I.Filter II.Filter by Form III.Filter by Selection IV.Advanced filter V.Save Object As A.Write the filter criterion yourself B.Creates a blank table for the selected table C.A temporary view of the data D.Done in Backstage view E.May require extra steps

________ prevent bad data from being entered and consequentially stored in your database.

You can attach images,spreadsheet files,documents,charts,and other types of supported files to the records in your database,much like you attach files to an e-mail message.

You can use the ________ to customize the way numbers,dates,times,and text are displayed and printed by using predefined formats or custom formats.

When importing data,the ________ minimizes the need for data re-entry,saving you valuable time and resources.