EIN3118-01: Fall 2005

Computing Topics in Industrial & Manufacturing Engineering

 return to home
 		 
course homepage

11-21-05:
Access in Engineering Solutions

  

overview
objectives
outline
readings
practice problems

upOverview

 For experienced database programmers and first-time database users alike, Microsoft Access version 2002 delivers powerful tools for managing and analyzing data. With XML support, developers can create sophisticated enterprise-wide database solutions that integrate easily with the Web. New users will find comprehensive tools that make building databases more intuitive.

upObjectives

This class session is intended to get you familiar with the advanced functions of Access databases.

upOutline
  • Creating a new database
  • Creating a table
    • Table wizard
    • Primary key
    • Input mask
    • field properties
    • Validation rule
    • Datasheet view
  • Creating a form
    • Form wizard
    • Adding calculations
    • Property sheet
    • Form header
    • Form view

upReading

You will need to read your book carefully for this session. The best way to learn how to work with databases is to practice.

Helpful Tutorial
Access tutorial

upPractice Problems

The best practice you can do for this lecture is to practice. You will need to spend several hours exploring the Access application.

Site Design and Development by John R. Braswell
Email: jbraswel@eng.fsu.edu
©2004 College of Engineering in the Department of Industrial & Manufacturing Engineering for the Florida State University and Florida A&M University