Access Final

microsoft access can best be described as ____ software.

which is NOT true about access?

tables, queries, and forms are examples of access ____.

which of the following is NOT available to you as you start access?

which access object provides an easy-to-use data entry screen?

which is NOT a feature of access reports?

which access object contains all of the raw data within the database?

____ view provides the most options for defining fields.

which of the following is NOT a data type?

which data type is use for sequential integers controlled by access?

which data type stores only one of two allies?

which data type links files created in other programs such as pictures or documents?

which data type stores web addresses

a specific category of data such as a customers name, city, state, or phone number is called a(n)____.

a group of related fields, such as all the demographic information for on customer, is called a(an) ___.

which two properties are required for every field?

___ integrity refers to a set of access rules that govern data entry and helps to ensure data accuracy.

in a datasheet, which mode issues that you are trying to change the value of a particular field?

in the navigation mode, press [Tab] or ___ to move to the next field within the same record.

which shortcut key moves focus to the previous field of the current record?

which shortcut key moves focus to the first field for the current record?

which keystroke combination moves focus to the last field of the last record?

while editing a record, pressing[Esc] twice ___/

to review a printout of a table before printing, on the ___tab, click print preview.

which of the following keys will help you delete unwanted data in edit mode?

which editing keystroke deletes on character to the right of the intersection point?

SQL stands for ___/

a query datasheet is sometimes called ___ of the data.

in large dottiest, you may want to ___ certain fields so that they remain on the screen at all times.

you use query design view add __ to limit the umber of records shown in the resulting data sheet

query design view presents the fields you can use for the query in small windows called field ___.

access saves ___ automatically as you move from record to record

use the __ command to save the current object with a new name.

a join line also called a(n) ___ line.

the accompanying figure shows the database in ___ view.

in the accompanying figure, the item with the infinity sign at one end and the number 1 at the other is called a(n) __ line.

in the accompanying figure, the "statename" and "price" are __ names.

in the accompanying figure, "statesman" and "state abbreviation" appear in the states ___ list.

to move a field in the query design grid, click it's ___, and the drag it left or right.

when you double-click a field in a field list in query design view, it is ___.

the button in the accompanying figure ____.

A(n) ___ is temporary view of the data that is removed when you close the data sheet

the wildcard character that stand for nay number of character is the ___.

the wildcard character that stands for any single character is the ___.

A(n) ___ is a saved object within the data sheet.

the __ button provides a list of values in the selected field that can be used to customize a filter.

the __ button filters records that equal, do not equal, or are otherwise compared with the current value.

criteria __ are rules that specify how to enter criteria in a query.

__ are tests or limiting conditions you set to determine which records will be selected in a filter or query