Database

Resolved · Medium Priority · Version 2007

Fri 6 Dec 2013, 15:52 Delegate Nick said...

Nick has attended:
Access Intermediate course
Visio Advanced course

Database

what are the options for displaying a database relationship into Visio?

Wed 11 Dec 2013, 16:02 Trainer Richard said...

RE: database

Hello Nick,

Thank you for your question regarding Databases and Visio.

It would be helpful to clarify what you are asking about:

is it:

1.
You want to draw a diagram in Visio that represents a database?

or, is it:

2.
You want to link a database to Visio?

Kind regards,

Richard

Thu 12 Dec 2013, 08:25 Delegate Nick said...

RE: database

Hi Richard
It is a case of me not knowing what I need to know, plus we did not cover datasbases in the course that I had with STL last Friday.

Both of your options are appealing as I work with databases and I use Visio to 'mock up' report designs. So if those are the only 2 options then could you summarise what Visio can do for me with databases with those 2.

I have a sneaking feeling that Visio could be very pwerful in this area but do not know how.

Many thanks
Nick

Thu 19 Dec 2013, 09:36 Delegate Nick said...

RE: database

Hi
how is this coming on, do you need any more information?
thanks
Nick

Thu 19 Dec 2013, 16:14 Trainer Cindy said...

RE: database

Hello Nick,

Thank you for your question and sorry for the delay in responding.

When you first open Visio, instead of choosing a new blank document, have a look at the templates section. There's a category called Software and Databases where you may find a suitable starting point.

You can also open the Software and Database stencils from the (More) Shapes pane.

Drag and drop shapes onto the page as normal.

The following link has some useful information as to what you can do after that.

http://office.microsoft.com/en-gb/visio-help/create-a-database-model-also-known-as-entity-relationship-diagram-HA010115477.aspx

Hope this helps.

Kind regards

Cindy
Microsoft Office Trainer

Thu 26 Dec 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Visio tip:

Create own ribbon tab - Visio 2010

a. In Visio click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Visio hints and tips