CIS17
- Problems:
I
am going to create a table in an Access database that contains information
about the books that I have on software and programming.
The
layout of the file is:
ISBN # of Book
Title of Book
Primary Author of Book
Topic
Year Published
Here
are a couple of records that I have on the file. First I have to determine the data types for each field and the
length of the fields.
|
ISBN
# |
Title |
Primary
Author |
Topic |
Year
Published |
|
0-619-03440-8 |
CGI/Perl |
Zak,
Diane |
CGI/Perl |
2002 |
|
0-13-100277-5 |
Oracle SQL |
Rischert, Alice |
Oracle |
2003 |
|
0-619-03520-X |
Cascading
Style Sheets |
Sklar,
Joel |
CSS |
2001 |
|
1-5927-3000-0 |
Developing
Online Games |
Mulligan,
Jessica |
Games |
2003 |
|
0-201-74205-5 |
Visual
Basic.Net for Students |
Bell,
Douglas |
VB.NET |
2003 |
|
0-619-06475-7 |
Oracle
9i: SQL |
Morris-Murphy,
Lannes |
Oracle |
2003 |
In
class, we are going to create this table in Access and then populate the table
with the data above, so we can test it to see what data can be gotten from the
table. If you are not in class, you
should view the Power Point Presentation dealing with this assignment and look
at the Access database called asgn1.mdb.
Distance Learning students should create the table and populate it to
familiarize themselves with Access.
Problem
#1: I need to do a query to list of all
books with their title, primary author and ISBN#. Does this file have the data/information available that would
allow me to do this query? If so, you should do the query. If not, modify the query to something you
can do.
Problem
#2: I need to do a query to list all
books that were published in 2003. Does
this file have the data/information available that would allow me to do this
query? If so, you should do the query. If not, modify the query to something
you can do.
Problem
#3: I need to do a query to list all
books published by Course Technology.
Does this file have the data/information available that would allow me
to do this query? If so, you should do the query. If not, modify the query to something you can do.
Problem
#4: I need to do a query to list all books with their title, edition, and topic
where the topic is CGI/Perl. Does this
file have the data/information available that would allow me to do this query?
If so, you should do the query. If not,
modify the query to something you can do.