Quiz Answer Key and Fun Facts
1. During his many years in the disco scene, Disco Stu has compiled a large database of lovely ladies who have captured Disco Stu's attention while Disco Stu does his thing. This quiz will walk the quiztaker through some of the Microsoft Access features Disco Stu uses to set up Disco Stu's friends - in this case a disco novice named Ned Flanders - with prospective dates. (For those of you unfamiliar with the "Simpsons" character Disco Stu: Disco Stu always refers to himself in the third person, and Disco Stu rarely uses pronouns. Also, for those of you put off by the phrase "lovely ladies", rest assured that Disco Stu considers all ladies lovely. Finally, for those of you not familiar with Ned Flanders, just picture Ward Cleaver without the charisma.)
The most important part of Disco Stu's Date Database is a table, which we will call Tbl-Ladies. This table contains the basic information about each of these prospective companions for Flanders. Each lady is represented by one record in the database, and individual pieces of information about each of these lovely ladies is stored in a field. Every lady in this table will be represented by the same fields; if Disco Stu does not have all the information for a lady, then that field will be blank. There are a number of different data types in Access, including Text, Number, and Date/Time. Which of these would least likely be a text field in Tbl-Ladies?
2. Disco Stu's Date Database is all about relationships. However, before Disco Stu can create relationships between groovy people, Disco Stu will have to create relationships between groovy tables. For example, since people need variety, Disco Stu's Date Database will also have tables for all the Discos in Springfield, like Tbl-Stu's Disco and Tbl-Moe's Disco. To relate tables, Disco Stu must sort each table by the same field, known as the primary key. This field must be unique for every record. Which of these fields in Tbl-Ladies would make the best primary key? (Remember: it should be UNIQUE.)
3. Now Disco Stu has sorted TBL-Ladies in Disco Stu's Date Database. This was a very important step in the process; once the order of a table has been established, it can only be changed by rebuilding the whole thing from scratch.
4. Disco Stu has ordered the tables in Disco Stu's Date Database, but there are still a few ladies whose information should be entered into the database's tables before Disco Stu tries to line up a date for Flanders. To do this, Disco Stu will use a groovy form that, like his groovy tables, is also part of Disco Stu's Date Database. Which of these is not true of forms in Microsoft Access (as they relate to Disco Stu)?
5. Queries are powerful tools for working with databases, and Microsoft Access features several different types of these beauties. If Disco Stu wants the names and cell numbers of all the ladies in Disco Stu's Date Database who have been to both Stu's Disco and Moe's Disco in the last month (these ladies really like to disco!), what kind of query should Disco Stu use?
6. While browsing TBL-Ladies, Disco Stu notices that, in his disco dabblings, he has collected some of these ladies' information several times. In fact, Disco Stu has typed in the data for one Mindy Simmons on 27 occasions. What kind of query can Disco Stu use to get himself out of this jam?
7. What the Disco Inferno? It seems that Springfield's intrepid Mayor Quimby, in a fit of local boosterism, has renamed a stretch of Gum Tree Street after a local celebrity. This means that a row of townhouses known to be inhabited by a horde of lovely ladies who choose to reside closest to Springfield's Disco District will now be located on Troy McClure Way. This calls for a big change in Disco Stu's Date Database. What is the most appropriate Microsoft Access tool for this mass transformation?
8. So now Disco Stu is working on a report for Flanders based on his query of the tables in his database; after that, Disco Stu can only hope. Since Disco Stu is so cool, he wants this report to look gooooood. What feature does Access NOT offer that can help Disco Stu with his report?
9. Disco Stu has been very mindful of database conventions in creating his Date Database; these conventions include using at least two fields for each lovely lady's name (FirstName and LastName) and using numeric dates. These allow for easy sorting of the database, but can be difficult to read if Disco Stu prints them on a report in these formats. Not to worry - MS Access has several features that can render Disco Stu's efficient data into groovy reading. Which of these is not a feature that Disco Stu can use to sweeten how others see his data, regardless of how Disco Stu was doing his input thing?
10. Finally, Disco Stu is ready to present his results to Flanders. Something of an Access guru himself, Flanders asks to see Disco Stu's database, and the erstwhile matchmaker complies: "Disco Stu has nothing to hide."
"Boy, that's a gosh-diddly great setup you have there, Disco Stu," says Flanders. "Can I tweak it for you just a guldarn bit?" After sorting out the possible unsavory aspects of Flanders' "tweaking", Disco Stu acquiesces. Flanders sits down and opens the SQL Server window on Disco Stu's computer. Three hours later, with Flanders still at it, Disco Stu resigns himself to the fact that Flanders is not Lovely Disco Lady material: "I knew I should have disco ducked this assignment." What does SQL stand for?
Source: Author
stuthehistoryguy
This quiz was reviewed by FunTrivia editor
crisw before going online.
Any errors found in FunTrivia content are routinely corrected through our feedback system.
