Transcript in PowerPoint

This is an
introduction to
Access 2003.
Click on blank
database to
start a new
database.
I saved this database as
whatever.
The slide here actually
shows a later time when I
saved a second database as
testing.mdb.
This shows the
tables and queries
for the database
called testing.
Again this was a
later database I
the of
difference in the
created,Note
the rest
environment. This shows
these slides
tables
deal with
the and queries in a menu
the side.
originalon
database
whatever.mdb.
Now I can
click on
the view
icon to
allow me to
enter
data. Very
similiar to
2007.
I clicked on tables and the on
design view and this came up.
I then layed out a table, called
table1 in the whatever.mdb
database. I will be given the
chance to save as a different
table name.
Note the primary key on idno.
This shows a query. I clicked
on query and then put > 100
under amt so I will see records
that contain an amt > 100.
This shows the
menu and it
also shows the
results of the
query. I brought
up both screens.
Now I am starting to look at the
logic structures of a program.
In the processing, I need to
make a change that will
impact the condition so
eventually I will get a N and
end processing - see examples
If when I ask the condition
question, I get a No then I will
not process.
This processing says that I
will always process once
because I process before I ask
the question. On the previous
slide, I asked the question
When I start, I read the first
record and then I check
to see if the read was
successful or to put it another
way if it is not end of file. If it
I process
WhenisI not
read,
I move and
on toread.
the
next record. Then I check to
see if the read was successful
by asking if NOT EOF.
The read effects this answer.
n
I
increme
nt the
counte
by 1.
When I
reach 5
I will get a
No to
condition
and drop out.
The answer
is 132,430