Deck 1: Access Lesson 1: Understanding Access Fundamentals
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Match between columns
Question
Question
Question
Question
Question
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/46
Play
Full screen (f)
Deck 1: Access Lesson 1: Understanding Access Fundamentals
1
Each field in a datasheet is displayed as a row and is identified by its field value at the top.
False
2
Access does not organize commands on Ribbon tabs like other Office programs.
False
3
Every table in a database will have a primary key.
True
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
A) on the Ribbon
B) in the Navigation Pane
C) in Backstage view
D) on the record navigation bar
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
5
Access will automatically assign a data type based on the values that you enter in a field.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
6
When you start Access, Backstage view is displayed.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
7
The key value is the field that uniquely identifies each record.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
8
Access automatically saves data as you enter it in a table.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
9
Multiple database objects can be open at one time.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
10
Before closing a database, all database objects must be saved and closed.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) record
B) field
C) primary key
D) field value
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) File tab
B) Blank Database pane
C) Navigation Pane
D) Ribbon
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
13
The Text data type stores text and/or numbers up to 65,535 characters.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
14
You can change the structure of an Access table by inserting blank rows or columns.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) record
B) field
C) primary key
D) field value
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
16
Fields are the place in a database where all the data is stored.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
17
To select all records in the database, you can click the datasheet selector box in the upper-left corner of the datasheet.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
18
The Search box at the top of the Open dialog box shows the folder path.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) key value
B) field name
C) foreign key
D) primary key
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
20
When you open an existing database, a security warning may be displayed in the Message Bar below the Ribbon.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) Home
B) Create
C) Database Tools
D) Table Tools Fields
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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.
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.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) Required
B) Unique
C) Data Type
D) Format
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
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
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
25
By default, tables in a a database are displayed in a format called a(n) ____________________.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
26
The keyboard shortcut ____ + O will display the Open dialog box.
A) Ctrl
B) Shift
C) Alt
D) Tab
A) Ctrl
B) Shift
C) Alt
D) Tab
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) Table
B) Form
C) Report
D) Query
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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.

A) A new blank record.
B) The record has been saved.
C) The record is being edited.
D) The record contains a primary key.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) select
B) click
C) double-click
D) right-click
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
30
When you ____ a record, a message will be displayed asking you to confirm the action.
A) edit
B) delete
C) save
D) enter
A) edit
B) delete
C) save
D) enter
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) Design
B) Datasheet
C) Layout
D) Table
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) Table
B) Form
C) Report
D) Query
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
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
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
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
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) record navigation bar
B) Navigation Pane
C) title bar
D) status bar
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) Navigation Pane
B) File tab
C) Object tab
D) Start button
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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
A) Data Type
B) Add Field
C) Click to Add
D) Assign Value
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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.

A) A new blank record.
B) The record has been saved.
C) The record is being edited.
D) The record contains a primary key.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
39
When Access creates an ID field, it is assigned the ____ data type.
A) Memo
B) Number
C) AutoNumber
D) Text
A) Memo
B) Number
C) AutoNumber
D) Text
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
40
To close Access, click ____ on the File tab.
A) Close
B) Done
C) Exit
D) Finish
A) Close
B) Done
C) Exit
D) Finish
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
41
Match between columns
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
42
____________________ control the appearance and behavior of a field.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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?
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
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.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
45
Each field in a table has a(n) ____________________ that determines the types of field values you can enter in that field.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck
46
When a primary key is included in another table, it is called a(n) ____________________ in the second table.
Unlock Deck
Unlock for access to all 46 flashcards in this deck.
Unlock Deck
k this deck