Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

database

ResolvedVersion 2007

Nick has attended:
Access Intermediate course
Visio Advanced course

Database

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

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

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

RE: database

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

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

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Visio tip:

Creating an organisation chart in Visio using Excel data

A quick and easy way to create an organisation chart by importing names and titles stored in list format in an Excel spreadsheet into Visio.

1. Select File, New, Organization Chart.

2. Start the Organization Chart Wizard.

3. At the first step of the wizard, select the 'Information that I enter using the wizard' option, and click Next.

4. At the second step of the wizard, select Excel, then type the name of the file.

5. Select Browse to choose the location you wish to save the file to, click Save, and then click Next.

6. Click OK - a Microsoft Office Excel workbook will open with column headings already entered for you.

7. Replace the sample text with the text you wish to appear in your organisation chart. By holding your cursor over each column heading, you should be able to view data entry tips.

8. Save the Excel file, then close Excel.

9. Proceed through the remaining steps in the wizard to create your organization chart from the data you entered into the Excel file.

Visio's organisation chart wizard will also recognise the following file formats (besides .xls):

- Microsoft Exchange Server Directory (Microsoft Exchange e-mail Address Book).

- Tab- or Comma-delimited text (.txt).

- Org Plus (.txt).

- Microsoft Office Access (.mdb) or any other file format for a database created in an Open Database Connectivity (ODBC)-compliant database application.

View all Visio hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.