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 rhess Your Own Question

rhess
rhess, PC Consultant
Category: Microsoft Office
Satisfied Customers: 103
Experience:  I have extensive training in all versions of MS Office
64975016
Type Your Microsoft Office Question Here...
rhess is online now
A new question is answered every 9 seconds

5. Add Referential Integrity to your two tables. Please ensure

Resolved Question:

5. Add Referential Integrity to your two tables. Please ensure that you invoke the following two items
a. Enforce Referential Integrity
b. Cascade update fields
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  rhess replied 2 years ago.

rhess :

Hello?

Customer: Hi I already have the tables built I just need to add the rules can you help with this?
rhess :

yes, i can

rhess :

we can do it 2 ways

rhess :

you can either upload the database here and i will do it for you

rhess :

or i can explain how to do it

Customer: Okay just let me hop onto my computer and I will send you the file, what's your email?
Customer: I would rather you just do it for me
rhess :

no problem

rhess :

i can't give you an e-mail address, but if you go to http://www.wikisend.com, you can upload the file there and then paste the link to the file here

Customer: Okay I will do that please give me about 5 or 10 min
rhess :

sounds good

Customer:

http://wikisend.com/download/123112/Unit_3_MicroSoft Access.accdb

Customer:

Add Referential Integrity to your two tables. Please ensure that you invoke the following two items a. Enforce Referential Integrity b. Cascade update fields

Customer:

i have two tables the instructor table and the course table

Customer:

you can delete the relationship that i have there already since i know its wrong

rhess :

ok

Customer:

i have a crappy online teacher but you can give a brief explanation on how you did it if you want just so i have a basic understanding of it

rhess :

I'm assuming we have to link "course" with "instructor"

Customer:

yes

rhess :

ok, the first thing i had to do was chance the data type for the "instructor id" field in the "course" table to "number"

rhess :

from there, you can create a 1 to many relationship with the "instructor ID" field on both tables

Customer:

o

Customer:

oh okay 1 to many i could'nt firgure out which one to choose

rhess :

i've created a sample query to show that it works

Customer:

thanks

rhess :

http://wikisend.com/download/256674/Unit_3_MicroSoft Access.accdb

rhess :

do you understand what a 1 to many relationship does?

rhess :

So, once i created the relationship, i just had to check the boxes for "enforce referential integrity" and "cascade update related fields"

Customer: I'm having trouble opening the database it says I have to me a backup copy of the database and open with read write permissions
rhess :

what version of office are you using?

rhess :

http://wikisend.com/download/731944/Unit_3_MicroSoft Access.accdb

rhess :

try that one

Customer: Can I change the properties by double clicking like most files and going to property
Customer: 2010 access
Customer: Okay I will try that one
rhess :

you should be able to just double click and open

Customer:

sorry finally got it open just had to get rid of the read only property where do i go to check and see if the rules are applied ?

Customer:

see you stepped out gonna accept and take your word that everything is good to go thanks for your help and hopefully i can get your help on some other projects in the future

rhess, PC Consultant
Category: Microsoft Office
Satisfied Customers: 103
Experience: I have extensive training in all versions of MS Office
rhess and 3 other Microsoft Office Specialists are ready to help you
Expert:  rhess replied 2 years ago.
Sorry I missed your follow-up question in the chat. To check the relationship, click on the "Database Tools" tab, click "Relationships," and then double click on the relationship line between the tables. You will see that 2 boxes are checked per the specifications you gave me.
Customer: replied 2 years ago.
Thanks yea I seen it good job I have already accepted your answer and left you a comment
Expert:  rhess replied 2 years ago.
Hello, it was great working with you to resolve your MS Access problem.

If you ever need help with anything MS Office related in the future, I would be happy to help you out.

Thanks!
Customer: replied 2 years ago.
are you there?
Customer: replied 2 years ago.
let me know when you are online again
Expert:  rhess replied 2 years ago.
I'm online now, but only for a few minutes. I won't be available again until tomorrow after 6:00 PM EST.
Customer: replied 2 years ago.
I will contact you tomorrow then?
Expert:  rhess replied 2 years ago.
Sounds good. Is this regarding this question or does it pertain to a new issue?
Customer: replied 2 years ago.
A new issue just need a few more querying created
Customer: replied 2 years ago.
http://wikisend.com/download/670290/Unit_3_Warren Morris-Database rough draft.accdb

Please add the following queries to your database. Label them Unit 4-Query 1, Unit 4-

Query 2, etc.

1. Create a query that will display all information from the Instructor Information

table.

2. Create a query that will display all information from the Course Information table.

3. Create a query that will display all instructors that live in Orlando, Florida. Please

display all information from the Instructor table except the state.

4. Create a query that will display all courses that are offered in the 100 level series.

5. Create a query that allows Jenny to enter in the Instructor’s last name as the

query is run.

6. Create a query that shows which instructors need a raise! Hint: your query

should show all instructors making less than $20/hr.


1 AND 2 ARE ALREADY CREATED
Expert:  rhess replied 2 years ago.
Can you please open this as a new question? If you go to my profile at http://www.justanswer.com/profile.aspx?PF=64975016&FID=7067, you can make sure it is sent to me directly. I will work on it first thing when I get home this evening at around 6:00.

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

    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:

    301
    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:

    274
    20 years experience providing remote computer support
  • 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:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

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

Related Microsoft Office Questions

Chat Now With A Microsoft Office Technician
rhess
rhess
39 Satisfied Customers
I have extensive training in all versions of MS Office