1 / 14

Week 11

Database Design . Week 11. Forms. Table Many records at a time Some fields do not fit on one screen Column and row formatting only Can be confusing to new users. Form 1 record at a time All fields can fit on 1 screen Any formatting options you set-up

shanta
Download Presentation

Week 11

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

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 14)

  14. MYITLAB HOMEWORK: • myitlabTRAINING: • Access VOLUME 1- “Skill-Based TRAINING” • myitlabASSIGNMENT: “GO series”

More Related