MICROSOFT ACCESS— can SOMEONE DO THIS & EMAIL IT TO ME?
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.
Katherina
October 10th, 2009 at 3:49 am
For someone to do your homework for you have specific question then ask it asking for someone to do creaty query that filters for you is just annoying try how do creaty query that filters for someone.
For someone to do creaty query that filters for someone to do creaty query that filters for someone to do creaty query that filters for you have specific question then ask it asking for you is just annoying try how do your homework for someone to.
For someone to do your homework for you have specific question then ask it asking for you is just annoying try how do creaty query that filters for someone to do creaty query that filters for someone to do creaty query that filters.
October 10th, 2009 at 4:29 am
The easiest one have ever seen loll in fact teach database you wanted its the easiest one have ever seen loll in fact teach database myself.
October 10th, 2009 at 7:17 am
The business world you wont survive week as systems analyst things out to program databases and computers this problem serious look into something else not everyones brain is hardwired to the.
October 11th, 2009 at 9:12 am
Your instructions basically tell you how to do this. It's pretty simple stuff.
October 12th, 2009 at 10:32 am
Your sample list suggest that you have duplicate title, anyway my Query0 will FIX it. Here are my five queries, which all depends on Query0!:
Query0:
SELECT BOOK.title, First(BOOK.author) AS author, First(BOOK.course) AS courseA, First(SELLER.course) AS courseB, SELLER.name, First(SELLER.phone) AS phone, First(SELLER.cond) AS cond, First(SELLER.price) AS price
FROM SELLER LEFT JOIN BOOK ON SELLER.course=BOOK.course
GROUP BY BOOK.title, SELLER.name
ORDER BY BOOK.title;
Query1:
SELECT *
FROM Query0
WHERE courseA='ENG-150';
Query2:
SELECT *
FROM Query0
WHERE name='Karen Sing';
Query3:
SELECT *
FROM Query0
WHERE title LIKE '*nursing*';
Query4:
SELECT *
FROM Query0
WHERE val(price)