1 / 10

Ski Shop Assignment

Ski Shop Assignment. 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:

vina
Download Presentation

Ski Shop Assignment

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. Ski Shop Assignment

  2. 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

  3. Create your table by entering data:

  4. Make a table with the following data records:

  5. Let Access set the primary key automatically. This option will pop up when you try to save your table…

  6. 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.

  7. Query: Find all stores in CO

  8. 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).

  9. First Name Last Name Mrs. Didero Comp. Lit. 8; 4 12/12/08

  10. End

More Related