Student Center | Instructor Center | Information Center | Home

Office XP Access 2002, 2/e

Timothy O'Leary, Arizona State University

Controlling Data Input, Using Advanced Queries, and Enforcing Referential Integrity

Multiple Choice Quiz

Click on the correct response for each question below.


1	This identifies a record in Access in the same way a license plate number identifies a car.
		A)	Key attribute
		B)	Property attribute
		C)	Primary key
		D)	Object key


2	To create this, you enter an expression in the design grid that instructs Access to perform a calculation using the current field values.
		A)	Formulated field
		B)	Numeric field
		C)	Formula field
		D)	Calculated field


3	When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from A-Z.
		A)	?
		B)	!
		C)	#
		D)	\


4	In Access, this displays the results of a calculation in a query.
		A)	Lookup field
		B)	Calculated field
		C)	Source field
		D)	Child field


5	In Access, a lookup field that uses another table as the source for values is called a lookup list
		A)	reference list.
		B)	lookup list.
		C)	relationship.
		D)	calculated field.


6	In Access, this operation copies a backup file from the storage medium back onto the computer’s hard drive.
		A)	Recreate
		B)	Restore
		C)	Copy
		D)	Structure


7	If you make an invalid entry in the Input Mask Wizard dialog box, this will display to advise you that the entry is not correct.
		A)	Text error
		B)	Validation error
		C)	Entry error
		D)	Literal error


8	If you choose to enter data directly into a table in the Table Wizard, the table will be opened in this view.
		A)	Edit
		B)	Content
		C)	Normal
		D)	Design


9	In the many-to-many relationship, this table is used to hold the primary key fields from the other two tables and serves as a bridge between them.
		A)	Master
		B)	Primary
		C)	Span
		D)	Junction


10	In Access, the Location and Position table is redisplayed with this at the beginning of each row.
		A)	Expand indicators
		B)	Expand delimiters
		C)	Expand functions
		D)	Expand keys


11	This is not one of the names of sample tables in the Business category of the Table Wizard dialog box.
		A)	Contacts
		B)	Products
		C)	Guests
		D)	Employees

2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.