1 / 7

My Tunes

My Tunes. The Database. Set up your MyTunes Table:. Make your table in design view with the following fields: Song Name, Artist, Time (you’ll just estimate this as anywhere from 2 – 4 minutes), Album or CD that it’s from.

chaeli
Download Presentation

My Tunes

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. My Tunes The Database

  2. Set up your MyTunes Table: Make your table in design view with the following fields: Song Name, Artist, Time (you’ll just estimate this as anywhere from 2 – 4 minutes), Album or CD that it’s from. • You can look on Amazon.com for the first 10 minutes of class if you need to look up music. You may also use your iPod to look up music for the first 10 minutes. • Have all fields as text – including the time field.

  3. Have Access assign an “ID” field that is auto numbered. Click “yes” at this prompt:

  4. Make your objects… • Just follow the wizards through selecting ALL fields. • A Form so you can enter all new music easily. • A Report so you can have a copy of your favorites. • A Query so you can find your music in your database.

  5. Remember, you can always sort by clicking on the field name in a table or query:

  6. Turn in a Word document of the following. • TABLE - Sort your table alphabetically by artist, and copy this (not a screen shot) like you copied your Excel spreadsheets to your Word document. • QUERY – Sort your query numerically from shortest to longest song. Copy the query like you copied your table. • FORM – Take a screen shot of your form and include in your Word doc. • REPORT – Choose a report in the style of your choice. Use all fields when making this report in the Wizard. Take a screen shot of the report and form together (yes, just like a little family photo =- ) and include in your Word document.

  7. The End

More Related