Deck 22: Getting Started With Access Essentials

Question 1

Access is a database program.

Answer 1

True

Question 2

Datasheet view shows details about the structure of the object, including the data type and the field properties.

Answer 2

False

Question 3

A ____ is an object that stores data in columns and rows.

A) table
B) form
C) report
D) query

Answer 3

A

Question 4

You cannot use the Save As command to name and save objects in the database.

Question 5

The Access screen is similar to other Office 2007 applications.

Question 6

The default Field Size property for the Text data type is 50 characters.

Question 7

When you create a new database, the first step is to name the database file.

Question 8

The ____ is useful in sorting records, and it prevents duplicate entries.

A) primary key
B) field name
C) datasheet
D) field

Question 9

A ____ finds and shows data that meet a specified criteria.

A) table
B) form
C) report
D) query

Question 10

You can only add fields in Design view.

Question 11

You can create as many tables as you need to store the information for a database.

Question 12

You can open multiple databases at a time in an Access window.

Question 13

A query is an object that organizes data in a specific layout.

Question 14

Once you have deleted a record, you can use the Undo command to restore it.

Question 15

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

Question 16

Objects are organized into categories in the Navigation Pane.

Question 17

You can use the Save As command to save the entire database under a new name.

Question 18

A ____ makes it easy for you to view, enter, and edit data in a table.

A) table
B) form
C) report
D) query

Question 19

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

A) Design
B) Datasheet
C) Field
D) Print

Question 20

Unlike Word and Excel, Access does not have a standard document view.

Question 21

____ is software that can be accessed for free.

A) Software piracy
B) Shareware
C) The honor system
D) Intellectual property

Question 22

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

A) Design
B) Form
C) Datasheet
D) Report

Question 23

Case 22-2 Jamir works for a distribution company and has taken over responsibility of the customer database. He has several changes to make to it in order to update the information. To remove a table field and all the data for the field, Jamir should delete the ____.

A) column
B) record
C) field name
D) entry

Question 24

A table is often referred to as a(n) ____________________.

Question 25

FIGURE 22-1 What is the arrow pointing to in Figure 22-1 above?

A) Status bar
B) Vertical scroll box
C) Restore Down button
D) Shutter Bar Open/Close button

Question 26

Case 22-1 Dana has just been hired to create and maintain a database for a local sports organization. The organization has several different sports with many teams and divisions. She is creating the database in Design view. If Dana doesn't save the table in Design view and switches to Datasheet view, what will happen?

A) She will lose all the data in the table.
B) She will be prompted to save the table.
C) Nothing. Access saves automatically in Design view.
D) The database will be closed and all data will be lost.

Question 27

____ define the characteristics and behavior of a field, such as the number of characters allowed.

A) Data types
B) Primary keys
C) Entries
D) Field properties

Question 28

Access stores cut or copied text in the ____.

A) Navigation Pane
B) Clipboard
C) field
D) entry

Question 29

The ____ key moves the insertion point to the first field in the current record.

A) Home
B) End
C) Up arrow
D) Down arrow

Question 30

The Next record button is located in the ____.

A) Navigation pane
B) Navigation bar
C) Ribbon
D) Status bar

Question 31

The Blank Database button is located in the ____.

A) Home tab on the Ribbon
B) Create tab on the Ribbon
C) Navigation pane
D) Getting Started with Microsoft Office Access window

Question 32

Case 22-1 Dana has just been hired to create and maintain a database for a local sports organization. The organization has several different sports with many teams and divisions. She is creating the database in Design view. What setting will allow Dana to change the number of characters allowed in a field?

A) Primary key
B) Field name
C) Field properties
D) Data type

Question 33

The ____ key moves the insertion point to the next field.

A) Home
B) End
C) Tab
D) Up arrow

Question 34

Fields appear as columns, and each column has a ____.

A) datasheet
B) record
C) field name
D) primary key

Question 35

Case 22-2 Jamir works for a distribution company and has taken over responsibility of the customer database. He has several changes to make to it in order to update the information. Jamir needs to delete a record. He needs to select it and press ____ to remove the data.

A) Undo
B) Redo
C) the Delete key
D) the Enter key

Question 36

____ is the shortcut for creating a new blank database.

A) Ctrl+D
B) Ctrl+N
C) Ctrl+B
D) Ctrl+A

Question 37

The ____ determines what type of data the field can store, such as text or numbers.

A) record
B) field name
C) data type
D) field properties

Question 38

The default data type for a field is ____.

A) Number
B) Text
C) Currency
D) Yes/No

Question 39

____ is the illegal copying or use of programs.

A) Intellectual property
B) The Copyright Act
C) Shareware
D) Software piracy

Question 40

FIGURE 22-2 Which view is displayed in Figure 22-2 above?

A) Datasheet
B) Format
C) Table
D) Design

Question 41

A(n) ____________________ is a collection of related information.

Question 42

If you make a mistake adding or editing data in a record, you can choose the ____________________ command to reverse your last action.

Question 44

What is the difference between a spreadsheet and a database? Give an example of when you would use each and explain why. Explain a relational database management system.

Question 45

The intersection of a row and a column is called a(n) ____________________, just as in an Excel worksheet.

Question 46

When you enter data into a cell, it is called a(n) ____________________.