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.
Learn the structure of an Access database - Microsoft Support
This article provides a basic overview of the structure of an Access database. Access provides several tools that you can use to familiarize yourself with the structure of a particular database. This article also explains how, when, and why you use each tool.
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 …
Examples of query criteria - Microsoft Support
Query criteria help you zero in on specific items in an Access database. If an item matches all the criteria you enter, it appears in the query results. To add criteria to an Access query, open the query in Design view and identify the fields (columns) you want to specify criteria for.
Create a form in Access - Microsoft Support
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 desktop database and this article points you to some of the common ways.
Introduction to forms - Microsoft Support
A form in Access is a database object that you can use to create a user interface for a database application. A "bound" form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source.
Introduction to tables - Microsoft Support
An Access table contains all the data in a database. Learn more about creating and modifying tables in Microsoft Access.
Build an Access database to share on the Web - Microsoft Support
Create database applications that don't require Access to use. This article provides an overview of Access web database design. For an introduction to desktop database design, see the articles Create a new desktop database and Database design basics.
Featured Access templates - Microsoft Support
On this page, you can download our most popular Microsoft Access database templates. Choose from a wide range of inventory templates, project management templates, issue tracking templates, and many more for Access.
Guide to table relationships - Microsoft Support
When you design a database, you divide your database information into many subject-based tables to minimize data redundancy. You then give Access a way to bring the data back together by placing common fields into related tables.