Review Sheet Access for Introduction to Microcomputer Applications | IT 1010, Study notes of Microcomputers

Download Review Sheet Access for Introduction to Microcomputer Applications | IT 1010 and more Study notes Microcomputers in PDF only on Docsity! Review Sheet Access True/False Indicate whether the sentence or statement is true or false. ____ 1. Excel lacks many of the database advantages provided by Access. ____ 2. An Access database may be as large as 200 gigabytes. ____ 3. Tables contain all of the raw data in the database. ____ 4. Access information can be printed from forms, queries, and tables. ____ 5. Access data can be entered through reports. ____ 6. The toolbars and menus within Access modify themselves to reflect those features that you most commonly use. ____ 7. The Database title bar contains the filename of the active database. ____ 8. Field names appear in the top row of a datasheet. ____ 9. The purpose for an AutoNumber field is to store information such as social security numbers or employee numbers. ____ 10. Values in an AutoNumber field cannot be edited. ____ 11. A new record may be added on any row of a datasheet. ____ 12. You can move datasheet columns by dragging the field name left or right. ____ 13. You cannot undo a record deletion operation. ____ 14. You can temporarily hide a field in a datasheet. ____ 15. A primary key field contains unique information for each record. ____ 16. The only way to create an Access table is to use the Table Wizard. ____ 17. The records of a datasheet are automatically sorted in ascending order on the first field. ____ 18. The Sort Ascending button sorts numbers before letters. ____ 19. Filtering displays all of the records at all times. ____ 20. Primary key fields can have a null entry. ____ 21. You can edit, navigate, sort, find, and filter in Query Datasheet View just like you can in Table Datasheet View. ____ 22. A filter can calculate sums, averages, counts, and other types of summary statistics across records. ____ 23. A form is the primary object used to enter, edit, and find data. ____ 24. In a datasheet, sometimes all of the fields are not visible. ____ 25. A text box control is a bound control. ____ 26. A tab control is an unbound control. _ ____ 27. Whether you create the form from scratch in Design View or by using the Form Wizard, you can modify it later if needed. ____ 28. Forms can be used to enter and edit data. ____ 29. A label is a bound control. ____ 30. By designing a form to match a source document, you facilitate fast and accurate data entry. ____ 31. Bound controls exist only to clarify or enhance the appearance of the form. ____ 32. Text boxes are often used to clarify and describe bound labels. ____ 33. You can make property changes to a control through the menu and toolbar options. ____ 34. On a form, text box controls display data from an underlying record source. ____ 35. If you click in either the horizontal or vertical ruler in Form Design View, you will select all controls that intersect the selection line. ____ 36. Access reports can be based on either a table or query object. ____ 37. You cannot enter or edit data through a report. ____ 38. When using a wizard, you can click the Back button to review previous dialog boxes. ____ 39. You can base a report on a query object. ____ 40. Once a report is created, you cannot change the way the records are sorted. ____ 41. Once a report is created, you cannot change the way the records are grouped. ____ 42. When entering an expression, the field name must be referenced exactly and surrounded by square brackets. ____ 43. You can align the right or left edges of controls in different sections. Multiple Choice Identify the letter of the choice that best completes the statement or answers the question. ____ 44. Access 2003 can best be described as ____ software. a. Spreadsheet. b. Presentation. c. Database. d. Systems. ____ 45. Which is NOT a feature of Access reports? a. Multiple headers. b. Multiple footers. c. Calculations on groups of records. d. The ability to enter data through a data entry screen. ____ 46. Which is NOT true about Access? a. It can be used to arrange data in a variety of ways. b. It allows links between lists of information. c. It is able to store any number of records up to 20 gigabytes. d. Multiple users can simultaneously enter and update data within Access. ____ 47. Which of the following is NOT a benefit of managing data with Access versus Excel? a. Better charting features. ____ 66. This control displays a list of possible data entries from which the user can choose. a. Label. b. Text box. c. List box. d. Tab control. ____ 67. This control is both a list box and a text box control. a. Bound image control. b. Unbound image control. c. Combo box. d. Toggle button. ____ 68. Which of the following is NOT a bound control? a. Text box. b. Combo box. c. List box. d. Label. ____ 69. Which type of control would you most likely use to display first name information? a. Text box. b. Label. c. Combo box. d. List box. ____ 70. Which of the following is NOT a way to create a new form? a. Use the Create Wizard. b. Use the AutoForm feature. c. Use Form Design view. d. Use the Form Wizard. ____ 71. Which of the following would most likely be used to display a Yes/No field on a form? a. Check box. b. Command button. c. Combo box. d. Label. ____ 73. A form usually puts fields in a ____ orientation. a. Horizontal. b. Global. c. Local. d. Vertical. ____ 74. When referencing field names within an expression, use ____. a. [Square brackets]. b. {Curly brackets}. c. (Parentheses). d. "Double quotes". ____ 75. Controls placed in this form section print once for every record in the underlying object. a. Form Records. b. Form Header. c. Form Footer. d. Detail. ____ 76. The Report Footer section prints ____. a. At the end of the entire report. b. At the bottom of every page. c. At the top of the entire report. d. At the top of every page. ____ 77. The Group Header section prints ____. a. At the top of the first page of the report. b. At the top of every page. c. Once for every record. d. Before every group of records. ____ 78. The Page Footer section prints ____. a. At the bottom of every page. b. At the end of the entire report. c. At the end of the first and last pages in the report. d. Once for every group of records. ____79.Which control is most commonly placed in the Report Header section? a. Text box. b. Subtotal. c. Check box. d. Label. ____ 80. A text box control that contained a calculated expression such as a subtotal or count would most likely be found in which report section? a. Report Header. b. Page Header. c. Page Footer. d. Group Footer. ____ 81. Which section would most likely contain page number and date expressions? a. Report Header. b. Group Header. c. Detail. d. Page Footer. ____82.Which section prints below the Report Header on page one? a. Report Header. b. Page Header. c. Page Footer. d. Report Footer. ____ 83 The Report Header section prints ____. a. At the top of every page. b. At the top of the first page. c. Before every group of records. d. Once for every record.