Exam 15: Access: Introduction to Powerpoint

An expression used in queries to filter records in a table is called a(n):

A sort can only list records in a specific numeric sequence.

Data from two or more tables can be connected by specifying a:

The navigation buttons allow you to:

The ________ view in Access looks similar to an Excel Spreadsheet.

A set of data such as first name, last name, address, etc. for a specific person is a(n) ________.

A primary key from one table that is used to form a relationship with a second table is called a(n) ________.

You can ________ a database in order to protect your data against loss or damage.

When choosing between Access and Excel, it is best to use Excel in all of the following circumstances EXCEPT:

David is working in a database that organizes student exam grade information. He needs to find all students who have scored 100 on an exam. David can apply a(n) ________ to the data in order to show only records that meet the criteria.

________ order sorts a list of text data in alphabetical order from A to Z, or a numeric list in lowest to highest.

A form allows you to view and maintain your data in a customized format.

A(n) ________ only displays records that match selected criteria.

The navigation buttons allow you to step through a table record by record, or to quickly go to the first or last record in the table.

To view data fields that are not visible on your display you can use the vertical or horizontal ________.

Access is made up of different types of ________, which may include tables, forms, reports, and queries.

By defining a report, you can create a formatted printout or display of the data contained in one or more tables.

A primary key:

A ________ displays a subset of records based on specified criteria.

A descending sort organizes a list of numeric data in lowest to highest order.