Mgt 4322 - Home   Spring 2010   Email to Dr. Lyons     PatLyons Home
[ Calendar10:10 | PortWebsite | StuWebs  | Port1 | 2 | 3 | 4 | 5 | 6 | Showcase | Presentation ]
[ Ch 1 || 3 || 5 || 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 || AppDatabase | Ex1 || 3 | 4 | 5 | 6 | 7 ]
[ HW 1| 2 | 3 | 4 |
| Career1| 2 | 3 ] [
SJU | TCB | CareerCtr | StuInfo | CareerLinks ] [ SJU Closing ] [H1N1SelfAssessment]


Database Exercise 5 - Create Personnel File

  1. Open the Microsoft Access database that you created in Database Exercise 2.

    1. To do this, open Microsoft Access, click File Menu, Open... .

    2. In the Open window, click on folders until you come to your port folder that you created for the Portfolio Exercise 1.

    3. Then, double click on AppMIS.mdb.  This is the database you created in Database Exercise 2.
       

  2. Create the design for your Personnel File.

    1. For Access 2003, in the Database window, click Tables, and double click Create table in Design view.  See the first screen image in Database Exercise 2.
      For Access 2007, click the Create tab on the Ribbon, then click Table in the Tables group.

    2. In the Table1: Table window, enter the Field Name, Data Type, and Description for the Personnel File that you specified in Database Exercise 1.
      For integers, use Long Integer, decimals, use Double, and character data, use text with size < 30.
      Note: you are to have at least 4 fields in your Personnel File.
      See the first screen image in Database Exercise 2.

    3. Specify the key field for your Personnel File.  In my Associate File, the key field is AssociateID.  To do this for your Personnel File, click on the field that you wish to be the key field.  Then, click on the key icon in the Table Design menu above the Table window.  The Table Design menu only appears when the Table Design window is the active window.
      The key field for your Personnel File must be a long integer and have the same name as in the Transaction File.

    4. Save the table by clicking on the Save (diskette) icon.
       

  3. Create the data in your Personnel File.

    1. To do this, continue with your opened AppMIS.mdb database.

    2. In the Database window, click Tables, and double click your Personnel File name.  Your Personnel File will open in the Datasheet view.  See the second screen image in Database Exercise 2.

    3. In your Table window, enter the data for your Personnel File.
      Note: you are to have exactly 5 records in your Personnel File.
      Personnel ID values must be consistent with Transaction File.
       

    4. Compact (and Repair) your database.  See Database Exercise 2, Step 3.d.  This will make your AppMIS.mdb as small as possible.
       

  4. Use Microsoft Internet Explorer with ftp://stupub.stjohns.edu/ to drag and drop your modified copy of the entire port folder from your Mgt4322 folder to your stupub website.  This will copy your updated database, AppMIS.mdb.  Follow the instructions of Portfolio Exercise 1, step 5.

    1. If not all the files copy over to stupub, try dragging and dropping AppMIS.mdb by itself.  See Database Exercise 3, Step 3.
       

  5. Print the Datasheet view of your Personnel File using landscape orientation.
    To do this, in the Database window, click Tables, and double click your Personnel File.  Click the File Menu, then Print..., and OK.  Change the Page Orientation to Landscape in the Page Setup window in order to print the file on one page.
     

  6. Requirements - see Homework Set IV
                                               (This page was last edited on January 18, 2010 .)