23.
When you drag and drop a primary key onto a foreign key, what relationship
does Microsoft Access assume it to be?
24.
What relationship exists when a primary key may appear many times as a
foreign key, and a foreign key must appear once and only once as a primary
key?
25.
When you drag and drop a foreign key onto a primary key, what does
Microsoft Access assumes the relationship is?
26.
Which of the following phrases would indicate that you are entering
information into a database table?
27.
After typing in the appropriate information into each field, what key can be
used to get to the next field?
28.
Once you have entered all the information into a given table and closed the
tab for that table, what happens to the information?
29.
What happens when you attempt to input incorrect information into a field
that has an Enforce Referential Integrity option in effect?
30.
Which of the following tasks do you need to be careful of, when making
changes to the information in any of the relations (tables or files) of the
database structure?
31.
To change the structure of a relation (table or file), what needs to be open
in Microsoft Access?
32.
What does the query-by-example tool in Access allow you to do?
33.
If you needed to identify inventory items whose stock was running low,
which Access tool could help you find the answer?
34.
When creating a simple query with one relation, you first open the file.
Following this step, what area would you drag and drop the field names in
order to run the query?
35.
Once a QBE has been designed what do you click on, to actually get it to
run?
36.
If you wanted to limit the output of data to transactions occurring after April
1, 2009, what tab or object would you select?
37.
What type of query seeks results based on some specification?
38.
Which of the following options would be the correct way to construct a
conditional query in one relation whereby to pass this course, you must
have at passing grade of 75 or more?
39.
What is the fundamental difference between tables (or queries) and
reports?
40.
Which Access Wizard would you use if you want to generate a simple
report?
41.
If you needed to create a statement of accounts that would be printed at
the end of each month, what Access tool would you use?
42.
If you needed a title to print on the first page of a multi-page report, where
would you place this title in the report design?