1 / 14

QMCS 200

QMCS 200. Lecture. Today’s Class. Hand back homeworks Exam quick look Recap on Forms “Other” data types and data entry Reports. Hand back homeworks. GIGO – errors of gender and major name “How to fix?” – use a form with input restrictions Other homework OK

hasad-beasley
Download Presentation

QMCS 200

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. QMCS 200 Lecture R. Smith - qmcs 200

  2. Today’s Class • Hand back homeworks • Exam quick look • Recap on Forms • “Other” data types and data entry • Reports R. Smith - qmcs 200

  3. Hand back homeworks • GIGO – errors of gender and major name • “How to fix?” – use a form with input restrictions • Other homework OK • Sillys had the cheapest computer at less than $200 R. Smith - qmcs 200

  4. Exam • Material Covered • MS Access • Computer hardware and buying a computer • Open book and notes, as before • Format • Similar to Excel exam • Probably NOT all-electronic • More study details next week • “Review” on Wednesday with lab for finishing homework or HOEs R. Smith - qmcs 200

  5. What to learn about Access? • How to create a table • Picking the fields, picking the data types • How to use relationships • Building tables to use them, setting them up • Creating forms • Normal fields, restricted fields, drop down selections • How to build multi-table queries • Using relationships to string things together • How to do grouped reports • Reporting on grouped tables or multi-table queries R. Smith - qmcs 200

  6. Recap on Forms • Design versus Data Entry screens • “Parts” of the design • Text box for entering keystrokes R. Smith - qmcs 200

  7. “Other” data types and data entry • Yes/No • “Check box” field • Drag and drop from the field list • Command buttons and shortcuts • Buttons are easy to build • Put & in front of a character to create a keyboard shortcut R. Smith - qmcs 200

  8. Forms Problem in Grauer/Barber • Due Monday • Builds on HOE #3 • Added techniques are described in the problem • Changing a field’s data type • You replace the field – example: the Lookup Wizard • To replace: delete the old one, drag new one from Field List • Hyperlink – just use the control • Keyboard shortcuts – just put & in name R. Smith - qmcs 200

  9. Forms Analysis Problem • Due Tuesday • What to do: write an ‘analysis’ of a form • Find a form on the Internet • Figure out what ‘checks’ are performed on fields • Write up a description • What to tell me about each field • MS Access data type and size • Different types have different kinds of sizes • What checking does the web site perform on the field • Can Access perform the same kind of checking? • Answer yes or no. If yes, explain the type of checking Access would use. If no, explain why Access can’t do it • Print out the form and include the URL in your report R. Smith - qmcs 200

  10. Examples of Forms • Shopping cart checkout at a retail site • Address label setup at US Postal Service • Something in Banner with several fields • For full credit, the form should have several fields of different types. R. Smith - qmcs 200

  11. Chapter 2 HOE 3 Pp 725-733Print ONE sample form with your name entered into it R. Smith - qmcs 200

  12. Pick lists and radio buttons • Many choices – how do you pick one? • Unchanging, short list = radio buttons • Unchanging longer list = any drop down • Changing list = put the list in a table • “Output” options • Enters the selected text • Enters the ‘primary key’ • Example – Look Ahead database • Combo box for location • Alternative: list box, which isn’t as flexible • Alternatives: Lookup Wizard, radio buttons R. Smith - qmcs 200

  13. Reports • Report Wizard vs Design Mode • Similar trade-off to forms • Design Mode • Similar to Forms • Same dotted background • Same controls R. Smith - qmcs 200

  14. Ch 3 HOE #1 P. 755-761, hand in the report on 761 R. Smith - qmcs 200

More Related