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.
Let's take a walk through the paths you can take to create an Access desktop database, add data to it, and then learn about next steps towards customizing and using your new database.
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.
When it's time for your Access database to go to the next level, migrate your data to SQL Server which supports larger amounts of data, more concurrent users, and greater capacity.
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 create forms for simple data entry. Summarize data in grouped and summary reports. Dozens of Wizards make it easy to get started and get ...
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 them required or to enforce a certain data type (for example, numeric, date, and yes/no).
If you're new to Access, start with these Access tutorial videos for training with Access 2013 and Access 2016. You can download these video Access tutorials or watch them online.
In Visio, with the Database Model Diagram template, you can create a new model or reverse engineer an existing database into a model. This article describes how to create a database model and what you can do with the model after you create it.
When you create a new database, you typically begin by creating several database objects such as tables, forms, and reports. Eventually, you reach a point where you have to add some programming to automate certain processes and tie your database objects together.
