I have learned some UML knowledge, but I have never had time to put it into practice. During this time, I wrote a simple inventoryProgramI just wanted to put it into practice. I first created a database model diagram Using Visio. It was a little more intuitive to create a database in Visio and it was quickly completed. The operation was quite convenient, then, create a database in access according to the Visio diagram, because I did not find any tools in Visio that can be directly imported to access.
After setting up access, I found that the ACCESS database can be directly imported into the Visio database model in Visio.
Create a new database model diagram in Visio and find the menu bar, "database \ reverse engineering... ", select" MS Access Database "for the data source, and find the ACCESS database file according to the Wizard to facilitate import.
If anyone can import the model diagram of the Visio database directly to access, don't forget to let me know. Thank you!