Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Access Exam comp1000, Quizzes of Computer Applications

Exam information for comp literacy 1000

Typology: Quizzes

2023/2024

Uploaded on 07/06/2024

levi-hankins
levi-hankins 🇺🇸

1 / 16

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Adding records to a database is sometimes referred to as _____ the database.
Select one:
a.
expanding
b.
exploding
c.
populating
Correct
d.
seeding
Feedback
REF: 352
OBJ: 6.2.3
MSC: Exam
The correct answer is: populating
Task 2 | Mark: 1.00/1.00
Question text
A field called ZipCode should be assigned the _____ field type.
Select one:
a.
Number
b.
AutoNumber
c.
Short Text
Correct
d.
Date/Time
Feedback
REF: 344
OBJ: 6.2.1
MSC: Exam
The correct answer is: Short Text
Task 3 | Mark: 1.00/1.00
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff

Partial preview of the text

Download Access Exam comp1000 and more Quizzes Computer Applications in PDF only on Docsity!

Adding records to a database is sometimes referred to as _____ the database. Select one: a. expanding b. exploding c. populating Correct d. seeding Feedback REF: 352 OBJ: 6.2. MSC: Exam The correct answer is: populating Task 2 | Mark: 1.00/1. Question text A field called ZipCode should be assigned the _____ field type. Select one: a. Number b. AutoNumber c. Short Text Correct d. Date/Time Feedback REF: 344 OBJ: 6.2. MSC: Exam The correct answer is: Short Text Task 3 | Mark: 1.00/1.

Question text A form is a database object used primarily for _____ records in a table. Select one: a. entering Correct b. filtering c. sorting d. spell-checking Feedback REF: 354 OBJ 6.2. MSC: Exam The correct answer is: entering Task 4 | Mark: 1.00/1. Question text The _____ bar displays at the bottom of the form. Select one: a. Record Navigation Correct b. Page Number c. Data Entry d. Field Number Feedback REF: 358 OBJ: 6.2. MSC: Exam

MSC: Exam The correct answer is: Table Design Task 7 | Mark: 1.00/1. Question text To prevent having duplicate entries in a field, assign a(n) _____ to the field. Select one: a. primary key Correct b. description c. index d. filter Feedback REF: 346, 348 Tip OBJ: 6.2. MSC: Exam The correct answer is: primary key Task 8 | Mark: 1.00/1. Question text Use options on the Form Layout Tools _____ tab to change the font size and font style. Select one: a. Format Correct b. Layout c. Arrange d. Design Feedback REF: 354 TIF

OBJ: 6.2.

MSC: Exam The correct answer is: Format Task 9 | Mark: 1.00/1. Question text What happens if you press the Tab key after you enter data in the last field of a form? Select one: a. The first field in the form redisplays. b. A new blank form displays. Correct c. The database closes. d. The previous field in the form displays. Feedback REF: 358 OBJ: 6.2. MSC: Exam The correct answer is: A new blank form displays. Task 10 | Mark: 1.00/1. Question text What is the maximum number of characters a Short Text field can store? Select one: a. 20 b. 63 c. 100 d. 255 Correct

make the changes to the existing record and then copy it to create the new record. Feedback REF: 352 Tip OBJ: 6.2. MSC: Exam The correct answer is: copy the entire existing record and then make the necessary changes. Task 13 | Mark: 1.00/1. Question text When creating a relationship between two tables, select _____ to ensure you are not able to delete a record in one table if a matching record exists in another table. Select one: a. Enforce Paired Integrity b. Set Integrity c. Enforce Matching d. Enforce Referential Integrity Correct Feedback REF: 350 Tip OBJ: 6.2. MSC: Exam The correct answer is: Enforce Referential Integrity Task 14 | Mark: 1.00/1. Question text When entering data into an Access table, press _____ to move to the next field. Select one: a. Shift + Tab b. Tab Correct c.

Page Up d. Home Feedback REF: 352 OBJ: 6.2. MSC: Exam The correct answer is: Tab Task 15 | Mark: 1.00/1. Question text When one record in one table is associated with only one record in a second table, create a _____ relationship. Select one: a. one-to-one Correct b. one-to-single c. Single-to-one d. unique Feedback REF: 350 OBJ: 6.2. MSC: Exam The correct answer is: one-to-one Task 16 | Mark: 1.00/1. Question text When you create a form, the ribbon displays three Form Layout Tools tabs. Which of the following is not one of those tabs? Select one: a. Design b.

b. Layout c. Form Correct d. Table Feedback REF: 358 OBJ: 6.2. MSC: Exam The correct answer is: Form Task 19 | Mark: 1.00/1. Question text When you use the Form Design button to create a new form, it displays in _____ view. Select one: a. Layout b. Design Correct c. Format d. Table Feedback REF: 354 Tip OBJ: 6.2. MSC: Exam The correct answer is: Design Task 20 | Mark: 1.00/1. Question text Which field type automatically stores a number that is one greater than the last number used? Select one: a.

AutoNumber Correct b. Number c. OneMore d. AddOne Feedback REF: 344 OBJ: 6.2. MSC: Exam The correct answer is: AutoNumber Task 21 | Mark: 1.00/1. Question text Which of the following Access objects provides a user-friendly data entry method? Select one: a. report b. form Correct c. table d. query Feedback REF: 344 OBJ: 6.2. MSC: Exam The correct answer is: form Task 22 | Mark: 1.00/1. Question text Which of the following field types allows you to set a maximum field size to prevent data entry errors?

Question text Which of the following is not one of the steps outlined in Chapter 2 for copying data from Microsoft Word into an Access table? Select one: a. Separate the data by tabs. b. Copy the data from a table. c. Ensure that the data match the fields in the Access table. d. Save the data as an Excel workbook. Correct Feedback REF: 353 TIF OBJ: 6.2. MSC: Exam The correct answer is: Save the data as an Excel workbook. Task 25 | Mark: 1.00/1. Question text Which of the following is not true of a relational database? Select one: a. It can contain multiple tables. b. It connects tables based on shared fields. c. It helps prevent data redundancy. d. It can proofread entries. Correct Feedback REF: 350 OBJ: 6.2. MSC: Exam

The correct answer is: It can proofread entries. Task 26 | Mark: 1.00/1. Question text You can adjust the size of all the fields in a form by hovering the mouse pointer over the right border of a field until it becomes a _____ and then dragging the border to the desired size. Select one: a. solid black crosshair b. four-headed arrow c. left-and-right-pointing arrow Correct d. solid white arrow Feedback REF: 356, 356 Tip OBJ: 6.2. MSC: Exam The correct answer is: left-and-right-pointing arrow Task 27 | Mark: 1.00/1. Question text You can enter records into a form from Select one: a. the Form Layout Tools Design tab. b. Form view. Correct c. the Form Layout Tools Arrange tab. d. the Form Layout Tools Format tab. Feedback REF: 354 TIF

Feedback REF: 352 Shortcut OBJ: 6.2. MSC: Exam The correct answer is: Ctrl + C Task 30 | Mark: 1.00/1. Question text You can use the Record Navigation bar to Select one: a. see how many records are available for viewing. Correct b. sort the records in a form. c. change the appearance of the records in a form. d. filter the records in a form. The correct answer is: see how many records are available for viewing.