create database diagram


Create a database diagram with one click. View all your table relationships and print your diagram for reference or planning.

Access has an inbuilt feature that displays the tables and their relationships. This can be used to print out for reference or planning purposes.

Actually, it's the same feature that allows you to create a relationship.

Here's how to create a database diagram

Screenshot of Access with the Relationships button highlighted.

Launch the Relationships Window

Click Relationships from the Database Tools tab in the Ribbon.

This launches the Relationships window, with a diagram of all relationships.

Screenshot of the Show Tables dialog box.

Show any Queries and/or Orphan Tables

By default, Access only displays objects that are in a relationship. However, you can view all tables and queries to see if any are missing from the diagram.

To do this, click the Show Table button on the Ribbon (from the Design tab) to launch the Show Tables dialog box

Screenshot of the Show Tables dialog box.

Add the Objects

Select any objects you'd like to add to the diagram and click Add.

Click Close once you're done

Screenshot of the database diagram.

Rearrange the Objects if Required

You can click and drag the objects around the window to provide a clearer picture of the objects and their relationship with each other.

You can also expand the objects' heights by clicking and dragging on their bottom edge (i.e. to display all fields without having to scroll).

Collapse the left Navigation Pane to provide more room for the diagram.

To do this, click the little Â« icon at the top of the pane.

Screenshot of the database diagram.

Removing Tables/Queries

To remove an object from the diagram, right-click on the object and select Hide Table from the contextual menu

Screenshot of saving the diagram.

Save the Layout

Once you've got the diagram looking just the way you want it, you can save the layout so that whenever you open up the Relationships Window in the future, the objects will be arranged in the way you've just arranged them.

To do this, right-click in the Diagram Pane and click Save Layout from the contextual menu

Screenshot of the Relationship Report button highlighted.

Run a Report

Access can automatically generate a report based on your diagram.

To generate a report, simply click Relationship Report on the Ribbon (from the Design tab).

Screenshot of the report.

Print/Modify the Report

The report opens in Print Preview. However, just as with any report, you can switch to Design View to modify the report, save it, export it, print it etc.

Comments

Post a Comment

Popular posts from this blog

vocab

Image
       Meaning vocabulary is a term that describes how people learn the meaning of words. Children can learn the meanings of words by using context clues, word part instruction and graphic organizers. Meaning vocabulary entails words for which their meanings are understood and it is an important component of comprehension. Direct instruction in meaning vocabulary is essential. If vocabulary is not developed, children will be unprepared to handle vocabulary demands of content-area subjects. Its significance is also displayed in comprehension and interaction with others. Meaning vocabulary helps to build social skills, confidence and self-esteem in children. It also enables children to use context clues to decipher word meaning. It helps children to construct more interesting stories and to communicate effectively with their peers and just about anyone with whom they interact. The more words they know, the more aptly they will be able to communi...
Read more

📚Gds-Tech 📚 EMS

Image
In this competitive world, 'Vocabulary' plays a vital role in every exam. Several banking and Government exams are round the corner like IBPS PO, Clerk, IBPS RRB, SSC-MTS, CGL, CHSL, State Level exams , Other Exams etc.  Gds-Tech Educational sollution  provide you 10 new words in  Gds-vocab  on the daily basis which will benefit you in upcoming examinations.  The Gds-Vocab  includes the word with the meaning, synonyms, antonyms along with the example given in  " The Gds Info-Skill Times "   pages. As we all Know in English section the vocabulary comes from THE HINDU Newspapers in the most bank and competitive exams and it is very essential to read and memories vocab from The Gds  Vocab daily. You can test your vocabulary and evaluate yourself with regard to your respective exams. You can easily learn The words form Gds  Vocab   regular basis .          Gds ...
Read more

spreadsheet in excel

Image
What is a Spreadsheet A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, as well as text,  formulas ,  references  and  functions . Rows, columns and cells in a spreadsheet The rows in a spreadsheet have numeric names (1, 2, 3 etc) and the columns have alphabetic names (a, b, c etc), thus the names of cells subsequently exist of a letter and a number that conveniently point out their position in the grid Selection of a row In the image above row 3 is selected. This can be done by clicking on the number 3 in front of the row. Selection of a column In the image above column B is selected. This can be done by clicking on the letter B above the column. Selection of a cell In the image above cell B3 is selected. This can be done by clicking on the cell. Worksheets A spreadsheet can contain one or several worksheets (tabs). Adding worksheets can be done by clicking the...
Read more