Lesson 23 - Getting Started with Access Essentials

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

____	1.	A relational database organizes information into separate subject-based tables.

____	2.	To allow more space to show the table contents, you can close the Navigation Pane.

____	3.	Each of the objects and everything that you do in a database relies on the data stored in a form.

____	4.	At least one table must be created before any additional objects can be created.

____	5.	A field property is a label that helps identify the field.

____	6.	The primary key is useful in sorting records.

____	7.	In Design view, the table data looks much like a spreadsheet.

____	8.	You can only add fields in Design view.

____	9.	The field properties available depend on the data type selected.

____	10.	When you work in  Design view, the changes are saved as they are made.

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

____	1.	Which of the following is NOT true about databases?
a.	Like spreadsheets, databases are composed of rows and columns.	c.	Access offers more comprehensive functions for manipulating data than Excel.	
b.	Like Word and Excel, Access has a standard document view.	d.	In Access you can import or link data from other Access databases.	

____	2.	All data in a database is stored in a ____.
a.	table	c.	report	
b.	form	d.	query	

____	3.	A ____ makes it easy for you to view, enter, and edit data.
a.	table	c.	report	
b.	form	d.	query	

____	4.	A ____ organizes data in a specific layout.
a.	table	c.	report	
b.	form	d.	query	

____	5.	A ____ finds and shows data that meet a specified criteria.
a.	table	c.	report	
b.	form	d.	query	

____	6.	A(n) ____ is a single piece of database information.
a.	field	c.	datasheet	
b.	record	d.	primary key	

____	7.	When you create a new field,  you can choose a(n) ____, such as text or numbers.
a.	field property	c.	field name	
b.	datasheet	d.	data type	

____	8.	Which of the following is information that would be stored in a field?
a.	A first name	c.	A postal code.	
b.	A phone number.	d.	All of the above could be stored in a field.	

____	9.	A(n) ____ would store all of the information about an individual.
a.	field	c.	datasheet	
b.	record	d.	primary key	

____	10.	To insert a table in a database, click the ____ tab on the Ribbon.
a.	Insert	c.	Create	
b.	Table	d.	File	

____	11.	To move the insertion point to the previous field in Datasheet view, press ____.
a.	Shift+Tab	c.	Enter	
b.	the right arrow	d.	Tab	

____	12.	The above figure shows a table in ____ view.
a.	Normal	c.	Design	
b.	Layout	d.	Datasheet	

____	13.	The default data type for a field is ____.
a.	Number	c.	Currency	
b.	Text	d.	Yes/No	

[Figure 23-14]

____	14.	In the above figure, the button immediately to the left of the No Filter button is the ____ button.
a.	New (blank) record	c.	Next record	
b.	Last record	d.	First record	

____	15.	Which of the following is NOT true about deleting and copying records and fields in Datasheet view?
a.	The Cut, Copy, and Paste commands are available in Access.	c.	To remove a table field and all the data for the field, you delete the column.	
b.	You can use the Undo command to delete a record.	d.	You can rearrange the sequence of the columns.	

____	16.	In Datasheet view, when a record is being edited, a(n) ____ icon appears to the left edge of the row.
a.	star	c.	pencil	
b.	key	d.	arrow	

Pilar is creating a new database for her business.

____	17.	Pilar wants to store information about customers’ orders, as well as product details of her inventory. She should create separate ____ for each.
a.	tables	c.	records	
b.	fields	d.	databases	

____	18.	Pilar uses a unique product number for each product in her inventory. She makes the product number ____.
a.	a table	c.	a database	
b.	the primary key	d.	a record	

C.J. wants to modify a table in his database.

____	19.	C.J. wants to easily edit the field properties in his table. He should work in ____ view.
a.	Table	c.	Design	
b.	Normal	d.	Datasheet	

____	20.	C.J. wants to change the default Field Size property for a field with the Text data type from ____ characters to 50.
a.	8	c.	100	
b.	55	d.	255	

Lesson 23 - Getting Started with Access Essentials
Answer Section

TRUE/FALSE

	1.	ANS:	T	PTS:	1	REF:	Mod 2-402

	2.	ANS:	T	PTS:	1	REF:	Mod 2-403

	3.	ANS:	F	PTS:	1	REF:	Mod 2-407

	4.	ANS:	T	PTS:	1	REF:	Mod 2-407

	5.	ANS:	F	PTS:	1	REF:	Mod 2-407

	6.	ANS:	T	PTS:	1	REF:	Mod 2-407

	7.	ANS:	F	PTS:	1	REF:	Mod 2-407

	8.	ANS:	F	PTS:	1	REF:	Mod 2-412

	9.	ANS:	T	PTS:	1	REF:	Mod 2-415

	10.	ANS:	F	PTS:	1	REF:	Mod 2-417

MULTIPLE CHOICE

	1.	ANS:	B	PTS:	1	REF:	Mod 2-402

	2.	ANS:	A	PTS:	1	REF:	Mod 2-403

	3.	ANS:	B	PTS:	1	REF:	Mod 2-403

	4.	ANS:	C	PTS:	1	REF:	Mod 2-403

	5.	ANS:	D	PTS:	1	REF:	Mod 2-403

	6.	ANS:	A	PTS:	1	REF:	Mod 2-407

	7.	ANS:	D	PTS:	1	REF:	Mod 2-407

	8.	ANS:	D	PTS:	1	REF:	Mod 2-407

	9.	ANS:	B	PTS:	1	REF:	Mod 2-407

	10.	ANS:	C	PTS:	1	REF:	Mod 2-409

	11.	ANS:	A	PTS:	1	REF:	Mod 2-411

	12.	ANS:	C	PTS:	1	REF:	Mod 2-414

	13.	ANS:	B	PTS:	1	REF:	Mod 2-415

	14.	ANS:	A	PTS:	1	REF:	Mod 2-418

	15.	ANS:	B	PTS:	1	REF:	Mod 2-419

	16.	ANS:	C	PTS:	1	REF:	Mod 2-418

	17.	ANS:	A	PTS:	1	REF:	Mod 2-402	TOP:	Critical Thinking

	18.	ANS:	B	PTS:	1	REF:	Mod 2-407	TOP:	Critical Thinking

	19.	ANS:	C	PTS:	1	REF:	Mod 2-414	TOP:	Critical Thinking

	20.	ANS:	D	PTS:	1	REF:	Mod 2-415	TOP:	Critical Thinking