, TESTBANK for Illustrated Series® Collection,
Microsoft 365 & Office 2021 1st Edition David
Beskeen
Notes
1- The file is chapter after chapter.
2- We have shown you 10 or five pages.
3- The file contains all Appendix and Excel
sheet if it exists.
4- We have all what you need, we make
update at every time. There are many new
editions waiting you.
5- If you think you purchased the wrong file
You can contact us at every time, we can
replace it with true one.
Our email:
,Name: Class: Date:
Access Module 01
1. When you start Access, the first screen that appears is one showing a blank database.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-8
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.1.1.1 - Open Access
CORPORATE STANDARDS: 4304 - Start Access.
TOPICS: Illustrated series: Open and Explore a Database
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/26/2019 12:52 AM
DATE MODIFIED: 6/1/2020 6:43 PM
2. Before you close a database, you must save any changes you made to the data.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-4
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.1.2.2 - Close a database.
CORPORATE STANDARDS: 1200 - Close a database.
TOPICS: Illustrated series: Open and Explore a Database
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:15 AM
DATE MODIFIED: 7/30/2019 5:19 AM
3. A new blank desktop database includes one table named Table1.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-22
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.1.1 - Create a blank desktop database.
CORPORATE STANDARDS: 1345 - Create a blank desktop database.
TOPICS: Illustrated series: Create a Database
KEYWORDS: Bloom's: Remember
Copyright Cengage Learning. Powered by Cognero. Page 1
,Name: Class: Date:
Access Module 01
DATE CREATED: 7/30/2019 5:20 AM
DATE MODIFIED: 7/30/2019 5:24 AM
4. To rename a form, open the form, and then use the Rename command on the Home tab.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-16
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.5.2.1 - Rename forms.
CORPORATE STANDARDS: 3330 - Rename a form in the Navigation pane.
TOPICS: Illustrated series: Create a Form
KEYWORDS: Bloom's: Apply
DATE CREATED: 7/30/2019 5:28 AM
DATE MODIFIED: 7/30/2019 5:31 AM
5. To learn about the new features in Access, you can use the Tell Me box.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-24
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.1.8 - Use the help function to solve a problem.
CORPORATE STANDARDS: 4568 - Use the Tell Me box.
TOPICS: Illustrated series: Compact and Back Up a Database
KEYWORDS: Bloom's: Remember
DATE CREATED: 8/1/2019 7:41 AM
DATE MODIFIED: 6/2/2020 2:27 PM
6. Compacting a database rearranges the data and objects in a database to decrease its file size.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-24
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.4.1 - Compact and repair a database.
CORPORATE STANDARDS: 1237 - Compact and repair a database.
Copyright Cengage Learning. Powered by Cognero. Page 2
,Name: Class: Date:
Access Module 01
TOPICS: Illustrated series: Compact and Back Up a Database
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:33 AM
DATE MODIFIED: 6/1/2020 6:45 PM
7. To navigate to a record in a table, switch to Table Design view.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-6
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.3.1 - Navigate to specific records.
CORPORATE STANDARDS: 2989 - Navigate to the previous record in Table Datasheet view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 5:41 AM
DATE MODIFIED: 8/1/2019 3:05 AM
8. Table Design view shows how each table relates to other tables in the database.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.3.6 - Change views of objects.
CORPORATE STANDARDS: 4588 - View a table in Table Design view.
TOPICS: Illustrated series: Create a Table
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 5:46 AM
DATE MODIFIED: 7/30/2019 5:49 AM
9. To enter data in a table, open it in Table Datasheet view.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: True / False
HAS VARIABLES: False
Copyright Cengage Learning. Powered by Cognero. Page 3
,Name: Class: Date:
Access Module 01
LEARNING OBJECTIVES: ILAC.BESK.20.2.3.6 - Change views of objects.
CORPORATE STANDARDS: 4587 - View a table in Table Datasheet view.
TOPICS: Illustrated series: Create a Table
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:52 AM
DATE MODIFIED: 7/30/2019 5:54 AM
10. When you add a field to a table in Table Design view, entering the field name is optional.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-7
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.4.2 - Add fields to tables.
CORPORATE STANDARDS: 92 - Add a field to a table in Table Design view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:55 AM
DATE MODIFIED: 7/30/2019 5:58 AM
11. Access displays your user account information in the Navigation Pane.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-2
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.1.3.1 - Manage user account information.
CORPORATE STANDARDS: 1909 - Display user account information.
TOPICS: Illustrated series: Understand Relational Databases
KEYWORDS: Bloom's: Remember
DATE CREATED: 8/1/2019 7:49 AM
DATE MODIFIED: 8/1/2019 7:52 AM
12. Compacting a database has the same result as backing up a database.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-24
Copyright Cengage Learning. Powered by Cognero. Page 4
,Name: Class: Date:
Access Module 01
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.4.2 - Back up a database.
CORPORATE STANDARDS: 617 - Back up a database.
TOPICS: Illustrated series: Compact and Back Up a Database
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:59 AM
DATE MODIFIED: 7/30/2019 6:02 AM
13. You can create a table in Table Datasheet view or Table Design view.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.1.2 - Create a table.
CORPORATE STANDARDS: 1587 - Create a table in Table Datasheet view.
TOPICS: Illustrated series: Creating a Table
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 6:03 AM
DATE MODIFIED: 7/30/2019 6:06 AM
14. After you create a table, you must save the entire database so you do not lose the new table.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-4
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.5.1 - Save databases and objects.
CORPORATE STANDARDS: 3635 - Save a database.
TOPICS: Illustrated series: Open and Explore a Database
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:12 AM
DATE MODIFIED: 7/30/2019 6:15 AM
15. Before you can rename a field, you must change its data type.
a. True
b. False
ANSWER: False
Copyright Cengage Learning. Powered by Cognero. Page 5
,Name: Class: Date:
Access Module 01
POINTS: 1
REFERENCES: ILAC 1-12
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.2.6 - Rename tables and table fields.
CORPORATE STANDARDS: 3324 - Rename a field in Table Design view.
TOPICS: Illustrated series: Modify Fields
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 6:16 AM
DATE MODIFIED: 7/30/2019 6:19 AM
16. To display the data in a table, you open the table in Table Design view.
ANSWER: False - Datasheet
False - Data sheet
False - datasheet
False - data sheet
False - DATASHEET
False - DATA SHEET
False - Data Sheet
POINTS: 1
REFERENCES: ILAC 1-4
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
LEARNING OBJECTIVES: ILAC.BESK.20.3.1.1 - Open a table
CORPORATE STANDARDS: 3005 - Open a table in Table Datasheet view.
TOPICS: Illustrated series: Open and Explore a Database
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:20 AM
DATE MODIFIED: 7/30/2019 6:40 AM
17. For a Comments field that contains many words, set a Long data type.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.4.10 - Change field data types.
CORPORATE STANDARDS: 3867 - Set a field's data type in Table Design view.
TOPICS: Illustrated series: Create a Table
KEYWORDS: Bloom's: Remember
Copyright Cengage Learning. Powered by Cognero. Page 6
,Name: Class: Date:
Access Module 01
DATE CREATED: 7/30/2019 6:41 AM
DATE MODIFIED: 7/30/2019 6:44 AM
18. A field with the Currency data type contains values such as quantities, measurements, and scores.
ANSWER: False - Number
False - number
False - NUMBER
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
LEARNING OBJECTIVES: ILAC.BESK.20.3.4.10 - Change field data types.
CORPORATE STANDARDS: 3867 - Set a field's data type in Table Design view.
TOPICS: Illustrated series: Create a Table
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:45 AM
DATE MODIFIED: 7/30/2019 6:48 AM
19. When you enter a record in a table, you are working in navigation mode.
ANSWER: False - edit
False - Edit
False - EDIT
POINTS: 1
REFERENCES: ILAC 1-16
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
LEARNING OBJECTIVES: ILAC.BESK.20.3.3.3 - Add and remove table records.
CORPORATE STANDARDS: 2062 - Enter a record into a table.
TOPICS: Illustrated series: Create a Form
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:54 AM
DATE MODIFIED: 7/30/2019 6:57 AM
20. Use the New (blank) record button to move the focus to the first record in a table.
ANSWER: False - First
False - first
False - FIRST
POINTS: 1
REFERENCES: ILAC 1-6
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
Copyright Cengage Learning. Powered by Cognero. Page 7
, Name: Class: Date:
Access Module 01
LEARNING OBJECTIVES: ILAC.BESK.20.2.3.1 - Navigate to specific records.
CORPORATE STANDARDS: 2983 - Navigate to the first record in Table Datasheet view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:59 AM
DATE MODIFIED: 7/30/2019 7:02 AM
21. You might delete an employee record if the employee no longer works for the company.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-6
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.3.3 - Add and remove table records.
CORPORATE STANDARDS: 1771 - Delete a record in Table Datasheet view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 7:04 AM
DATE MODIFIED: 7/30/2019 7:06 AM
22. Press ESC to remove editing changes you made to the previous record.
ANSWER: False - current
False - Current
False - CURRENT
POINTS: 1
REFERENCES: ILAC 1-6
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
LEARNING OBJECTIVES: ILAC.BESK.20.3.3.2 - Update and edit table records.
CORPORATE STANDARDS: 1995 - Edit a record in Table Datasheet view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 7:08 AM
DATE MODIFIED: 7/30/2019 7:16 AM
23. A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single
datasheet.
ANSWER: False - query
False - Query
False - QUERY
POINTS: 1
Copyright Cengage Learning. Powered by Cognero. Page 8
Microsoft 365 & Office 2021 1st Edition David
Beskeen
Notes
1- The file is chapter after chapter.
2- We have shown you 10 or five pages.
3- The file contains all Appendix and Excel
sheet if it exists.
4- We have all what you need, we make
update at every time. There are many new
editions waiting you.
5- If you think you purchased the wrong file
You can contact us at every time, we can
replace it with true one.
Our email:
,Name: Class: Date:
Access Module 01
1. When you start Access, the first screen that appears is one showing a blank database.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-8
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.1.1.1 - Open Access
CORPORATE STANDARDS: 4304 - Start Access.
TOPICS: Illustrated series: Open and Explore a Database
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/26/2019 12:52 AM
DATE MODIFIED: 6/1/2020 6:43 PM
2. Before you close a database, you must save any changes you made to the data.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-4
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.1.2.2 - Close a database.
CORPORATE STANDARDS: 1200 - Close a database.
TOPICS: Illustrated series: Open and Explore a Database
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:15 AM
DATE MODIFIED: 7/30/2019 5:19 AM
3. A new blank desktop database includes one table named Table1.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-22
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.1.1 - Create a blank desktop database.
CORPORATE STANDARDS: 1345 - Create a blank desktop database.
TOPICS: Illustrated series: Create a Database
KEYWORDS: Bloom's: Remember
Copyright Cengage Learning. Powered by Cognero. Page 1
,Name: Class: Date:
Access Module 01
DATE CREATED: 7/30/2019 5:20 AM
DATE MODIFIED: 7/30/2019 5:24 AM
4. To rename a form, open the form, and then use the Rename command on the Home tab.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-16
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.5.2.1 - Rename forms.
CORPORATE STANDARDS: 3330 - Rename a form in the Navigation pane.
TOPICS: Illustrated series: Create a Form
KEYWORDS: Bloom's: Apply
DATE CREATED: 7/30/2019 5:28 AM
DATE MODIFIED: 7/30/2019 5:31 AM
5. To learn about the new features in Access, you can use the Tell Me box.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-24
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.1.8 - Use the help function to solve a problem.
CORPORATE STANDARDS: 4568 - Use the Tell Me box.
TOPICS: Illustrated series: Compact and Back Up a Database
KEYWORDS: Bloom's: Remember
DATE CREATED: 8/1/2019 7:41 AM
DATE MODIFIED: 6/2/2020 2:27 PM
6. Compacting a database rearranges the data and objects in a database to decrease its file size.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-24
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.4.1 - Compact and repair a database.
CORPORATE STANDARDS: 1237 - Compact and repair a database.
Copyright Cengage Learning. Powered by Cognero. Page 2
,Name: Class: Date:
Access Module 01
TOPICS: Illustrated series: Compact and Back Up a Database
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:33 AM
DATE MODIFIED: 6/1/2020 6:45 PM
7. To navigate to a record in a table, switch to Table Design view.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-6
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.3.1 - Navigate to specific records.
CORPORATE STANDARDS: 2989 - Navigate to the previous record in Table Datasheet view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 5:41 AM
DATE MODIFIED: 8/1/2019 3:05 AM
8. Table Design view shows how each table relates to other tables in the database.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.3.6 - Change views of objects.
CORPORATE STANDARDS: 4588 - View a table in Table Design view.
TOPICS: Illustrated series: Create a Table
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 5:46 AM
DATE MODIFIED: 7/30/2019 5:49 AM
9. To enter data in a table, open it in Table Datasheet view.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: True / False
HAS VARIABLES: False
Copyright Cengage Learning. Powered by Cognero. Page 3
,Name: Class: Date:
Access Module 01
LEARNING OBJECTIVES: ILAC.BESK.20.2.3.6 - Change views of objects.
CORPORATE STANDARDS: 4587 - View a table in Table Datasheet view.
TOPICS: Illustrated series: Create a Table
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:52 AM
DATE MODIFIED: 7/30/2019 5:54 AM
10. When you add a field to a table in Table Design view, entering the field name is optional.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-7
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.4.2 - Add fields to tables.
CORPORATE STANDARDS: 92 - Add a field to a table in Table Design view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:55 AM
DATE MODIFIED: 7/30/2019 5:58 AM
11. Access displays your user account information in the Navigation Pane.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-2
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.1.3.1 - Manage user account information.
CORPORATE STANDARDS: 1909 - Display user account information.
TOPICS: Illustrated series: Understand Relational Databases
KEYWORDS: Bloom's: Remember
DATE CREATED: 8/1/2019 7:49 AM
DATE MODIFIED: 8/1/2019 7:52 AM
12. Compacting a database has the same result as backing up a database.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-24
Copyright Cengage Learning. Powered by Cognero. Page 4
,Name: Class: Date:
Access Module 01
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.4.2 - Back up a database.
CORPORATE STANDARDS: 617 - Back up a database.
TOPICS: Illustrated series: Compact and Back Up a Database
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 5:59 AM
DATE MODIFIED: 7/30/2019 6:02 AM
13. You can create a table in Table Datasheet view or Table Design view.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.1.2 - Create a table.
CORPORATE STANDARDS: 1587 - Create a table in Table Datasheet view.
TOPICS: Illustrated series: Creating a Table
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 6:03 AM
DATE MODIFIED: 7/30/2019 6:06 AM
14. After you create a table, you must save the entire database so you do not lose the new table.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: ILAC 1-4
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.2.5.1 - Save databases and objects.
CORPORATE STANDARDS: 3635 - Save a database.
TOPICS: Illustrated series: Open and Explore a Database
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:12 AM
DATE MODIFIED: 7/30/2019 6:15 AM
15. Before you can rename a field, you must change its data type.
a. True
b. False
ANSWER: False
Copyright Cengage Learning. Powered by Cognero. Page 5
,Name: Class: Date:
Access Module 01
POINTS: 1
REFERENCES: ILAC 1-12
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.2.6 - Rename tables and table fields.
CORPORATE STANDARDS: 3324 - Rename a field in Table Design view.
TOPICS: Illustrated series: Modify Fields
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 6:16 AM
DATE MODIFIED: 7/30/2019 6:19 AM
16. To display the data in a table, you open the table in Table Design view.
ANSWER: False - Datasheet
False - Data sheet
False - datasheet
False - data sheet
False - DATASHEET
False - DATA SHEET
False - Data Sheet
POINTS: 1
REFERENCES: ILAC 1-4
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
LEARNING OBJECTIVES: ILAC.BESK.20.3.1.1 - Open a table
CORPORATE STANDARDS: 3005 - Open a table in Table Datasheet view.
TOPICS: Illustrated series: Open and Explore a Database
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:20 AM
DATE MODIFIED: 7/30/2019 6:40 AM
17. For a Comments field that contains many words, set a Long data type.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.4.10 - Change field data types.
CORPORATE STANDARDS: 3867 - Set a field's data type in Table Design view.
TOPICS: Illustrated series: Create a Table
KEYWORDS: Bloom's: Remember
Copyright Cengage Learning. Powered by Cognero. Page 6
,Name: Class: Date:
Access Module 01
DATE CREATED: 7/30/2019 6:41 AM
DATE MODIFIED: 7/30/2019 6:44 AM
18. A field with the Currency data type contains values such as quantities, measurements, and scores.
ANSWER: False - Number
False - number
False - NUMBER
POINTS: 1
REFERENCES: ILAC 1-10
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
LEARNING OBJECTIVES: ILAC.BESK.20.3.4.10 - Change field data types.
CORPORATE STANDARDS: 3867 - Set a field's data type in Table Design view.
TOPICS: Illustrated series: Create a Table
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:45 AM
DATE MODIFIED: 7/30/2019 6:48 AM
19. When you enter a record in a table, you are working in navigation mode.
ANSWER: False - edit
False - Edit
False - EDIT
POINTS: 1
REFERENCES: ILAC 1-16
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
LEARNING OBJECTIVES: ILAC.BESK.20.3.3.3 - Add and remove table records.
CORPORATE STANDARDS: 2062 - Enter a record into a table.
TOPICS: Illustrated series: Create a Form
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:54 AM
DATE MODIFIED: 7/30/2019 6:57 AM
20. Use the New (blank) record button to move the focus to the first record in a table.
ANSWER: False - First
False - first
False - FIRST
POINTS: 1
REFERENCES: ILAC 1-6
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
Copyright Cengage Learning. Powered by Cognero. Page 7
, Name: Class: Date:
Access Module 01
LEARNING OBJECTIVES: ILAC.BESK.20.2.3.1 - Navigate to specific records.
CORPORATE STANDARDS: 2983 - Navigate to the first record in Table Datasheet view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 6:59 AM
DATE MODIFIED: 7/30/2019 7:02 AM
21. You might delete an employee record if the employee no longer works for the company.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: ILAC 1-6
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ILAC.BESK.20.3.3.3 - Add and remove table records.
CORPORATE STANDARDS: 1771 - Delete a record in Table Datasheet view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Understand
DATE CREATED: 7/30/2019 7:04 AM
DATE MODIFIED: 7/30/2019 7:06 AM
22. Press ESC to remove editing changes you made to the previous record.
ANSWER: False - current
False - Current
False - CURRENT
POINTS: 1
REFERENCES: ILAC 1-6
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
STUDENT ENTRY MODE: Basic
LEARNING OBJECTIVES: ILAC.BESK.20.3.3.2 - Update and edit table records.
CORPORATE STANDARDS: 1995 - Edit a record in Table Datasheet view.
TOPICS: Illustrated series: Navigate and Enter Data
KEYWORDS: Bloom's: Remember
DATE CREATED: 7/30/2019 7:08 AM
DATE MODIFIED: 7/30/2019 7:16 AM
23. A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single
datasheet.
ANSWER: False - query
False - Query
False - QUERY
POINTS: 1
Copyright Cengage Learning. Powered by Cognero. Page 8
