Database design basics - Microsoft Support
A properly designed database provides you with access to up-to-date, accurate information. 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.
Featured Access templates - Microsoft Support
Manage your project's open issues with this popular Access database template. Maintain details about issues and issue assignments, as well as track opened dates and deadlines.
Create a database in Access - Microsoft Support
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 ...
Create a new database - Microsoft Support
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. It also explains some techniques that you can use to get existing data into your new database.
Save and reuse database design elements - Microsoft Support
Maximize your Access design investment by reusing all or part of a database by saving it as a template - with or without data. Share templates with others in your office.
Create a Database Model (also known as Entity Relationship …
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.
Use the Students Access database template - Microsoft Support
Use the Access Student database template to keep track of information about your students, including emergency contacts, medical information, and information about their guardians. You can also search and filter students, track student attendance, show or hide columns, and map student addresses.
Introduction to Access programming - Microsoft Support
In Access, programming is the process of adding functionality to your database by using Access macros or Visual Basic for Applications (VBA) code. For example, suppose that you have created a form and a report, and you want to add a command button …
Access SQL: WHERE clause - Microsoft Support
This article describes how to write a WHERE clause, and uses examples to illustrate various techniques that you can use in a WHERE clause. In a SQL statement, the WHERE clause specifies criteria that field values must meet for the records that contain the values to be included in the query results.
Create entity relationship diagrams in Visio - Microsoft Support
An entity relationship diagram (ERD) illustrates how different entities (such as customers and products) relate to each other in a database. Here are the the three primary parts of an ERD: Entities: The tables in your database. Entities are nouns.