16 what is the documenter it is a tool in access that

This preview shows page 6 - 8 out of 10 pages.

16. What is the Documenter? It is a tool in access that produces a report of every object or selected objects in Access. 17. How does encrypting a database with a password provide security? It makes it so that users are not able to unintentionally alter an objects design or by deleting it entirely. It also allows for certain objects to be completely hidden from the user but still used by the database itself. Chapter 4 1. Why is it important to test your database before beginning the process of developing forms and reports? It is much easier to test all relationships, data integrity rules, input masks, and other field properties before creating forms. If you import data from a spreadsheet, edit the data in table datasheet view to make it compatible with your new application. 2. When is it more appropriate to enter data in Datasheet view? Datasheet entry is efficient when you need to enter many records at the same time, especially if you routinely work with the same documents. You might also use a datasheet to quickly enter sample data for testing. 3. What are the differences between forms created with the Form Wizard and the Form tools? You would use a simple form tool when you want to quickly create a query using all the fields in a table. You would use the form wizard when you want to select fields from different tables or to specify the field order. 4. What is the reason for working to have a consistent style and layout, especially of command buttons? The reason for developing a consistent style and layout is that all your forms will share the same design therefore they have a consistent user interface, and that means that users only need to learn how to use the forms once to be able to apply what they learn to all the forms in the database. 5. Explain the difference between a bound control and an unbound control.
Image of page 6

Subscribe to view the full document.

Review Questions The difference between a bound control and an unbound control is that a bound control is bound to data in a record source therefore it may change depending on the record. An unbound control is not tied to a record source therefore it is persistent regardless of any data source on the form. 6. What is a user view and why would you create one? A user view is a custom form that shows only the fields a particular user wants; it might or might not be used for data entry and, in some cases, the fields may be locked so all the user can do is look at the data. 7. If you wanted to print a selected record of a form, how would you modify the form? In order to print a form you would want to control the vertical spacing on the printed page and include a date and page number on the form. Also you would want to make a sample form to test printing so that you can avoid making changes to existing forms that might cause problems for users.
Image of page 7
Image of page 8
  • Fall '07
  • Unk
  • Relational model, Database normalization

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern