I'VE FIGURED EVERY OTHER THING OUT EXCEPT FOR THIS!!!!
I'M GOING NUT'S with this part of a project can SOMEONE DO THIS AND EMAIL IT TO ME. PLEASE:
You will create an Access database named “SGA USED BOOKS”. Within the database you will create two tables named “BOOK” and “SELLER”. Select appropriate data type and length for each field.
BOOK has the fields TITLE, AUTHOR, and COURSE.
SELLER has the fields NAME, PHONE, COND, PRICE, and COURSE. **COND is a field which lists condition of the book. E is for excellent, G is for good, and P is for poor.
Choose an appropriate field and an appropriate join type, then create a relation between BOOK and SELLER.
Enter the following data into the appropriate tables. **There should be no duplicate book titles in BOOK.
TITLEAUTHORCOURSEPRICENAMEPHONECOND
Sociology TodayMunroeSOC-101 $ 14.00 Joe Van555-7632G
Creative WritingSwan & ShellENG-150 $ 18.00 Mary Nordman555-9421E
Reach for the StarsAlvarezAST-210 $ 2.00 John Mott555-9981E
Creative WritingSwan & ShellENG-150 $ 15.00 Peter Rudd555-9156E
Ethics for Today's SocietyGarrison & PiercePHI-310 $ 20.00 Sandi Radle555-7636P
Sociology TodayMunroeSOC-101 $ 17.00 Daniel Lewis555-0873E
Understanding PsychologyNavaronePSY-101 $ 22.00 Karen Sing555-9802P
Electronic CircuitryCarlsonEGR-255 $ 37.00 Karen Sing555-9802G
Nutrition for Our SoulsFrancisNRS-330 $ 18.00 Dave Corsi555-2384E
Geriatric NursingDyerNRS-265 $ 36.00 Mary Healy555-9920E
Enter your own name and book for this course, CSC-138 in both tables.
Create 5 queries to list TITLE, COURSE, PRICE, NAME, PHONE, & COND.
Apply the following criteria:
all ENG-150 books. Call it query1 and save it.
all books which Karen Sing has listed. Call it query2 and save it.
all books about nursing. Call it query3 and save it.
all books listed for less than $20. Call it query4 and save it.
all books in excellent condition. Call it query5 and save it.
2006-12-04
06:57:53
·
5 answers
·
asked by
xxswt_gurlxx
2