Deck 23: Getting Started With Access Essentials

Question 1

The report object simplifies the process of viewing, entering, and editing table data.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

A datasheet is the primary object in a database.

Question 5

All data in a database is stored in a ____.

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

Question 6

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

Question 7

By default, a table opens in Datasheet view. ____________________

Question 8

The primary key is useful in sorting records.

Question 9

The field properties available depend on the data type selected.

Question 10

A ____ organizes data in a specific layout.

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

Question 11

In a datasheet, fields are displayed as rows . ____________________

Question 12

Which of the following is NOT true about databases?

A) Like spreadsheets, databases are composed of rows and columns.
B) Like Word and Excel, Access has a standard document view.
C) Access offers more comprehensive functions for manipulating data than Excel.
D) In Access, you can import or link data from other Access databases.

Question 13

Both Datasheet view and Design view let you add new fields.

Question 14

A ____ finds and shows data that meets specified criteria.

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

Question 15

In Access, data can be imported or linked from Outlook.

Question 16

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

Question 17

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

Question 18

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

Question 19

In Access, multiple databases can be opened at the same time.

Question 20

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

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

Question 21

Access is a(n) ____________________ database management system.

Question 22

The default name for a new table is ______.

A) AccessTable
B) NewTable
C) TableNew
D) Table1

Question 23

Pilar is creating a new database for her business. Pilar uses a unique product number for each product in her inventory. She makes the product number ____.

A) a table
B) the primary key
C) a database
D) a record

Question 24

The ____________________ key prevents duplicate entries.

Question 25

The default data type for a field is ____.

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

Question 26

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

Question 27

What is a database? Name a sample use for a database and two tables that database might contain. Name one similarity and one difference between Access and Excel. What is a relational database and how is it used?

Question 28

By default, a table opens in _____ view.

A) Secure
B) Design
C) Datasheet
D) Property

Question 29

A ____ is a single piece of database information.

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

Question 30

Field ____________________ define the characteristics and behavior of a field.

Question 31

C.J. wants to modify a table in his database. C.J. wants to easily edit the field properties in his table. He should work in ____ view.

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

Question 32

Access is the Microsoft Office ____________________ application.

Question 33

C.J. wants to modify a table in his database. C.J. wants to change the default Field Size property for a field with the Text data type from ____ characters to 50.

A) 8
B) 55
C) 100
D) 255

Question 34

Pilar is creating a new database for her business. Pilar wants to store information about customers' orders, as well as product details of her inventory. She should create separate ____ for each.

A) tables
B) fields
C) records
D) databases

Question 35

To move the insertion point to the previous field in Datasheet view, press ____.

A) Shift+Tab
B) the right arrow
C) Enter
D) Tab

Question 36

The _____ property in Access specifies how numbers, dates, times, and text are displayed.

A) Field
B) Layout
C) Format
D) Primary key

Question 37

In Datasheet view, when a record is being edited, a(n) ____ icon appears to the left edge of the row.

A) star
B) key
C) pencil
D) arrow

Question 38

A ____ would store all of the information about an individual.

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

Question 39

When you create a new field, you can choose a ____, such as text or numbers.

A) field property
B) datasheet
C) field name
D) data type

Question 40

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.
B) You can use the Undo command to delete a record.
C) To remove a table field and all the data for the field, you delete the column.
D) You can rearrange the sequence of the columns.

Question 42

To remove a field from a table along with its content, you must delete its _____.

A) column
B) record
C) data type
D) contacts