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.
