Access Tutorial 3

access tutorial 3

Multiple Choice

Identify the choice that best completes the statement or answers the question.

____1.Using ____, you give Access an example of the information you are requesting; Access then retrieves the information that precisely matches your example.

a. / SQL / c. / XML
b. / QBE / d. / HTML

____2.A query can be run at any time during the creation of the query by clicking the ____ button in the Results group on the on the Query Tools Design tab.

a. / Display / c. / View
b. / Show / d. / Query

____3.____ tables are separate tables but you can use the data in them as if they were one table.

a. / Joined / c. / Cascading
b. / Matched / d. / Integral

____4.____ fields can be unique or nonunique.

a. / Primary key / c. / Cascading
b. / Sort / d. / Foreign key

____5.When a query is run, the datasheet contents are ____.

a. / saved as part of the query structure
b. / temporary
c. / stored in a query table
d. / based on the criteria you establish in the field list

____6.You can automatically include all of the fields in a table in a query by ____ the asterisk that appears in the Field List box in Query Design view.

a. / clicking / c. / double-clicking
b. / right-clicking / d. / dragging

____7.You can use a common field to create relationships between tables by performing a(n) ____.

a. / hyperlink / c. / integration
b. / connection / d. / join

____8.If a record in one table matches several records in a related table, the relationship is called a(n) ____ relationship.

a. / consistent / c. / many-to-one
b. / one-to-many / d. / nonunique

____9.Before you can click a sort button on the toolbar to sort the data, you must first ____.

a. / determine the primary key
b. / click the View button
c. / select a column on which to base the sort
d. / save the query

____10.A temporary subset of selected records can be created by defining a ____.

a. / hyperlink / c. / screen
b. / filter / d. / report

____11.After applying a filter, you can click the ____ button to toggle between filtered and nonfiltered displays.

a. / Run / c. / Remove Filter
b. / View All / d. / Toggle Filter

____12.A selection condition that dictates that the value in the specified field must precisely match the condition is known as a(n) ____ match.

a. / specific / c. / selection
b. / exact / d. / value

____13.Access allows you to improve the appearance or readability of the results datasheet by changing the ____.

a. / font type / c. / column size
b. / font size / d. / all of the above

____14.The ____ operator will cause a record to be selected only if two or more conditions are satisfied.

a. / Or / c. / range
b. / If...Or / d. / And

____15.The query shown in the figure above will select a record if ____.

a. / EndDate is blank
b. / StateProv is blank
c. / StartDate is 7/1/2006 or StateProv is PE
d. / any of the above

____16.The Maximum function determines ____.

a. / the highest field value for the selected records
b. / if too many fields have been defined for the query
c. / when too many sort keys have been specified
d. / when memory needs to be refreshed

____17.Statistical information, such as totals and averages, can be calculated in a query by using a(n) ____.

a. / expression / c. / aggregate function
b. / condition / d. / comparison operator

____18.The join line for a one-to-many relationship will show the ____ symbol on the "many" end of the line.

a. / number / c. / infinity
b. / asterisk / d. / anchor

____19.The ____ operator is a comparison operator that allows you to check whether or not a particular field value is part of a list of values.

a. / Like / c. / In ()
b. / Between / d. / List

____20.To choose fields for a Select Query in Design view, _____.

a. / double-click the fields in the field list / c. / use the field arrow
b. / drag the field from the field list / d. / both a and b

____21.To delete a record, you must ____.

a. / find the record you want to delete
b. / click the row selector to select the entire row
c. / click the Delete button
d. / all of the above

____22.You can’t delete a record in a table if the table ____.

a. / is in Datasheet view
b. / has a plus sign at the beginning of the record
c. / has a minus sign at the beginning of a record
d. / both b and c

____23.In the figure above, the arrow labeled 3 is pointing to the button used to start the ____.

a. / query / c. / query design
b. / Show Table dialog box / d. / design grid

Case 2

Parkhurst Health & Fitness Center Martha Parkhurst needs to change a few records in

the Fitness database, and analyze the records for members enrolled in different programs

at the fitness center.

____24.The arrow labeled 1 indicates that Martha has chosen City as the ____ field.

a. / primary key / c. / secondary sort
b. / primary sort / d. / secondary key

Case 3

Rossi Recycling Group Tom Rossi needs to modify some records in the Rossi database and then he wants to find specific information about the donors, agencies, and donations to his not-for-profit agency. Tom asks you to help him update the database and create queries.

____25.Tom needs a calculation in his query to subtract the pickup charge of $8.75 from the Donation Value field values. The formula will look like ____.

a. / Donation Value-8.75 / c. / [Donation Value]-8.75
b. / [Donation Value]-$8.75 / d. / (Donation Value)-8.75