When you design your database, always try to record each fact just once. If you find yourself repeating the same information in more than one place, such as the address for a particular supplier, place that …

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 …

For example, you may have one Access database that contains nothing but tables, and another Access database that contains links to those tables, as well as queries, forms, and reports that are based on …

Tables are essential objects in a database because they hold all the information or data. For example, a database for a business can have a Contacts table that stores the names of their suppliers, e-mail …

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 …

If your Access desktop database is going to be used by multiple users, well-designed forms is essential for efficiency and data entry accuracy. There are several ways of creating a form in an Access …

Use criteria in an Access query to find specific information from your desktop database.

Use the Access Student database template to keep track of information about your students, including emergency contacts, medical information, and information about their guardians.

Each concept topic outlines how you can view an example of it within the Northwind 2.0 Developer template, as well as handy links to learn more about the topic:

One of the goals of good database design is to remove data redundancy (duplicate data). To achieve that goal, you divide your data into many subject-based tables so that each fact is represented only …