COURSE
DESCRIPTION FOR
CREATE AND NORMALIZE A DATABASE FROM EXCEL DATA USING ACCESS
Master database design techniques, principles and features
of Access to design and create an Access database to hold data from an Excel
worksheet. The class is instructor-led with lots of hands-on practical life
activities. You can also bring your own Excel worksheet to create a database
from. Learn to:
- Identify data in a worksheet appropriate for inclusion
in a database and create a preliminary list of tables and fields.
- Normalize data by identifying data problems and create
a draft database diagram.
- Identify key fields and table relationships by examining
sample data.
- Import Excel data to Access and create tables by using
the Table Analyzer.
- Create queries and a form to combine and view the data
in table with a one-to-many relationship by designing queries and using
the Form Wizard.
LENGTH
One four hour session.
PREREQUISITES
Access 97 or Access 2000 - Level 1
and Excel 97 or Excel 2000 - Level 1 or equivalent knowledge. You
also need a good understanding of basic Microsoft Windows, file management
and personal computers.
SPECIFIC CLASS CONTENT
Lab Activity 1: Know the data
Why a database?
Examine the worksheet
Draft the database design
Lab Activity 2: Normalize the data
Look for repeating groups of data
Look for repeated values
Draft the database diagram
Lab Activity 3: Identify key fields and table relationships
Identify primary keys
Add foreign keys
Analyze table relationships
Lab Activity 4: Import the data and finish the database
design
Import the data
Start the Table Analyzer
Compare the databases
Refine the table design
Lab Activity 5: Build queries and a form
Query the order information
Query the details and calculate item totals
Create the form
Enhance the appearance of the form
NECESSARY SOFTWARE AND HARDWARE
- Excel 97 or Excel 2000 and Access 97 or Access.
- A printer (optional).
OTHER ACCESS CLASSES
- Access 2000 - Advanced. Create
advanced queries, work with macros, and design forms and reports.
- Mini Power Sessions:
--Analyze Your Product And Sales Data Using Access
--Customize Your Reports Using Access
--Manage, Plan And Analyze Your Inventory Using Access
--Produce Letters, Lists And Catalogues Using Access And Word
| 