Exam 5: Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

A step-by-step guide that walks users through tasks to help you create a form,query,or report is a(n)________.

Data ________ is the result of repetition of data in tables in a database.

A way to interface with a table other than in the Datasheet view is a(n)________.

A(n)________ is the run time table created as the result of a query.

Storing,managing,and providing access to business records is the purpose of a(n)________.

A ________ contains all the data concerning one person,place,thing,or event.

A database management system program developed by Microsoft is ________.

The operator ________ selects the records where the field values listed are within the two values.

Grouping records puts them within a specific ascending order based on field values.

While a sample database has sample data included with it,a(n)________ is a database that has a structure and definitions,but no data.

Breaking up a field such as address into multiple fields makes it easier to develop a report based on city or state.

A ________ is a table created at run time.

Linking ________ together is what makes databases powerful.

The ONLY view available in the Navigation Pane is all objects such as tables,queries,forms,and reports organized by object type.

When you need to analyze the data in an Access database,you should export a query to Excel and use the analysis tools in Excel.

When you want to limit the amount of data that can be accessed by data entry clerks,you create a database ________ through which they can interact with the data they need to do their work.

A view that shows how a report will look on the printed page is the ________ view.

Data stored and organized in an arrangement of columns and rows is called a(n)________.

The data pertaining to one person,place,thing,or event is called a(n)________.