Deck 11: Access 2007 Unit A: Getting Started With Access 2007

Question 1

You can move datasheet columns by dragging the field name left or right.

Answer 1

True

Question 2

Pressing [Ctrl][;] will insert the current date.

Answer 2

True

Question 3

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

Answer 3

C

Question 4

The [Esc] key will only affect the current field being edited.

Question 5

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

Question 6

Which of the following is NOT a way to open Access?

A) From the Start menu
B) From Internet Explorer
C) From My Computer
D) From a shortcut on the desktop

Question 7

Microsoft Office Access can best be described as ____ software.

A) Spreadsheet
B) Presentation
C) Database
D) Systems

Question 8

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 9

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

Question 10

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

A) Entities
B) Objects
C) Values
D) Controls

Question 11

Values in an AutoNumber field cannot be edited.

Question 12

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

Question 13

Tables contain all of the data in the database.

Question 14

Which is NOT a feature of Access reports?

A) Multiple headers
B) Multiple footers
C) Calculations on groups of records
D) The ability to enter data through a data entry screen

Question 15

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

Question 16

An Access database may be as large as 200 gigabytes.

Question 17

Field names appear in the top row of a datasheet.

Question 18

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

Question 19

A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

A) Table
B) Control
C) Element
D) Object

Question 20

Which is NOT true about Access?

A) It can be used to arrange data in a variety of ways.
B) It allows links between lists of information.
C) It is able to store any number of records up to 20 gigabytes.
D) Multiple users can simultaneously enter and update data within Access.

Question 21

Which data type is used to sequentially order each record added to a table?

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

Question 22

The term ____ database comes from the fact that two or more tables are linked by a common field.

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

Question 23

Press this keystroke combination to move 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 24

Item 5 in the figure above is:

A) Where a new record would be entered
B) Where a new field would be entered
C) A field name
D) The navigation pane

Question 25

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 26

Which data type stores only one of two values?

A) OLE object
B) Hyperlink
C) Yes/No
D) Null

Question 27

This Access object contains all of the raw data within the database.

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

Question 28

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 29

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

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

Question 30

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

A) Lookup
B) OLE object
C) Yes/No
D) Link Wizard

Question 31

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

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

Question 32

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

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

Question 33

Which of the following is not a Data Type?

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

Question 34

Which data type stores Web addresses?

A) Lookup Wizard
B) Hyperlink
C) www address
D) HTML

Question 35

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

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

Question 36

A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.

A) Database
B) Field
C) Record
D) Object

Question 37

Item 8 in the figure above is:

A) The date/time
B) A record
C) A field name
D) The focus

Question 38

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

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

Question 39

This Access object provides an easy-to-use data entry screen.

A) Macro
B) Form
C) Table
D) Module

Question 40

Item 7 in the figure above is the:

A) Record selector box
B) Navigation bar
C) Navigation pane
D) Focus

Question 41

The ____________________ View is used to modify and define field properties that are not available in Datasheet View.

Question 42

In Access, data entry screens are called forms .

Question 43

When creating a database using an Access template, you must remember that field names cannot be altered later .

Question 44

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

Question 45

Matt wants to create a record keeping system to track the inventory needed to efficiently run his lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. His crew manager will also be using the system. Matt 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. Better charting features
D. More reporting features

Question 46

You cannot undo a record deletion operation.

Question 47

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

Question 48

In the figure above, template 8 is an example of:

A) Tasks
B) Events
C) Issues
D) Assets

Question 49

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

Question 50

When you move around the fields and records of a datasheet but do not change data, you are working in ____________________ mode.

Question 51

An Access database is called a(n) ____________________ database because more than one table can share information through a common linked field.

Question 52

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

Question 53

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

Question 54

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

Question 55

The navigation bar is found at the top of the datasheet.

Question 56

The Database window displays the Tables, Queries, Forms, and Reports. Describe what these four objects represent.

Question 57

What are the advantages of database software such as Access over spreadsheet software such as Excel?

Question 58

A(n) ____________________ is a spreadsheet-like grid that displays a table's fields and records.

Question 59

An Access database is able to store any number of records up to ____________________ gigabytes.

Question 60

In the figure above, template 5 represents an example of:

A) Sales pipeline
B) Marketing projects
C) Events
D) Tasks

Question 62

Jeff wants to create an Access database of the musical instruments he owns. A Purchase Price field should be which data type?
A. Text
B. Number
C. Monetary
D. Currency

Question 63

Jeff wants to create an Access database of the musical instruments he owns. He has written a paragraph about each instrument's tonal quality. Which data type should he use to define the field that will store this information?
A. Text
B. Date/Time
C. Memo
D. Number