Intermediate Access

Name:

1. The foundation objects in Access databases are...

 queries.
 tables.
 reports.
 forms


2. Forms in Access databases can be based on information located in...

 queries.
tables.
other forms.
all of the above.


3. When creating a table in datasheet view, it is possible to edit field attributes.

 True.
 
False.


4.  Which of the following field attributes can be modified from the object property list box?

 Only the formatting field attributes.
 
Only highlighted field attributes.
 
All displayed field attributes.
 
None of the above.


5. Which of the following is NOT a method of creating a form based on an existing table?

 Select a form template
 
Select Auto form feature from the insert menu.
 
Activate the form wizard.
 
Create a form in design view.


6. It is possible to create a query that uses multiple criteria for a single field.

 True.
 
False.

 
  


7. Changing field names in an existing table could affect existing...

 forms/sub forms
 
queries.
 
reports.
all of the above.


8. Report creation in Access is most commonly based upon...

 forms.
 
queries.
 
default values.
 
All of the above.


9. Wizards in Access can assist the user in the creation of data relationships.

 True.
 
False.


10. Which of the following is an example of a data relationship that can be created in Access?

Equi-join.
One to many.
Many to one.
All of the above.