AccessLab_Intro_JC - Instructions for Access Lab Session...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Instructions for Access Lab Session: Intro to Access At the end of this session you should be able to: Analyze relationships in a database Create relationships in a database Import data from an Excel file Create a new table and add records to a table Perform simple queries Back- up and Compact and Repair a database Instructions: Navigate to the “in-class lab pages” folder in webcourses and save “database_AccessIntroLab” to the desktop. Also download the ZipCodesReferenceTable to the desktop. REA Conceptual Model for this database Item Sales Order Employee Customer Zipcode Resource Event Agent Agent Reference Get to know your Database!!! This database is designed to take customer orders The tables in the DB will include one event table, three agent tables, one resourcetable, one linking/relationship table, and one typification table, which we will import. Identify each of thesetables in the DB. Open each of the tables using the open button (or double-click on the table name)and look at the data. The look at the field names in “design” view. Closeall tables before the next step. Import Data for Zipcode Reference Table In Access click on the ‘external data’ tab On the import section of the MS Access ribbon, click on the Excel icon. Click browse and select the ZipcodeReferenceTable.xls file. Select “Import the source data into a new table in the current database”. Click OK Select “First row contains column headings”. Use the default selections and click next. Select “chosemy own primary key” and choose “zip” Rename ”tblZipcodes” and click finish. af73eca6fbca4ab9a3d1ecbe873a623a78f40544.doc page 1 of 6
Image of page 1

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

View Full Document Right Arrow Icon
Create the relationships 1. Under DatabaseTools//Click on the “relationships” button No relationships have been set in the DB. 2. To show the zipcode table, click on the “Show table” button at the top. 3. Add the zipcode table to the relationship screen and organize the agents, resources and typification tables around the event. 4. Place the zipcode table on the far right. 5. Identify the primary keys and foreign keys of each table. 6. There are four FK’s posted. Identify which table is the relationship table. 7. Set the relationship between the tblSalesperson and tblOrder by clicking and dragging from the primary key to the foreign key (From EmployeeID (PK) to EmployeeID(FK) When the dialog box comes up select the “check” box—“Enforce Referential Integrity.” Set the relationships between all the tables.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern