bt2.5 - 3. Write a query that will list the albums in the...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
3. Write a query that will list the albums in the collection ordered by the number of tracks (from most to least) and then a lphabetically by title . List only the NumTracks, AlbumTitle, and AlbumYear for each album . Make sure that only albums with more than 15 tracks appear in the list . Save as qry_bt25_albums_by_numtracks . Mandatory Criteria A query named something like qry_bt25_albums_by_numtracks is in the music_btMMDD.mdb database. Pass Mandatory Criteria Open the query in Design View. The query includes the tbl_Albums table. Pass Optional Criteria The query displays only the NumTracks, AlbumTitle and AlbumYear from tbl_Albums. Pass Optional Criteria The query restricts only on NumTracks. Pass Optional Criteria The records returned by the query are sorted on both of the following fields: NumTracks in descending order and AlbumTitle in ascending order. FAIL:You did not sort by these tracks. Optional Criteria The records returned by the query are sorted first by NumTracks. Fail: You did not sort by these tracks. Mandatory Criteria Run this query. No errors are returned. There are 20 records listed, including the album titled No! ; no albums with 15 or fewer tracks are listed. Pass 4. Construct a query that prompts for
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This test prep was uploaded on 03/19/2008 for the course CSE 101 taught by Professor Allusethis during the Spring '08 term at Michigan State University.

Page1 / 2

bt2.5 - 3. Write a query that will list the albums in the...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online