Deck 1: Access Lesson 1: Understanding Access Fundamentals

Question 1

Each field in a datasheet is displayed as a row and is identified by its field value at the top.

Answer 1

False

Question 2

Access does not organize commands on Ribbon tabs like other Office programs.

Answer 2

False

Question 3

Every table in a database will have a primary key.

Answer 3

True

Question 4

The icon that you click to create a new blank database is located ____.

A) on the Ribbon
B) in the Navigation Pane
C) in Backstage view
D) on the record navigation bar

Question 5

Access will automatically assign a data type based on the values that you enter in a field.

Question 6

When you start Access, Backstage view is displayed.

Question 7

The key value is the field that uniquely identifies each record.

Question 8

Access automatically saves data as you enter it in a table.

Question 9

Multiple database objects can be open at one time.

Question 10

Before closing a database, all database objects must be saved and closed.

Question 11

A ____ is a single characteristic or piece of information stored in a database table.

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

Question 12

The ____ on the left side of the Access program window lists all of the objects in the database.

A) File tab
B) Blank Database pane
C) Navigation Pane
D) Ribbon

Question 13

The Text data type stores text and/or numbers up to 65,535 characters.

Question 14

You can change the structure of an Access table by inserting blank rows or columns.

Question 15

A ____ is all of the related information about a particular item in a database table.

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

Question 16

Fields are the place in a database where all the data is stored.

Question 17

To select all records in the database, you can click the datasheet selector box in the upper-left corner of the datasheet.

Question 18

The Search box at the top of the Open dialog box shows the folder path.

Question 19

By default, Access creates an ID field in every table that can serve as the ____.

A) key value
B) field name
C) foreign key
D) primary key

Question 20

When you open an existing database, a security warning may be displayed in the Message Bar below the Ribbon.

Question 21

You can change the field name by clicking the Name & Caption button in the Properties group on the ____ tab and then typing a new field name.

A) Home
B) Create
C) Database Tools
D) Table Tools Fields

Question 22

How can you rearrange the order of fields in Datasheet view?

A) Right-click the field and then click Rearrange.
B) Click the Order button on the Datasheet tab.
C) Select a field and drag it to a new position.
D) You cannot rearrange the order of fields.

Question 23

You can set the ____ field property when you want to make sure that a certain field is required to contain a value in every record.

A) Required
B) Unique
C) Data Type
D) Format

Question 24

Case AC 1-2 Sheila's company has just made revisions to the benefits package. Sheila needs to make some changes to the database containing employee information. When renaming a table in the database, Sheila must be sure ____.

A) to use a one-word name
B) to close the table first
C) that the table is displayed in the Access program window
D) that the table is displayed in Design view

Question 25

By default, tables in a a database are displayed in a format called a(n) ____________________.

Question 26

The keyboard shortcut ____ + O will display the Open dialog box.

A) Ctrl
B) Shift
C) Alt
D) Tab

Question 27

Case AC 1-1 On the company intranet, Carlos has access to a database containing product specifications and frequently uses it when preparing information packets for clients. Which database object would Carlos use to summarize and present information in a readable format that can be printed?

A) Table
B) Form
C) Report
D) Query

Question 28

FIGURE AC 1-1 What does the pencil icon in Figure AC 1-1 indicate?

A) A new blank record.
B) The record has been saved.
C) The record is being edited.
D) The record contains a primary key.

Question 29

To rename a table, you can ____ the table name in the Navigation Pane and then click Rename on the shortcut menu.

A) select
B) click
C) double-click
D) right-click

Question 30

When you ____ a record, a message will be displayed asking you to confirm the action.

A) edit
B) delete
C) save
D) enter

Question 31

When you create a new database, a new table is automatically created and displayed in ____ view.

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

Question 32

Case AC 1-1 On the company intranet, Carlos has access to a database containing product specifications and frequently uses it when preparing information packets for clients. Which database object would Carlos use to ask a question about data stored in the database?

A) Table
B) Form
C) Report
D) Query

Question 33

The Attachment data type is used ____.

A) when only two values can be chosen
B) often as a primary key field
C) to store links such as Web addresses
D) to store supported file types such as images, documents, and charts

Question 34

Case AC 1-2 Sheila's company has just made revisions to the benefits package. Sheila needs to make some changes to the database containing employee information. To select a single record, Sheila would click the record selector box ___.

A) at the top of the column
B) to the left of the row
C) in the upper-left corner of the datasheet
D) in the Navigation Pane

Question 35

In Datasheet view, you can navigate among the records in a table using the navigation buttons on the ____.

A) record navigation bar
B) Navigation Pane
C) title bar
D) status bar

Question 36

To close a database, you can click the ____ and then click Close Database.

A) Navigation Pane
B) File tab
C) Object tab
D) Start button

Question 37

You can assign a data type when creating a field by clicking the ____ column header and selecting the data type from the menu.

A) Data Type
B) Add Field
C) Click to Add
D) Assign Value

Question 38

FIGURE AC 1-1 What does the asterisk in Figure AC 1-1 indicate?

A) A new blank record.
B) The record has been saved.
C) The record is being edited.
D) The record contains a primary key.

Question 39

When Access creates an ID field, it is assigned the ____ data type.

A) Memo
B) Number
C) AutoNumber
D) Text

Question 40

To close Access, click ____ on the File tab.

A) Close
B) Done
C) Exit
D) Finish

Question 42

____________________ control the appearance and behavior of a field.

Question 43

How is storing information in a database similar to using a filing cabinet? Be specific in your comparison. What would be the advantage to using an electronic database management system instead of a manual system like a filing cabinet?

Question 44

You can display Backstage view to create a new database using a template, create a new blank database, or open a recently used database by clicking the ____________________ tab.

Question 45

Each field in a table has a(n) ____________________ that determines the types of field values you can enter in that field.

Question 46

When a primary key is included in another table, it is called a(n) ____________________ in the second table.