Study Guide - Access Chapter 1

Study Guide - Access Chapter 1 - Access Chapter 1 Creating...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Access Chapter 1 – Creating and Using a Database MULTIPLE CHOICE 1. Access is a ____. a. word processing software tool c. workbook management system b. file management system d. database management system ANS: D PTS: 1 REF: AC 2 2. In Access, a(n) ____ consists of a collection of tables, each of which contains information on a specific subject. a. object c. database b. relation d. tuple ANS: C PTS: 1 REF: AC 3 3. A(n) ____ contains information about a given person, product, or event. a. attribute c. field b. record d. column ANS: B PTS: 1 REF: AC 4 4. ____ words are words that have a special meaning to Access and cannot be used for the names of fields or tables. a. Special c. Significant b. Reserved d. Restricted ANS: B PTS: 1 REF: AC 8 5. In Access, table and field names can be up to ____ characters in length. a. 32 c. 128 b. 64 d. 255 ANS: B PTS: 1 REF: AC 8 6. A field whose data type is ____ can contain any characters. a. Alpha c. Normal b. Text d. Lookup ANS: B PTS: 1 REF: AC 9 7. A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255. a. Unlimited c. Memo b. Variable d. Character ANS: C PTS: 1 REF: AC 10 8. A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added. a. Sequential c. Incremental b. AutoNumber d. AutoSequence ANS: B PTS: 1 REF: AC 10 9. A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet. a. Attachment c. Document b. File d. Extend ANS: A PTS: 1 REF: AC 10 10. A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table. a. Picture c. OLE Object b. Image d. Bitmap ANS: C PTS: 1 REF: AC 10 11. When you maximize a window, the Maximize button changes to a(n) ____ button. a. Minimize c. Original b. Return d. Restore Down ANS: D PTS: 1 REF: AC 13
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
12. A saved database is referred to as a ____. a. file c. DBMS b. databook d. template ANS: A PTS: 1 REF: AC 13 13. To change the save location for a database, click ____ in the Favorite Links section. a. Save in c. Desktop b. Searches d. Computer ANS: D PTS: 1 REF: AC 16 14. When you create a new database, the name of the database appears on the ____ bar. a. title c. menu b. Windows d. scroll ANS: A PTS: 1 REF: AC 17 15. In addition to the top-level tabs, Access displays other tabs called ____ tabs that display when you perform certain tasks or work with certain objects such as datasheets. a. subtype c. contextual b. tiered d. sublevel ANS: C PTS: 1 REF: AC 20 16. One way to create a table, is to click ____ on the Ribbon and then click the Table button. a.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 44

Study Guide - Access Chapter 1 - Access Chapter 1 Creating...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online