BCIS 3610 - specifies how data is to be entered and how it...

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

View Full Document Right Arrow Icon
BCIS 3610.003 – Access Quiz 3 7/2/2009 Sum I Name: _________________________________ Student ID: _______________________ Identify the choice that best completes the statement or answers the question. ____ 1. To modify the design of a table, right-click the table in the Navigation Pane, and click _____ on the shortcut menu. a. Modify Table c. Design View b. Change Table d. Modify View ____ 2. By default, Access disables macros when it opens a database and displays a Security Warning. a. True b. False ____ 3. The _____ data type is used for a field that contains text that is variable in length and that can potentially be very lengthy. a. Variable c. VarChar b. Attachment d. Memo ____ 4. In the JSP Recruiters database the Client Financial Form, Client Number BH72 shows an Amount Paid is: a. $0.00 c. $17,500.00 b. $29,200.00 d. $12,500.00 ____ 5. In the Second Hand Goods database, the Master Seller Form shows that Seller MT has ____ items sold. a. 0 c. 2 b. 1 d. 3 ____ 6. An input mask
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: specifies how data is to be entered and how it will appear. a. True b. False ____ 7. If the primary key of the Seminar Offerings table contains the primary key for both the Client table and Seminar table, there is a _____ relationship between clients and seminars. a. one-to-one c. many-to-one b. one-to-many d. many-to-many ____ 8. To relate tables, click the _____ button on the Database Tools tab. a. Relate Tables c. Referential Integrity b. Relationships d. Show Tables ____ 9. In the Second Hand Goods database there are _____ macros contained in the SHG Macros group. a. 3 c. 5 b. 4 d. 6 ____ 10. In the Second Hand Goods database, the relationship between Seller and Item is: a. one-to-one c. many-to-one b. one-to-many d. many-to-many Access Quiz 3 Answer Section MULTIPLE CHOICE 1. ANS: C PTS: 1 REF: AC 302 2. ANS: A PTS: 1 3. ANS: D PTS: 1 4. ANS: B PTS: 1 5. ANS: C PTS: 1 6. ANS: A PTS: 1 7. ANS: D PTS: 1 REF: AC 392 8. ANS: B PTS: 1 9. ANS: D PTS: 1 10. ANS: B PTS: 1...
View Full Document

Page1 / 2

BCIS 3610 - specifies how data is to be entered and how it...

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

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