Visio 2010 to create a database model diagram and table

Visio 2010 to create a new database model diagram

Existing database, if you want this basis, no, you can start with an empty model database, and add your own tables and relationships.

Document database parameters

Click the file.
Click "Create", and then click the software and database, and then double-click the database model diagram.
Database Group Management tab, click the "Display Settings".
In the database file settings in the dialog box, select the required character sets and other parameters of tables and relationships, and then click OK.

Visio 2010 download to build the table

Of a convenient size to set up your plan (for example, 100%), the nature of the chart elements and then drag the container object-relational database.
Category in the list, to ensure that the definition of the selected row and enter the value:

The name of the concept - measures

Click the ranks, ensure that the switch is set to the physical data type Microsoft Access, enter a name and select a data type, such as shown in Figure 3. To change the column's data type, click the field's data type, then select a data type from the list, or a list of the input data type. The field notes are not necessarily to fill its value is automatically generated.
Check the box to the desired column can not be NULL.
Each line in the check PK uniquely identifies the database table column (primary key).
Visio 2010 "category, click the indexes, triggers, check, or more to create these additional elements.
Theme of the design team can select the style sheet on the label, for example, brightly colored, easy shadow effect