Day 19
Introduction to
Microsoft Access 2000
Lesson:
Creating a table.
Define fields
On pages A 1.13, we see how to create a table.
From within the database, click on “create a table in Design view.”
Now give the field names and define them so that you can later key in the data, which will go there.
Key in the data type, which will tell Access what kind of data will go there, numbers, currency, or letters.
Now a description may be entered for that field.
To Define fields by specifying the required details in the table window. As seen on page A 1.15.
Construction of the class session
|
10 to 20 minute – Project 1 |
|
70 minutes - Project 1 lab work Students work on Projects, raising their hands when they have a question.
|
|
10 minute Break |
|
10 minute Mini - lesson, when needed |
|
70 minutes - Project 1 lab work Students work on Projects, raising their hands when they have a question.
All projects are due by the test day. |
Lab Work:
Project 1
Problem 1 on page A 1.55-6, Problem 1 on page A 1.57-8, problem 2 on page A1.59 and the first three Cases and Places.
You will need the document:
SideWalk Scrapers , click here to download it now.
All projects must be either e-mail to me at
or
given to me directly by the test day (Day 9)
