Access Ch 5 Review

1. Access Ch 5 Review

2. True True or False? When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.

3. False True or False: Any row and column spacing changes made to a datasheet are saved automatically when you close the table.

4. No Are the only type of pictures that can be inserted into OLE fields in Access created in Microsoft Drawing?

5. Yes When you insert data in an OLE field, can you either create a new object or insert a previously created object in the field?

6. False True/False? Rows in a datasheet may be different sizes.

7. No Does Access automatically expand the row and column to display all the data in the field when you enter data in a memo field?

8. Yes When entering data in a field that has an input mask, will Access insert the appropriate special characters in the proper position?

9. Yes Does an Attachment field appear as a paper clip rather than the field name in Datasheet view?

10. True True/False: You can use an OLE Object data type or the Attachment data type to store a picture.

11. Controls What are the various objects on a report called?

12. No Can a hyperlink field only contain links to Web pages?

13. No Can you press and hold the ALT key as you select additional controls on a form?

14. False True or False: If the field list covers a portion of the form, can you move it but not resize it.

15. No If you add a title to a form using the Title button, will Access place the title in the Detail section?

16. Yes Is a subform a separate object in a database?

17. No Is the Stretch Mode the best option for photographs?

18. Yes Can you change more than just the font and font size for a label on a form?

19. False True or False: Once the tab order for fields is determined, it cannot be changed.

20. True True or False: A form that contains a subform includes navigation buttons for both the form and subform.

21. Arrange The _____ tab is used to align controls.

22. Record Selector This is used to change the size of a row by dragging it downward.

23. Input Mask This will specify how data is to be entered and how it will appear: (Phone numbers, SSN)

24. Memo The data type used for text of variable length should be _____.

25. Options When the Security Warning appears when opening a database, click the _____ button to display the MS Office Security Options.

26. Design View This view is used for editing the design of a table by right clicking on the table in the Navigation Pane.

27. Build This button leads you to the Input Mask Wizard.

28. Column The field selector will allow you to increase the _____ size (row or column).

29. Create from File If your picture is on a flash drive, choose ______ rather than Create New for an OLE field.

30. Manage Choose _____ attachments to insert data into an Attachment field after right clicking.

31. Add Existing Fields Choose _____ to display a field list from the Design Tab.

32. Subform What is a form within a form called?

33. Property Sheet The Tab Stop property can be changed from the ________.

34. Database Tools Object Dependencies can be found under the ______ tab.

35. Yes/No This data type is appropriate for True/False, Yes/No, and On/Off.

36. * This wildcard character can represent many characters and is useful when querying a database.

37. Open After right clicking a form from the Navigation Pane, choose _____ to use the form and view data.

38. Design The subform/subreport tool is located on the _____ tab.

39. Standard Height To undo changes to the row height, right click the row selector, click Row Height on the shortcut menu and then click the _____ check box in the Row Height dialog box.

40. Short Answer: Be prepared

41. Short Answer Topics: Data type field: 3 Advantages Difference between Tab Stop property and Tab Order. 3 possible size modes – explain and best choice