SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Ski Shop Database Assignment Instructions and Requirements

jerrod avatar
jerrod
12 diapositives · 245 Views · Sep 26, 2014

Complete the SkiShop.mdb database assignment on your drive. Create a table with fields for Store Name, Owner/Manager, Street Address, City Name, State, and Zip Code, with the primary key set automatically. Prepare a Word document with answers that include a copy of your table, form, find/replace details, query results, and a report. Ensure all data is accurate. Find and replace state names with abbreviations, run a query for stores in Colorado, and include screenshots of your work in the Word document. Email the completed assignment to your teacher.

Ski Shop Database Assignment Instructions and Requirements - slide 1
01 / 12Ski Shop Database Assignment Instructions and Requirements
1 / 17

Télécharger la présentation

Ski Shop Database Assignment Instructions and Requirements
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Ski Shop Assignment

  2. Instructions: • Create as “SkiShop.mdb” on your U:/ drive. • Complete this Database Assignment • Email this to your teacher when finished • 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 in Design View:

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

  5. Make a table with the following data records:

  6. Ski Shop directions (continued): • Open a Word document and key in your heading. The “answers” on the word document will be • Copy of your Table • Form copy • Find/Replace – you will have 4 of these • Query – Design View and Result • Report • Make sure you have all data entered correctly. • Make a copy of your table and paste it before making any changes. • Make a new form with Form Wizard. Make the form columnar. • Sort the forms by zip code and move to the last record. • Use Alt/Printscreen to make a screen-shot of the form you made and copy it to your Word document.

  7. Ski Shop directions (continued): • Find and Replace: • Find Colorado and Replace with CO – Copy/Paste the find window • Find California and Replace with CA – Copy/Paste the find window • Find Nevada and Replace with NV – Copy/Paste the find window • Find Utah and Replace with UT – Copy/Paste the find window

  8. Ski Shop directions (continued): • Run a query for all stores in CO (Colorado). Go into design view of your query and sort ascending by city. • Copy both datasheet view and design view of the query to your word document.

  9. Ski Shop directions (continued): • Run a quick report of your entire Ski Shops table and make a screen-shot to paste on your Word document. • Email you assignment to me with Ski Shops in your email subject line.

  10. Query: Find all stores in CO

  11. The Ski Shop Assignment: • Be sure to have the heading on your word doc • Be sure to have all 5 objects: • Table, form, find, query, & report • Spell check!

  12. End