View Full Version : DataBases
hehe... this is officially my last thread in this section :o
i need help with microsoft access
this is such a dumb class ... the instructions are on powerpoint and absolutely no demonstration on actually how to use access :torture:
:banghead:
At the end of this assignment, there are 4 tables.
(1) In Access, create the 4 tables, enter the relationships and populate the tables with the data shown at the end of this assignment.
Deliverable
A screen print of the relationships among the tables.
(2) Develop a query to get S# values for suppliers who supply a London or Paris project with a red part.
Deliverables
A screen print of the Design Query screen
(Pressing the Print Screen key puts a copy of the screen on the Clipboard. You can then paste from the Clipboard into your Word answer document)
A copy of the Access generated SQL code
(You can select the code and copy it to the Clipboard. You can then paste from the Clipboard into your Word answer document)
A screen print of the query results
(3) Develop a query to get J# values for projects not supplied with any red part by any London supplier.
Deliverables
A screen print of the Design Query screen
A copy of the Access generated SQL code
A screen print of the query results
(4) Develop a query to get S# values for suppliers supplying at least one part supplied by at least one supplier who supplies at least one red part.
Deliverables
A screen print of the Design Query screen
A copy of the Access generated SQL code
A screen print of the query results
SUPPLIER
S# SNAME STATUS CITY
S1 Smith 20 London
S2 Jones 10 Paris
S3 Blake 30 Paris
S4 Clark 20 London
S5 Adams 30 Athens
PART
P# PNAME COLOR WEIGHT CITY
P1 Nut Red 12 London
P2 Bolt Green 17 Paris
P3 Screw Blue 17 Rome
P4 Screw Red 14 London
P5 Cam Blue 12 Paris
P6 Cog Red 19 London
JOB
J# JNAME CITY
J1 Sorter Paris
J2 Punch Rome
J3 Reader Athens
J4 Console Athens
J5 Collator London
J6 Terminal Oslo
J7 Tape London
SUPPLIER-PART-JOB
S# P# J# QTY
S1 P1 J1 200
S1 P1 J4 700
S2 P3 J1 400
S2 P3 J2 200
S2 P3 J3 200
S2 P3 J4 500
S2 P3 J5 600
S2 P3 J6 400
S2 P3 J7 800
S2 P5 J2 100
S3 P3 J1 200
S3 P4 J2 500
S4 P6 J3 300
S4 P6 J7 300
S5 P2 J2 200
S5 P2 J4 100
S5 P5 J5 500
S5 P5 J7 100
S5 P6 J2 200
S5 P1 J4 1000
S5 P3 J4 1200
S5 P4 J4 800
S5 P5 J4 400
S5 P6 J4 500
Love&Peace
02-04-08, 04:46 PM
http://www.bcschools.net/staff/AccessHelp.htm
Hi Gucci,
This is the turorial for MS- Access. You can ask if you have some specific issue. I have not worked on access but together we will be able to solve th issues I guess.
Love&Peace
02-04-08, 04:47 PM
Ok I just saw ur problem
http://www.bcschools.net/staff/AccessHelp.htm
Hi Gucci,
This is the turorial for MS- Access. You can ask if you have some specific issue. I have not worked on access but together we will be able to solve th issues I guess.
do they have that for 2007? why am i stuck with 2007 :banghead:
okay so from the prof's instructions i got this done:
Start Access
To create a new database, from the opening screen, select the Blank (Access) Database option
From the dialog box, name the database and specify where it is to be stored
From the Database window, click on the Tables button, then double click on Create table in Design view
i have nooo idea wat hes talking about wen he says this:
Enter the field names, their data types and their descriptions. In the Field Properties section of the window, adjust the default field sizes to reasonable values
Click in the row that contains the primary key field and click on the primary key icon on the toolbar
Save the table and give it a name
Love&Peace
02-04-08, 04:53 PM
I am downloading access trial...will come back in 5 mins
SUPPLIER
S# SNAME STATUS CITY
S1 Smith 20 London
S2 Jones 10 Paris
S3 Blake 30 Paris
S4 Clark 20 London
S5 Adams 30 Athens
Now see SNAME is a field name
Data type for SNAME will be string/character or something similar
Description can be 'Name of the supplier'
By primary key, it means something Unique to a particular record, U can see two supplier can have same name or belong to same City. For differentiating them, they need something Unique. So S# is the primary key. Got it?
oh i figured out that part :smack:
that link u gave is really helpful :o
L&P i have class now so i gotta run
Love&Peace
02-04-08, 05:02 PM
Ok Gucci,
Hope the link is helpful. Wish u all the best.
I will not be available in evening or whole day tomorrow.
I will online again on Friday afternoon. I am really sorry for this.
Ok Gucci,
Hope the link is helpful. Wish u all the best.
I will not be available in evening or whole day tomorrow.
I will online again on Friday afternoon. I am really sorry for this.
thats all right lol. take care :love:
for the SUPPLIER-PART-JOB table some of the numbers repeat (S1, S1...) in the columns and its not letting me do it and i dono wat to dooooo :(
for the SUPPLIER-PART-JOB table some of the numbers repeat (S1, S1...) in the columns and its not letting me do it and i dono wat to dooooo :(
It sounds like maybe you made S# the primary key for that table?
You don't need a primary key for that particular table.
It sounds like maybe you made S# the primary key for that table?
You don't need a primary key for that particular table.
ohhhhhh :o thanx
ah jeeez..... 1.5 hours later i finally find out wats wrong with it and its just the dumb key :(
ohhhhhh :o thanx
ah jeeez..... 1.5 hours later i finally find out wats wrong with it and its just the dumb key :(
Sorry, I'm not online as much now because of a new project. Otherwise I would have said that a couple of hours ago. :o
Sorry, I'm not online as much now because of a new project. Otherwise I would have said that a couple of hours ago. :o
Naw thats not why :o
just frustrated cuz i must have clicked every button on that thing and i couldnt figure it out :torture:
whoo hoo i finished the database question :hidban: :D
whoo hoo i finished the database question :hidban: :D
Good for you!
And we're only on page 2 of the thread! ;)
Good for you!
And we're only on page 2 of the thread! ;)
:eek: thats where i get to correct you Mace, its still page 1 :hidban:
:eek: thats where i get to correct you Mace, its still page 1 :hidban:
Oh, you're right. I set my preferences to few posts per page because of my phone. So for me this is page 2. But for everyone else I guess it's page 1.
Love&Peace
03-04-08, 03:03 PM
Gucci,
U picked up access quickly :hidban:
lol im surprised, maybe i did it all wrong :rotfl:
lol im surprised, maybe i did it all wrong :rotfl:
No, it sounds like you did well. I've seen a lot of people struggle a bit with the primary and foreign key concepts early on.
See all that work in VB has made this kind of stuff relatively easy for you. :)
It's like you ran a 5k race and now they're just asking you do to a 1k walk. :up:
vBulletin® v3.7.4, Copyright ©2000-2008, Jelsoft Enterprises Ltd.