Instructions: • Database Assignment • Email this to your teacher when finished • Save as “lastnameSkiShop.mdb” in your Access folder of your portfolio • Input the following into a new table using design view: • Make the fields: Store Name, Owner/Manager, Street Address, City Name, State, Zip Code
Let Access set the primary key automatically. This option will pop up when you try to save your table…
Ski Shop directions (continued): • Make sure you have everything entered correctly. Remember GIGO! • Make a new form with Form Wizard. Make the form columnar. • Open a Word document and key in your MLA heading. • Printscreen the form you made to your Word document in form view. • Run a query for all stores in CO (Colorado). Go into design view of your query and sort ascending by last name of the owner or manager. • Copy both datasheet view and design view of the query to your word document. • Run a quick report of your entire Ski Shops table and print screen to your Word document. • Email you assignment to me with Ski Shops in your email subject line.
The Ski Shop Assignment: • Be sure to have the MLA heading • Be sure to have all 4 objects: • Table, form, query, report • Spell check! • Make sure titles are in title case (the first letter of the first word is capitalized).
First Name Last Name Mrs. Didero Comp. Lit. 8; 4 12/12/08