Access 2007 Unit A: Getting Started with Access 2007
TRUE/FALSE
1. More than one person can be entering, updating, and using an Access database at the same time.
ANS: T PTS: 1 REF: Access 2
2. An Access database may be as large as 200 gigabytes.
ANS: F PTS: 1 REF: Access 3
3. Tables contain all of the data in the database.
ANS: T PTS: 1 REF: Access 4
4. The [F2] key switches between Edit and Navigation modes.
ANS: T PTS: 1 REF: Access 9
5. The Navigation buttons on a datasheet display the total number of fields in the datasheet.
ANS: F PTS: 1 REF: Access 6
6. Field names appear in the top row of a datasheet.
ANS: T PTS: 1 REF: Access 4
7. Values in an AutoNumber field cannot be edited.
ANS: T PTS: 1 REF: Access 13
8. You can move datasheet columns by dragging the field name left or right.
ANS: T PTS: 1 REF: Access 8
9. The [Esc] key will only affect the current field being edited.
ANS: T PTS: 1 REF: Access 9
10. Once you have created and named a field, you cannot resize the width of the field in a datasheet.
ANS: F PTS: 1 REF: Access 8
11. The focus refers to which data you would edit if you started typing.
ANS: T PTS: 1 REF: Access 6
12. Pressing [Ctrl][;] will insert the current date.
ANS: T PTS: 1 REF: Access 9
MULTIPLE CHOICE
1. Microsoft Office Access can best be described as ____ software.
a. / Spreadsheet / c. / Databaseb. / Presentation / d. / Systems
ANS: C PTS: 1 REF: Access 2
2. Which is NOT a feature of Access reports?
a. / Multiple headersb. / Multiple footers
c. / Calculations on groups of records
d. / The ability to enter data through a data entry screen
ANS: D PTS: 1 REF: Access 11
3. 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.
ANS: C PTS: 1 REF: Access 3
4. Which of the following is NOT a way to open Access?
a. / From the Start menu / c. / From My Computerb. / From Internet Explorer / d. / From a shortcut on the desktop
ANS: B PTS: 1 REF: Access 4
5. A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.
a. / Object / c. / Fieldb. / Record / d. / Table
ANS: C PTS: 1 REF: Access 5
6. A group of related fields, such as all the demographic information for one customer, is called a(n) ____.
a. / Record / c. / Databaseb. / Table / d. / Object
ANS: A PTS: 1 REF: Access 5
7. A collection of records for a single subject, such as all of the customer records, is called a(n) ____.
a. / Table / c. / Elementb. / Control / d. / Object
ANS: A PTS: 1 REF: Access 5
8. Tables, queries, and modules are examples of Access ____.
a. / Entities / c. / Valuesb. / Objects / d. / Controls
ANS: B PTS: 1 REF: Access 5
9. The term ____ database comes from the fact that two or more tables are linked by a common field.
a. / Hierarchical / c. / Schematicb. / Network / d. / Relational
ANS: D PTS: 1 REF: Access 5
10. This Access object contains all of the raw data within the database.
a. / Query / c. / Tableb. / Form / d. / Module
ANS: C PTS: 1 REF: Access 11
11. This Access object provides an easy-to-use data entry screen.
a. / Macro / c. / Tableb. / Form / d. / Module
ANS: B PTS: 1 REF: Access 11
12. Which of the following is not a Data Type?
a. / Number / c. / Date/Timeb. / Formula / d. / Text
ANS: B PTS: 1 REF: Access 13
13. A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.
a. / Database / c. / Recordb. / Field / d. / Object
ANS: A PTS: 1 REF: Access 5
14. In Navigation mode, press [Tab] or this keystroke to move to the next field within the same record.
a. / [End] / c. / [Down Arrow]b. / [Page Down] / d. / [Enter]
ANS: D PTS: 1 REF: Access 6
15. Press this keystroke combination to move focus to the last field of the last record.
a. / [Alt][Ctrl][Up Arrow] / c. / [Ctrl][End]b. / [Ctrl][Up Arrow] / d. / [Ctrl][Page Up]
ANS: C PTS: 1 REF: Access 7
16. In a datasheet, which mode assumes that you are trying to change the value of a particular field?
a. / Edit mode / c. / Update modeb. / Navigation mode / d. / Form mode
ANS: A PTS: 1 REF: Access 6
17. Which shortcut key moves focus to the previous field of the current record?
a. / [Home] / c. / [Up Arrow]b. / [Shift][Tab] / d. / [F5]
ANS: B PTS: 1 REF: Access 7
18. Which shortcut key moves focus to the first field of the current record?
a. / [Home] / c. / [F4]b. / [End] / d. / [F5]
ANS: A PTS: 1 REF: Access 7
19. While editing a record, pressing [Esc] a second time ____.
a. / Deletes the current fieldb. / Deletes the current datasheet
c. / Removes all data from the current record
d. / Removes all changes made to the record you are currently editing
ANS: D PTS: 1 REF: Access 8 | Access 9
20. Which of the following keys will help you delete unwanted data in Edit mode?
a. / [Insert] / c. / [Ctrl]b. / [Home] / d. / [Backspace]
ANS: D PTS: 1 REF: Access 8
21. Which editing keystroke deletes one character to the right of the insertion point?
a. / [Backspace] / c. / [F2]b. / [Delete] / d. / [F7]
ANS: B PTS: 1 REF: Access 9
22. Which data type is used to sequentially order each record added to a table?
a. / Hyperlink / c. / Lookup Wizardb. / Web / d. / AutoNumber
ANS: D PTS: 1 REF: Access 13
23. Which data type stores only one of two values?
a. / OLE object / c. / Yes/Nob. / Hyperlink / d. / Null
ANS: C PTS: 1 REF: Access 13
24. Which data type links files created in other programs such as pictures, sound clips or documents?
a. / Lookup / c. / Yes/Nob. / OLE object / d. / Link Wizard
ANS: B PTS: 1 REF: Access 13
25. Which data type stores Web addresses?
a. / Lookup Wizard / c. / www addressb. / Hyperlink / d. / HTML
ANS: B PTS: 1 REF: Access 13
26. Item 7 in the figure above is the:
a. / Record selector box / c. / Navigation paneb. / Navigation bar / d. / Focus
ANS: B PTS: 1 REF: Access 7
27. Item 8 in the figure above is:
a. / The date/time / c. / A field nameb. / A record / d. / The focus
ANS: C PTS: 1 REF: Access 5
28. Item 5 in the figure above is:
a. / Where a new record would be entered / c. / A field nameb. / Where a new field would be entered / d. / The navigation pane
ANS: A PTS: 1 REF: Access 7
29. In the figure above, template 5 represents an example of:
a. / Sales pipeline / c. / Eventsb. / Marketing projects / d. / Tasks
ANS: B PTS: 1 REF: Access 5
30. In the figure above, template 8 is an example of:
a. / Tasks / c. / Issuesb. / Events / d. / Assets
ANS: A PTS: 1 REF: Access 5
COMPLETION
1. ______software is used to manage data that can be organized into lists of related information such as customers, products, vendors, employees, projects, or sales.
ANS: Database
PTS: 1 REF: Access 2
2. An Access database is able to store any number of records up to ______gigabytes.
ANS:
2
two
PTS: 1 REF: Access 3
3. A(n) ______relationship describes when a record from one table is related to several records in another table.
ANS:
one to many
one-to-many
1 to many
1-to-many
PTS: 1 REF: Access 14
4. The ______View is used to modify and define field properties that are not available in Datasheet View.
ANS: Design
PTS: 1 REF: Access 14
5. A(n) ______object allows a user to select a subset of fields or records from one or more tables.
ANS: query
PTS: 1 REF: Access 11
6. A(n) ______object provides an easy-to-use data entry screen.
ANS: form
PTS: 1 REF: Access 11
7. An Access database is called a(n) ______database because more than one table can share information through a common linked field.
ANS: relational
PTS: 1 REF: Access 5
8. A(n) ______is a spreadsheet-like grid that displays a table's fields and records.
ANS: datasheet
PTS: 1 REF: Access 4
9. When you move around the fields and records of a datasheet but do not change data, you are working in ______mode.
ANS: Navigation
PTS: 1 REF: Access 6
10. A(n) ______field automatically assigns a new number each time you add a record.
ANS: AutoNumber
PTS: 1 REF: Access 13
ESSAY
1. What are the advantages of database software such as Access over spreadsheet software such as Excel?
ANS:
1. Data entry is faster and easier.
2. Information is more accurate, reliable and consistent.
3. Information can be viewed and sorted in multiple ways.
4. Information is more secure.
5. Information can be shared among several users.
6. Duplicate data entry is minimized.
PTS: 1 REF: Access 2 TOP: Critical Thinking
2. The Database window displays the Tables, Queries, Forms, and Reports. Describe what these four objects represent.
ANS:
A table contains all of the raw data within the database.
A query is a method of asking questions about the data.
A form provides a convenient way to enter data.
A report is a customized format for printing data from one or more tables.
PTS: 1 REF: Access 11 TOP: Critical Thinking
MODIFIED TRUE/FALSE
1. When creating a database using an Access template, you must remember that field names cannot be altered later. ______
ANS: F, can be altered at any time
PTS: 1 REF: Access 12
2. The navigation bar is found at the top of the datasheet. ______
ANS: F, bottom
PTS: 1 REF: Access 7
3. You cannot undo a record deletion operation. ______
ANS: F, can
PTS: 1 REF: Access 8
4. If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode. ______
ANS: F, Edit
PTS: 1 REF: Access 6
5. In Access, data entry screens are called forms. ______
ANS: T PTS: 1 REF: Access 10
MATCHING
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]
1. First field of the current record
2. Next field of the current record
3. Last field of the current record
4. Previous field of the current record
5. Last field of the last record
6. Current field of the previous record
7. First field of the first record
8. Current field of the next record
1. ANS: E PTS: 1 REF: Access 7
2. ANS: B PTS: 1 REF: Access 7
3. ANS: F PTS: 1 REF: Access 7
4. ANS: A PTS: 1 REF: Access 7
5. ANS: D PTS: 1 REF: Access 7
6. ANS: C PTS: 1 REF: Access 7
7. ANS: H PTS: 1 REF: Access 7
8. ANS: G PTS: 1 REF: Access 7
CASE
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.
1. 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
ANS:
c
PTS: 1 REF: Access 3 TOP: Critical Thinking
Jeff wants to create an Access database of the musical instruments he owns.
2. A Purchase Price field should be which data type?
a. Text
b. Number
c. Monetary
d. Currency
ANS:
d
PTS: 1 REF: Access 13 TOP: Critical Thinking
3. 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
ANS:
c
PTS: 1 REF: Access 13 TOP: Critical Thinking