Questions:
Question 1.To delete the filter shown below
click Filter in the Sort & Filter group and select Clear Filter.
click Remove Filter in the Sort & Filter group.
right click on any number in the Quantity column and select Clear filter from Quantity.
right click on any record in the table and select Clear filter from Quantity.
Question 2. Which object would you use to retrieve customers who live in Germany and the United States?
Criteria
Form
Query
Table
Question 3. Which of the following is NOT an Access interface element?
Criteria
Navigation Pane
Status Bar
Title Bar
Question 4. All of the following filters work EXCEPT
filter by selection with an equal condition.
filter by selection with a comparison operator.
filter by selection with an edit operator.
filter by form with a comparison operator.
Question 5. A Detail line is used to
print more detailed information on one record only.
provide additional field information on a record.
repeat data for each record in the record source.
All of the above
Question 6. The number of records in a relationship is a(n)
cardinality.
domain.
entity.
key.
Question 7. Which of the following should be considered when designing a database?
How calculated fields are used
Store data in its smallest parts
The relationship between attribute keys
The relationships between records
Question 8. All of the following apply to the relationships image found below EXCEPT
a one-to-many relationship is found between the Suppliers table and the Products table.
a relationship exists between the two primary keys of the Suppliers table and the Products table.
one table is not joined to the two other tables.
the primary key for the Categories table is CategoryID.
Question 9. Summarized data in an easy-to-read view is known as a
design.
PivotTable.
report.
table.
Question 10. Which of the following is NOT true of a property?
A property is an object's characteristic or attribute.
Tables, forms, queries, and reports have a set of properties.
A property sheet is used to make changes.
Design properties are displayed in Datasheet View.
Question 11. In a ________ dependency, a relationship exists when one attribute uniquely identifies another attribute. For example, if we had a table consisting of the following attributes: instructor, course, time and room number. Course would uniquely identify an instructor.
Structural
Functional
Referential
Transitive
Part 2
Question 1. To edit a form, use datasheet view.
design view.
layout view.
layout view or design view.
Question 2. A bound control
always contains a label.
contains text and number values entered by the user.
is unique and contains a data field from another underlying source.
must contain a formula.
Question 3. Which of the following statements is NOT correct about a query?
Changing data values in a query will not change data values in a table.
Data is not saved within a query.
Instructions on which data to display are saved within a query.
Instructions on the format to display data are saved within a query.
Question 4. The benefit of a relationship is to
efficiently combine data from related tables.
facilitate how Access will manage the relationship.
determine which fields to include in each table.
minimize data redundancy.
Question 5. To display continuous data, use the following chart.
Bar
Column
Pie
Line Chart
Question 6. Which of the following statements best describes data mining?
It is the determining of future volume of sales.
It is the predicting of future customer buying behavior.
It is identifying patterns or relationships through a process of analyzing large quantities of data.
It is tracking customer purchasing behavior.
Question 7. The Switchboard Manager is an Access utility that is used
by all database users.
to create and manage the menu items for a switchboard.
to make certain objects unavailable to some users and available to others.
to manage and optimize the database.
Question 8. A good password should have
a combination of five letters.
a combination of six to eight letters in uppercase and lowercase, numbers, and symbols.
a word or name that is easy to remember by the user, such as the name of your children.
part of your account name.
Question 9. All of the following are true when a user creates their own self-signed digital signature EXCEPT
a time stamp is not required to go through a commercial service or local server for processing.
a time stamp will prove when the file was last used.
it is created through another software application.
it will prove that the creator owns the database.
Question 10.After creating an ACCDE file, you
can convert it back to its source format.
will see a "file already in use" message that continues to display to all other users.
will be able to modify forms and reports but not tables.
will need to go back to the original file if an underlying object requires a change.
Question 11.Which statement below is NOT true of the one-to-many relationships?
It is the least used type of relationship.
OrderID is a unique identification number that would be used in the Orders table and Order Details table.
Each record in the Orders table may match one, more than one, or no records in the Order Details table.
Each record in a Orders table matches only one record in the Customers table.