Create a NEW database in design view with the

Document Sample
Create a NEW database in design view with the Powered By Docstoc
					Introduction to Computers
May 14, 2008
-----------------------------------------------------------------------

Create a NEW database in design view with the information below and save it as CARDS

 Field Name      Type          Width                        Description
Last           Text                 12   Name of BB player
First          Text                 10   First name of BB player
Team           Text                 12   ML Team
League         Text                  1   National or American
Position       Text                  2   Position played by BB player
Birthday       Date                  8   Players Birthdate
Price          Numeric               6   Price of the card
Cond           Logical               1   Condition of the card

Enter the following information in the database for CARDS in datasheet view.

Record #      Last       First      Team      League   Position   Birthday    Price   Cond.
    1      Hershiser   Orel       Dodgers       N             P    9/16/58     4.25    .T.
    2      Santiago    Benito     Padres        N             C   3/09/65      4.50    .T.
    3      Drabek      Doug       Pirates       N             P   7/25/62       .75    .F.
    4      Pendelton   Terry      Cardinals     N           3B     7/16/69      .25    .F.
    5      Jeffries    Gregory    Mets          N           2B     8/01/67     3.40    .T.
    6      Mcclendon   Lloyd      Reds          N             C     1/11/59    1.50    .T.
    7      Ontiveros   Steve      Athletics     A             P      3/5/61    1.35    .F.
    8      Clark       Dave       Indians       A           Of      9/3/62     1.35    .T.
    9      Thomas      Andres     Indians       A           SS    11/10/63     2.75    .T.
   10      Clark       Jack       Padres        N            1B   11/10/55     2.75    .T.
   11      Nieves      Juan       Brewers       A             P      1/5/65    4.50    .T.
   12      Hubbard     Glenn      Athletics     A           2B    9/25/57       .60    .F.
   13      Gooden      Dwight     Mets          N             P   11/16/64     1.86    .T.
   14      Lynn        Fred       Tigers        A            LF     2/3/52     1.40    .F.
   15      Harris      Greg       Reds          N             P     11.2/55     .45    .F.

Save the database and close.