Microsoft access 2013 inside out sample files free download. Build an Access database to share on the Web

Looking for:

Microsoft access 2013 inside out sample files free download -  

Click here to DOWNLOAD

     

Microsoft access 2013 inside out sample files free download. Microsoft Access 2013 Inside Out

 

One of the most import functions I need, is the ability to view the Relationships of the tables etc. I have now asked 3 different people to download this database from within their version of Microsoft Access and we all have the same problem. The table relationships are not visible. I would really appreciate it, if someone could take the time and download this version and find out how to make the table relationships visible.

If not is it possible to find Microsoft Access Student Database Template Desktop from the Microsoft Site I am hoping the relationship tables will be visible in this version. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. Threats include any threat of suicide, violence, or harm to another.

Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect.

Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites.

Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.

I think I can help with this one. For this specific Access desktop template, there are no relationships defined within the Relationships window.

That is why you won't see anything visually laid out in the Relationships window by default. In this template Lookup Fields are defined at the table level so that helps data entry for the tables; specifically the Student Attendance and Students and Guardians tables. I do think though that these specific fields in this template should go one step further and have the relationships defined in the Relationships window to enforce referential integrity because it is possible to get orphaned data in the tables as they are currently setup.

On the Show Table dialog, click each table to drop them on the canvas and then close the dialog. Click Ok to close the dialog. Details required : characters remaining Cancel Submit 5 people found this reply helpful.

Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Choose where you want to search below Search Search the Community. The relationships between the tables is not visible. Many thanks Carole.

I have the same question Report abuse. Details required :. Cancel Submit. Hi Carole, I think I can help with this one. It's actually quite easy to make these changes in this template. Follow these steps. Make a backup copy of the database always a good thing when making big changes. Close all open objects and then open the Relationship window.

For this template you only need to define three relationships. Save and close the Relationships window. You should be all set now. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. This site in other languages x.