Upgrade to remove ads
Only $35.99/year

Access

Terms in this set (20)

To pull data from one or more tables
Why would you use a query?

*To pull data from one or more tables
*to edit data
*to arrange data in a special format for printing
*to display data in form view
find records that meet a certain condition
The purpose of creating a query is to:

*sort records chronologically
*open a related database
*find the relationship between two tables
*find records that meet a certain condition
field of data
When the tables in an Access database are referred to as related, it means they have a common:

*field of data
*row of data
*set of criteria
*set of records
filters
In Access, you can print all the following except:

*reports
*queries
*tables
*filters
Tab
When entering data in a table or form, use the ____ key to move to the next field.

*Tab
*Backspace
*Down Arrow
*Up Arrow
all the records in the State column
Suppose that you have a customer table containing a field called State. If you click the first record in the State column and then click the Align left button in the Text Formatting group on the Home tab, what record(s) will the formatting be applied to?

*Only the first record in the State column
*all the records in the State column
*all the records in all of the columns
*all the fields in the first record
it automatically updates whenever changes are made to the data in those objects
Because an Access report is linked to the objects used to create it:

*it must be revised whenever changes are made to those objects
*it does not need queries
*it automatically updates whenever changes are made to the data in those objects
*it cannot be deleted
Ascending
To alphabetize records by last name from A to Z, click the ____ button:

*Descending
*Ascending
*Filter
*Remove Sort
tables
A query extracts data from one or more:

*reports
*databases
*tables
*forms
left and right pointing arrow with a vertical line in the middle
To widen a column so it displays all the data, hover the mouse pointer over the right border until the pointer changes to a ____ and then double-click:

*left and right pointing arrow with a vertical line in the middle
*four-headed arrow
*pointing hand
*plus symbol
over and over again
Once you create a query in Access, you can run it:

*over and over again
*only once
*whenever the table on which it is based has been updated
*as many times as you want until the database is closed
organized collection of related data
A database can best be described as an:

*type of software
*process used to deliver information to a user
*organized collection of related data
*collection of related fields
Filter button in the Sort & Filter group
If you have a table of customers and you want to display the records of only those people who live in a certain city, you should click the ___ on the Home tab:

*Filter button in the Sort & Filter group
*Records button in the Sort & Filter group
*Advanced button in the Records group
*Sort button in the Sort & Filter group
populating
Adding records to a database is sometimes referred to as ____ the database:

*expanding
*exploding
*populating
*seeding
Query Wizard
15. The ____ pulls data from fields that you choose:

*Query Wizard
*Extractor
*Questioner
*Summary Wizard
form
16. Access allows you to enter data in a table or a:

*query
*form
*report
*macro
copy the entire existing record and then make the necessary changes
When creating a new record that is almost identical to an existing record, it is best to:

*copy the entire existing record and then make the necessary changes
*copy only the parts of the existing record that will remain the same in the new record
*create the new record from scratch
*make the changes to the existing record and then copy it to create the new record
Saves it as an object in the database
When you create a query, Access:

*stores it on the clipboard
*stores it in ROM
*treats it exactly like a filter
*Saves it as an object in the database
primary key
To prevent having duplicate entries in a field, assign a _____ to the field:

*primary key
*description
*index
*filter
query
To select data that meets a set of criteria, you should use a:

*query
*report
*table
*form
Recommended textbook explanations

Introduction to the Theory of Computation

3rd EditionMichael Sipser
389 explanations

Computer Organization and Design

5th EditionDavid A. Patterson, John L. Hennessy
220 explanations

MyProgrammingLab with Pearson eText -- Access Card -- for Java How to Program, Early Objects

10th EditionHarvey M. Deitel, Paul J. Deitel
356 explanations

Engineering Electromagnetics and Schaum's Outline of Electromagnetics

8th EditionJohn Buck, William Hayt
483 explanations