MICROSOFT ACCESS--- can SOMEONE DO THIS & EMAIL IT TO ME?

Question

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.

Answer 1

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)<20;

Query5:
SELECT *
FROM Query0
WHERE cond='E';

the mdb file will send to your email.

Answer 2

If you can't do this, you should seriously consider another vocation besides databases and computers.

This is easy, no brainer stuff. You get out to the business world you won't survive a week as a Systems Analyst. Things out here are much more complex than this problem!

Serious, look into something else. Not everyone's brain is hardwired to program databases.

Answer 3

Sorry I don't do e-mails but read what sort of database you wanted it’s the easiest one I have ever seen loll in fact I teach database myself

Answer 4

If you have a specific question, then ask it. Asking for someone to do your homework for you is just annoying.

Try how do I creaty a query that filters for X?

Answer 5

Your instructions basically tell you how to do this. It's pretty simple stuff.