Recitation01v02_for Access 2007

Recitation01v02_for Access 2007 - ORIE 3120 Industrial Data...

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

View Full Document Right Arrow Icon
1 1/26/2010 ORIE 3120 Industrial Data and Systems Analysis Recitation 1 Relational Database Concepts Peter Jackson Edited for Access 2007 by Chao Ding Basic Concepts 1. Your teaching assistant will explain or review the following concepts: Table (data presented in rows and columns) Database table (data presented in rows using fixed, pre-specified columns) Fields (columns of a database table, with pre-specified attributes) Records (rows of data in a database table) Data types (typical field types: text, integer, Boolean, single-precision, double-precision, etc.) Key (collection of fields that uniquely define a record) Getting Started 1. You will turn in this document at the end of recitation to receive credit for attendance. If you are working in teams, list the names and NetID’s of you and all your team members. Name NetID (ex. pj16) 2. Create a directory to store your work. If you use the lab machine, be aware that the directory (and all your work) will disappear when the machine is rebooted. We recommend using a USB flash-drive. 3. Open Microsoft Access (MS Access). It is one of the Microsoft Office collection of programs. 4. Find the version number of the software (Right click MS Office button -> Customize Quick Access Toolbar -> Click “Resources” in Access Options window -> About). Write the version number here: ______________________. Database files written using later versions may not be read by earlier versions of the software. 5. Create a blank database and save it in your directory. Give it a unique name by combining your NetID with the identifier for this recitation: ex. “pj16REC01.accdb.” The file extension for MS Access 2007 database files is “.accdb.” (The file extension for MS Access 2003 is “.mdb”.) 6. Use file explorer to locate the file in your directory. Write down the file name and file size here: File Name File Size (MB) Keep an eye on the file size. As you add data to your database, you will see the file size grow. If you delete data, the file size will not decrease. 7. From the course website, download the following file to your directory: “RawNorthWind.mdb”. This is the sample database Microsoft supplies but with
Background image of page 1

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

View Full Document Right Arrow Icon
2 1/26/2010 everything stripped away except the raw data tables. Download the file “RawNorthWind.xls” to your directory as well. This contains the data from the database copied into a MS Excel file. 8. Return to MS Access. Your T.A. will briefly explain the following sections of your database file: Tables Queries Forms Macros Modules Note that in other database packages these database components may be stored in separate files. In MS Access, they are all stored in a single file. Creating Tables
Background 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 ]}

Page1 / 16

Recitation01v02_for Access 2007 - ORIE 3120 Industrial Data...

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

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