Deck 2: Getting Started With Chapter Access 2013

Question 1

Which is NOT true about Access?

A) It can be used to create forms
B) It relates lists of information in a relational database.
C) Reporting is limited to 20 saved reports.
D) Multiple users can simultaneously enter and update data within Access.

Answer 1

C

Question 2

More than one person can be entering, updating, and using an Access database at the same time.

Answer 2

True

Question 3

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

Answer 3

True

Question 4

Pressing [Ctrl][;] will insert the current date in a Date field.

Question 5

Press [Esc] once to undo a change to the current field.

Question 6

Tables, queries, and forms are examples of Access ____.

A) entities
B) objects
C) values
D) controls

Question 7

Values in an AutoNumber field are automatically created by Access.

Question 8

"Focus" refers to which data you would edit if you started typing.

Question 9

Which Access object provides an easy-to-use data entry screen?

A) macro
B) form
C) table
D) module

Question 10

Microsoft Access can best be described as ____ software.

A) spreadsheet
B) presentation
C) database
D) systems

Question 11

Field properties change depending on the data type of the field.

Question 12

No two records can have the same value in the primary key field.

Question 13

A primary key field uniquely identifies each record.

Question 14

Which of the following is NOT available to you as you start Access?

A) opening an existing database
B) recalibrating an existing database
C) creating a new database from a template
D) creating a new blank database

Question 15

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Question 16

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Question 17

The navigation buttons on a datasheet display the total number of fields in the datasheet.

Question 18

An Access database is limited to a size of 1 gigabyte.

Question 19

The [F2] key switches between Edit and Navigation modes.

Question 20

Tables contain all of the data in the database.

Question 21

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

A) Edit mode
B) Navigation mode
C) Update mode
D) Form mode

Question 22

Which data type is used for sequential integers controlled by Access?

A) Hyperlink
B) Web
C) Lookup Wizard
D) AutoNumber

Question 23

Which two properties are required for every field?

A) Field Name and Data Type
B) Field Name and Field Size
C) Data Type and Format
D) Field Size and Format

Question 24

Which data type stores Web addresses?

A) Lookup Wizard
B) Hyperlink
C) URL
D) HTML

Question 25

In the accompanying figure, Customers is a ____ tab.

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

Question 26

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

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

Question 27

In the accompanying figure, CustomerRoster is a ____ tab.

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

Question 28

Which shortcut key moves focus to the previous field of the current record?

A) [Home]
B) [Shift][Tab]
C) [Up Arrow]
D) [F5]

Question 29

Which data type stores only one of two values?

A) Attachment
B) Hyperlink
C) Yes/No
D) Null

Question 30

Which is NOT a feature of Access reports?

A) headers
B) footers
C) calculations on groups of records
D) easy-to-use data entry screen

Question 31

Which Access object contains all of the raw data within the database?

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

Question 32

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

A) record
B) table
C) database
D) object

Question 33

____ View provides the most options for defining fields.

A) Table Design
B) Table Creation
C) Field Definition
D) Definition

Question 34

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

A) object
B) record
C) field
D) table

Question 35

Which of the following is NOT a data type?

A) Number
B) Formula
C) Date/Time
D) Short Text

Question 36

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

A) Hierarchical
B) Network
C) Schematic
D) Referential

Question 37

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

A) [End]
B) [Page Down]
C) [Down Arrow]
D) [Enter]

Question 38

Which data type links files created in other programs such as pictures or documents?

A) Lookup
B) Attachment
C) Yes/No
D) Link Wizard

Question 39

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

A) Pinned space
B) Navigation Pane
C) Objects Bar
D) Objects Tab

Question 40

In the accompanying figure, the leftmost TourSales is a ____ tab.

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

Question 41

What are the advantages of using Access for database management?

Question 42

A(n) ____________________ key field contains unique data for each record.

Question 43

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Question 44

____________________ View is a spreadsheet-like view of the data in a table.

Question 45

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

Question 46

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

A) FILE
B) VIEW
C) PREVIEW
D) REPORT

Question 47

Which shortcut key moves focus to the first field of the current record?

A) [Home]
B) [End]
C) [F4]
D) [F5]

Question 48

The ____________________ refers to which data you would edit if you started typing.

Question 49

A(n) ____________________ object provides an easy-to-use data entry screen.

Question 50

Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales.

Question 51

A(n) ____________________ field automatically assigns a new number each time you add a record.

Question 52

While editing a record, pressing [Esc] a second time ____.

A) deletes the current field
B) deletes the current datasheet
C) removes all data from the current record
D) removes all changes made to the record you are currently editing

Question 53

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

Question 54

Which keystroke combination moves focus to the last field of the last record?

A) [Alt][Ctrl][Up Arrow]
B) [Ctrl][Up Arrow]
C) [Ctrl][End]
D) [Ctrl][Page Up]

Question 55

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

Question 56

Which editing keystroke deletes one character to the right of the insertion point?

A) [Backspace]
B) [Delete]
C) [F2]
D) [F7]

Question 57

Which of the following keys will help you delete unwanted data in Edit mode?

A) [Insert]
B) [Home]
C) [Ctrl]
D) [Backspace]

Question 58

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Question 59

In Access, data entry screens are called forms. _________________________

Question 60

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables. _________________________

Question 61

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode. _________________________

Question 62

Match the shortcut keystrokes to the correct action.
a.[Left Arrow]
e.[Home]
b.[Tab]
f.[End]
c.[Up Arrow]
g.[Down Arrow]
d.[Ctrl][End]
h.[Ctrl][Home]
Previous field of the current record

Question 63

Match the shortcut keystrokes to the correct action.
a.[Left Arrow]
e.[Home]
b.[Tab]
f.[End]
c.[Up Arrow]
g.[Down Arrow]
d.[Ctrl][End]
h.[Ctrl][Home]
Last field of the current record

Question 64

Case 1-1
Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. Her crew manager will also be using the system.
Hannah is considering whether to use Excel or Access. Which one of the following is NOT a benefit of using Access?

A) More data storage
B) Multiuser capability
C) Easier setup
D) Additional reporting features

Question 65

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator. _________________________

Question 66

Match the shortcut keystrokes to the correct action.
a.[Left Arrow]
e.[Home]
b.[Tab]
f.[End]
c.[Up Arrow]
g.[Down Arrow]
d.[Ctrl][End]
h.[Ctrl][Home]
First field of the first record

Question 67

Case 1-2
Lauren wants to create an Access database of the musical instruments she owns.
Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

A) Paragraph
B) Comment
C) Long Text
D) System

Question 68

Match the shortcut keystrokes to the correct action.
a.[Left Arrow]
e.[Home]
b.[Tab]
f.[End]
c.[Up Arrow]
g.[Down Arrow]
d.[Ctrl][End]
h.[Ctrl][Home]
Last field of the last record

Question 69

The navigation buttons are found at the top of the datasheet. _________________________

Question 70

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

Question 71

Case 1-2
Lauren wants to create an Access database of the musical instruments she owns.
A Purchase Price field should be which data type?

A) Text
B) Number
C) Monetary
D) Currency

Question 72

Match the shortcut keystrokes to the correct action.
a.[Left Arrow]
e.[Home]
b.[Tab]
f.[End]
c.[Up Arrow]
g.[Down Arrow]
d.[Ctrl][End]
h.[Ctrl][Home]
Next field of the current record

Question 73

Match the shortcut keystrokes to the correct action.
a.[Left Arrow]
e.[Home]
b.[Tab]
f.[End]
c.[Up Arrow]
g.[Down Arrow]
d.[Ctrl][End]
h.[Ctrl][Home]
Current field of the next record

Question 74

Match the shortcut keystrokes to the correct action.
a.[Left Arrow]
e.[Home]
b.[Tab]
f.[End]
c.[Up Arrow]
g.[Down Arrow]
d.[Ctrl][End]
h.[Ctrl][Home]
First field of the current record

Question 75

Match the shortcut keystrokes to the correct action.
a.[Left Arrow]
e.[Home]
b.[Tab]
f.[End]
c.[Up Arrow]
g.[Down Arrow]
d.[Ctrl][End]
h.[Ctrl][Home]
Current field of the previous record