Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense.

It explains how to create a desktop database by using a template, and how to build a database from scratch by creating your own tables, forms, reports, and other database objects.

With Access, you can build a database without writing code or being a database expert. Well-designed templates help you quickly build databases. Easily find just the data you want with queries. Instantly …

This sample database is designed to teach anyone the fundamentals of how to use Access as a database. Using a sales tracking system with a simple but correct data model as an example, it …

Training: Access databases and web apps can make life and work easier. Start with a solid database design to yield big business advantages. Watch this online video to see how.

See Create a database model for more information. Visio also offers a stencil that lets you create a data-flow diagram, which provides information about the outputs and inputs of each entity and the process …

Database Design Northwind has a simple but correct Relational Database Design. Tables hold specific information about Northwind's business. Fields in the tables have specific properties set to make …

Open the database that you want to analyze. In the Navigation Pane, right-click the table that you want to explore, and then click Design View on the shortcut menu. As needed, note the name of each …

You can customize the Asset Tracking database by adding a new field to the Assets table, and then adding that field to the Asset List form, the Asset Details form, and the Asset Details report.

When you create a new, blank database, a new, empty table is automatically inserted for you. You can then enter data in the table to start defining your fields.