[03] Lesson 3 Exam

__________ view is the Access view that displays data organized in columns and rows similar to an Excel worksheet.

Question 1 options:

	a) Datasheet
	b) Datatype
	c) Layout
	d) Design

Question 2 (5 points)

You can print a table from the File tab by clicking:

Question 2 options:

	a) Print.
	b) Print Table.
	c) Enter.
	d) Select Table.

Question 3 (5 points)

In Microsoft Access 2016, you can create a complete ____________ from a template as provided, or that you can modify to meet your needs.

Question 3 options:

	a) database
	b) worksheet
	c) table
	d) report

Question 4 (5 points)

On the Create tab, in the Tables group, clicking ___________ allows you to create a new table.

Question 4 options:

	a) Table
	b) New Table
	c) Create Table
	d) Tables and Related Views

Question 5 (5 points)

When printing a table, use the Print Preview command to determine if the table will print on one page or if you need to adjust any of the following EXCEPT:

Question 5 options:

	a) column widths.
	b) row lengths.
	c) margins.
	d) page orientation.

Question 6 (5 points)

In __________________view, the primary key field is identified by the selection of the Unique check box.

Question 6 options:

	a) Datatype
	b) Datasheet
	c) Layout
	d) Table

Question 7 (5 points)

A new table can be added to a database using:

Question 7 options:

	a) the table tool.
	b) New Table.
	c) Create Table.
	d) Tables and Related Views.

Question 8 (5 points)

The ___________view enables you to make changes to an object, such as a report.

Question 8 options:

	a) Related
	b) Datasheet
	c) Datatype
	d) Layout

Question 9 (5 points)

The ____________data type describes numbers that represent a quantity and may be used in calculations.

Question 9 options:

	a) AutoNumber
	b) Number
	c) Calculated
	d) Numerical

Question 10 (5 points)

In the Print dialog box, under____________, clicking the Selected Record(s) option button allows you to print a single record.

Question 10 options:

	a) Select
	b) Print Record
	c) Print Range
	d) Capture

Question 11 (5 points)

When a table is__________, the table name and page number display automatically.

Question 11 options:

	a) created
	b) modified
	c) copied
	d) printed

Question 12 (5 points)

In the Design View, data does not display; instead the information about each of the following EXCEPT __________ display.

Question 12 options:

	a) field’s characteristics
	b) field properties
	c) description
	d) data type

Question 13 (5 points)

The External Data tab allows you to import a/an ________________ to create a new table.

Question 13 options:

	a) Excel spreadsheet
	b) Word document
	c) PDF file
	d) text file

Question 14 (5 points)

You can enter data in a newly created table using the ____________ view.

Question 14 options:

	a) Datasheet
	b) Datatype
	c) Layout
	d) Table

Question 15 (5 points)

You must be in _____________view to enter, view, edit, or delete a record.

Question 15 options:

	a) Form
	b) Design
	c) Records
	d) Display

Question 16 (5 points)

The Navigation pane groups and displays database ___________in a predefined arrangement.

Question 16 options:

	a) fields
	b) tables
	c) information
	d) objects

Question 17 (5 points)

For Access, you can export a database object to all the following EXCEPT:

Question 17 options:

	a) an Excel worksheet.
	b) a Word document.
	c) a PDF file.
	d) a text file.

Question 18 (5 points)

One purpose of a _________is to simplify data entry.

Question 18 options:

	a) database
	b) template
	c) table
	d) form

Question 19 (5 points)

_____________ is a form that enables you to display or enter multiple records in a table.

Question 19 options:

	a) Multiple-items form
	b) Multiple-records form
	c) Multiple-entry form
	d) Multiple-fields form

Question 20 (5 points)

The ___________ area indicates the number of records in the table and has controls in the form of arrows that you click to move through the records.

Question 20 options:

	a) navigation
	b) design
	c) display
	d) datasheet