Transcript Access Database for CIS17 - Bristol Community College

Access Database for CIS17
Please use speaker notes for
additional information!
First open Access, when the screen comes
up asking if you want to create a new
database click that you want to create a
Blank Access Database.
Select the
directory/folder
where you want to
save the database
and give it a name.
I called this
database
asgn1.mdb.
Click on create.
Select design to design a
new table.
Notice that tables is selected.
Selecting design brought up
this screen where we can
design the file/table within
the database asgn1.mdb.
Notice that at this point, the
table does not have a name.
It will be named when you
save the design.
I have now entered the first field
which is called isbn. Notice that
it is a text field and that I made
the field size 13 which will hold
the largest ISBN number that I
have.
Now I have entered the next
field which I am naming
title. It is also a text field
and I decided that 35 was
big enough to hold the titles
I was entering.
I made the year field a number and
specifically an integer. I do not
have to specify the number of
characters because integer has a
specific number of characters.
Before I leave, I establish a
key for the record - isbn is my
key. To do this I click on isbn
and then click on the key
icon.
When you try to close this screen, it asks if you
want to save and then prompts you for a table
name. I entered booklist and clicked OK.
I now have a table in
my database.
When I clicked on the
booklist table, this screen
came up for me to do data
entry.
Now I want to design a query.
Notice that I have high lighed
Queries and now I will click on
design.
The query screen comes up
and shows the tables I have
available to query. The
only one that I have is
booklist, so I will click on
add.
I can double click on
each of the fields in
booklist that I want to
see in my query and
they will move to the
line below. In this
case, I decided to see
all of the fields so I
double clicked on
them all.
When I
click on
the view
icon, I
will see
the
selected
records.
I can click
on the
design
icon to go
back into
design
mode.
The intersetion of Criteria: and
topic is where I am entering
my criteria. I want all records
where the topic is equal to
Oracle.