ࡱ>  Root Entry( Jr@=.MatOST ޙ.@=.MMMN0 ND ( JrMicrosoft Works MSWorksWPDoc9qCompObjUHO } N R {wswsw{%qs0xqqkk]]]]]]      H$xzr|Z\')8R`w Z   J L N P R R x R Times New Roman ArialSPR   =/d P t T Authors Database Directions: Use your database program and the file called authors. Read the scenario. 1. Read and re-read each question. 2. Use the database file to respond to the questions below. 3. When asked to "describe the steps you took to find your answer," use appropriate database terms (for example, "Sorted the died field in ascending order" or Searched the award year 1 field for all records greater than 1969") Scenario: You have been given a database with over 200 authors displaying a variety of criteria. Your job is to find the most efficient way to answer the questions below in a fifteen-minute period. 1. Who is the author of Richmond COUNTY? ___________________ 2. How many authors of more than one genre (NUMBER OF GENRE) are from Wake COUNTY? ________ Explain: ______________________________________________________________________ 3. How many one-genre (NUMBER OF GENRE) Coastal (REGION) authors are poets (GENRE 1)? _________ 4. Of the one-genre (NUMBER OF GENRE) authors classified as editor/publisher (GENRE 1), which region was the home to most of them? ______________ Explain: ______________________________________________________________________ Did you complete questions 1-4 in 15 minutes? 5. Close the database file called authors, and open the database file called metals DBSHORT.mdb. a. Use a reference book or electronic database to find the correct information to replace the question marks. b. Edit your database to add the new records listed below. (Click on INSERT, NEW RECORD.) 14 15 16 Tungsten Uranium Zinc 74 92 30 183.85 238.02 65.38 silver white yellow bluish white solid solid solid 6. Modify your database by adding a new field called Atomic Symbol between Metal and Atomic Number. (Click on the design view tool below file in the upper left-hand corner of your screen. Click in the left margin of the table and highlight the field that will appear below the new field. Click on insert, and row. Type Atomic Symbol at the cursor. Data type should be made text. In the description field, type Initials used to identify the metal elements. In the general tab at the bottom, type 5 for field size and it should be indexed. Save and click on the data view tool on the tool bar 7. Adjust the field widths so that you can read all of the field names completely. 8. Use a reference book to find the atomic symbols that match each metal in the database. Type them in the correct cells. 9. Make sure you include your name and grade level. Save and print. 10. Submit the assignment to your instructor. HO } N R {wswsw{%qs0xqqkk]]]]]]      H$xzr|Z\')8R`w Z   J L N P R R x R Times New Roman Arial =/=/d