Presentation Transcript

1. Database Design Week 11
2. Forms
3. Table Manyrecords at a time Somefields do not fit on one screen Column and rowformatting only Can be confusing to new users Form 1recordat a time Allfields can fit on 1screen Anyformatting optionsyou set-up “User-friendly”and less-intimidating than tables Table Vs. Form
4. WHAT IS A FORM?• “Electronic Equivalent” to a paper form• allows you to create a custom layoutfor your data• more “visually appealing” for “Data Entry”• when you need to control which datais displayed or entered
5. Why Use Forms? Provide a “User-Oriented” interfaceto the data Only asks for specific information Ability to use “non technical” terms Should be designed around individual tasks
6. First name: Last name: Address: City: State: Zip: Fields in a Form Application for Employment The field labelsin a form are like the labels on an application. The field text boxes are where you supply the data, like the blank lines on an application.
7. FORMS cont. Forms are made up of controls, such as text boxes, buttons, document tabs, and drop-down lists, grouped in a way that makes them easy to use The controls in the form are usually “bound”, or “linked”to the tables or queries in your database — but not always. For example, a control that displays “Customer data” is probably bound to either the “Customer” table, or to a query that retrieves Customer data. BUT: a form control that displays your corporate logo isn't bound to a table field; it just points to the image it displays.
8. Create Forms Watch http://www.youtube.com/watch?v=R3WHo7DAOg0 this video demonstrates the forms window, and how to auto-create forms How To: Create a form Remove the sub form Change the title Change the layout Create a split form
9. Create Forms Exercise Exercise: Create forms for the Wk11_TableInstanceChart Example City entity Table 1 and Table 2 entities Students entity Create a form for the Northwind database employee table
10. Northwind Database
11. Students Work Through Access 2010 Formatting Forms http://www.gcflearnfree.org/access2010/14
12. REPORTS Ways of generating printed output Can create reports that show totals & grand totals of value in a particular field Reports give you the ability to present components of your database in an easy-to-read, printable format. Access 2010 lets you create reports from both tables and queries.
13. Hybrid / Homework Read Creating Reports Read Advanced Report Options Review Access Videos Database Assignment Part 3 (due Wk. 13 submitted as an EMAIL ATTACHMENT)
14. MYITLAB HOMEWORK: myitlabTRAINING: Access VOLUME 1- “Skill-Based TRAINING” myitlabASSIGNMENT: “GO series”