Access Unit 1 Exam

True/False
Indicate whether the sentence or statement is true or false.

____	1.	If a field has a data type of Number, text can be entered into the field.

____	2.	The Home tab contains commands that are used frequently.

____	3.	For the Yes/No data type, the only possible values for the fiels are yes or not.

____	4.	Though a field has an nput mask, Access will NOT automatically insert the parentheses around the area code and the hypen in the Phone Number field.

____	5.	Fields with the datatype of Yes/No may contain checkboxes.

Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.

____	6.	In Access 2007, you can view a datasheet and a form _______.
a.	independently	
b.	for set time periods	
c.	simultaneously	
d.	none of the above	

____	7.	_______ are the details about a file.
a.	Database properties	
b.	Database objects	
c.	Database certificates	
d.	none of the above	

____	8.	A collection of organized, useful data is know as a/an ______,
a.	data entry	
b.	database	
c.	form	
d.	query	

____	9.	Access does NOT have the following feature:  ______.
a.	Data entry and update	
b.	Reports	
c.	Web support	
d.	Slideshow	

____	10.	Rrows in the tables are called _____.
a.	entries	
b.	fields	
c.	records	
d.	none of the above	

____	11.	When designing a database, the first step is to _____.
a.	determine the primary key.	
b.	identify the tables.	
c.	determine data types	
d.	none of the above	

____	12.	The most common type of relationship between tables is the _____.
a.	one-to-one relationship	
b.	many-to-one relationshiop	
c.	one-to-many relationshiop	
d.	none of the above	

____	13.	If you only want the last names beginning with the letter S to be shown, one would use this expresson _____.
a.	S*	
b.	S?	
c.	S!	
d.	none of the above	

____	14.	All of the following are ways to view forms in Access EXCEPT _____.
a.	Form view	
b.	Layout view	
c.	Design view	
d.	Edit view	

Access Unit 1 Exam
Answer Section

TRUE/FALSE

	1.	ANS:	F

	2.	ANS:	T

	3.	ANS:	F

	4.	ANS:	F

	5.	ANS:	T

MULTIPLE CHOICE

	6.	ANS:	C

	7.	ANS:	A

	8.	ANS:	B

	9.	ANS:	D

	10.	ANS:	C

	11.	ANS:	B

	12.	ANS:	C

	13.	ANS:	A

	14.	ANS:	D