Access%20Class%20Demonstration%20Instructions

Access%20Class%20Demonstration%20Instructions - ACCOUNTING...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ACCOUNTING INFORMATION SYSTEMS Access Class Demonstration Purpose of the Exercise The purpose of the exercise is to provide an introduction to Access database design. In particular, tables will be created and modified, relationships will be established, and queries will be designed. Open the Database, Create and Modify Tables 1. Start the Access program by clicking Start/Programs/Microsoft Access . In the Window that appears to the right, click New/Blank Database . Name your database “Lab Exercise.db1” and click Create . Click on Tables in the Object list to the left of the screen. Double-click Create tables by entering data . 2. Create the Customers, Widget Orders, and Employees tables below by keying the data directly or by importing the data from an Excel worksheet (preferred). Name the attributes (columns) by double-clicking the column headings (Field1…Field2… Field3…etc.) and entering the attribute names. Customers: Widget Orders: Employees: 3. Close any tables that are open. Open the relationships window and create relationships between Customers and Widget Orders and Employees and Widget Orders. Enforce referential integrity? What problem exists? How can it be corrected? Customer Number Customer Name Region 100 Jacob Texas 101 Johnson Oklahoma 102 Linea Oklahoma 103 Marks Texas 104 Smith Texas 105 Wiggum Louisiana 106 Jonas New Mexico Order Number Customer Number Employee ID
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/02/2010 for the course ACCT 5457 taught by Professor Polm during the Fall '10 term at Rensselaer Polytechnic Institute.

Page1 / 2

Access%20Class%20Demonstration%20Instructions - ACCOUNTING...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online