How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1208
Experience:  20 years experience providing remote computer support
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

access query

Resolved Question:

Hi are there any access experts out there, I  have created a database need some help with primary keys, also need help with algorithm, will pay bonus
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 2 years ago.
My Name isXXXXX will be helping you toady. If I provide good service, you may ask for The-PC-Guy in your question title for your future needs.

I can help you set up the keys so everything works with queries. As far as creating an algorithim, I don't exactly know how that would be done. Do you have a specific idea for it such as recomending books within a certain price range, or by author, or category?
Customer: replied 2 years ago.
hi there, i thought i would recommend just by genre based on previous sales, shall i send you on the file
Expert:  The-PC-Guy replied 2 years ago.
sure you can go ahead an upload, I just want to be clear on what you want for your query, You will choose customer_id by entry or from a drop down, and it will look at the category or genra field and reccomend other titles in the same genera as the genera that had the most previous orders?
Customer: replied 2 years ago.
This is the actual requirement, i just don't know how to do it, the easiest way, the brief says " your project should be able to recommend books to the user" You are free to model this which way you choose.
a possible choice would be "people that bought this book, also liked or purchased"

The left or Right joins could be a way of implementing this, thanks

http://wikisend.com/download/433684/Database9.laccdb
Expert:  The-PC-Guy replied 2 years ago.
ok, ill take a look
Customer: replied 2 years ago.
ok thanks, XXXXX XXXXX to edit anything that you don't this is necessary, it just has to be simple, i
Expert:  The-PC-Guy replied 2 years ago.
it will be simple.
Customer: replied 2 years ago.
for you maybe
Expert:  The-PC-Guy replied 2 years ago.
lol, ok, let me get started, no need to reply, I will post an upload link within the next hour or 2
Expert:  The-PC-Guy replied 2 years ago.
is this a 2010 file? can you do me a favor and save as a 2007 file and re upload?
Expert:  The-PC-Guy replied 2 years ago.
Hi, I am unable to open the file
Customer: replied 2 years ago.
how else can i send it
Expert:  The-PC-Guy replied 2 years ago.
open the db in your access, and then goto the office button and chose save as, one of the options is to save as access 2007, give it a different name so you know which file is which and upload the access 2007 file to wikisend and give me that link

hopefully I can then open it.
Customer: replied 2 years ago.
have re-sent it to you should work now http://wikisend.com/download/560210/myassignment.accdb
Expert:  The-PC-Guy replied 2 years ago.
ok, it opens now, will get back to you soon
Customer: replied 2 years ago.
k
Expert:  The-PC-Guy replied 2 years ago.
working on it now, no need to reply.
Expert:  The-PC-Guy replied 2 years ago.
hi, i just wan't to update you as to where I am at. I cerated the relationships, primary, 2ndary keys, etcc.. I am having a little bit of trouble getting the reccomend query to work just right. The problem is that access makes everything way more dificult than it should be. Anyway I am going away for the rest of the night. I will work on it again tomarrow
Customer: replied 2 years ago.
great thanks
Expert:  The-PC-Guy replied 2 years ago.
np
Customer: replied 2 years ago.
Hi how is it going?
Expert:  The-PC-Guy replied 2 years ago.
Here is what I have so far.

http://www.mediafire.com/?o89wpgrbgx5ntzh

the primary and secondary keys are there. I am having some trouble creating the book recommend thing. Access just makes this process so difficult, if it were in PHP/Mysql I would have had it done in 5 minutes.

You will see a few queries a report and macro. I was trying to have the user select a category from a drop down box and it would then update the report based on that selection, and recommend other books from the same category. Maybe you can use what I did so far along with any textbooks you have to get it finished.

I wish I could have gotten it to work but I can't
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1208
Experience: 20 years experience providing remote computer support
The-PC-Guy and 8 other Microsoft Office Specialists are ready to help you
Customer: replied 2 years ago.
you could put a query in mysql and i could use that as a screen shot and i will give you more for that, have put 20 in your account will put another 20 in
Expert:  The-PC-Guy replied 2 years ago.
i can certainly give you the sql to do it, but it requires 2 queries, the first query will give a book id and the sencond query will use that book id to get a list of books to reccomend.

If you think you could set something up like that in access using access sql, I will give you both sql queries in standard sql language
Customer: replied 2 years ago.
ok thanks for your help will try that. if you could send them on to me, i should be able to save the db as a text file and load it into sql and do the queries, i will give it a try. Are you any good at ERD diagrams? you know the ones that show the cardinality that will be a separate question of course.

i will ask it in another question, and even if you can't do it, i will add the rest of bonus as promised as you have been helpful to me, i have got till next thursday to get all of this finished
Expert:  The-PC-Guy replied 2 years ago.
i have to go to an appointment but ill send you a query based on the access tables, query will be in standard SQL.
Customer: replied 2 years ago.
ok great thanks, XXXXX XXXXX see the other question re erd
Expert:  The-PC-Guy replied 2 years ago.
let me work on this query first.
Customer: replied 2 years ago.
can you suggest anyway that i could improve the 2nf and 3nf?,I just made the data up, any suggestions would be gratefully recieved, i will pay you more to fix it up
Expert:  The-PC-Guy replied 2 years ago.
lets close this question and work off the other question, it will be easier that way. But I could suggest a good 3nf stucture.
Customer: replied 2 years ago.
ok thanks,
Customer: replied 2 years ago.
ok shall i send in another fresh question
Expert:  The-PC-Guy replied 2 years ago.
i think your a subscriber right. Well yes I would appreciative a fresh question, my profile is at
http://www.justanswer.com/computer/expert-1expert-2rulethemall/
Customer: replied 2 years ago.
vwill put 50 in a/c tom morning if you re-do it for me
Expert:  The-PC-Guy replied 2 years ago.
ok, im closing this question, no more need to reply
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1208
Experience: 20 years experience providing remote computer support
The-PC-Guy and 8 other Microsoft Office Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    270
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    260
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    120
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    116
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    94
    Bachelor's Degree in Information Technology, Microsoft Certified Professional