









Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Exam information for comp literacy 1000
Typology: Quizzes
1 / 16
This page cannot be seen from the preview
Don't miss anything!
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
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.