Learn the structure of an Access database - Microsoft Support
Within an Access database file, you can use: Tables to store your data. Queries to find and retrieve just the data that you want. Forms to view, add, and update data in tables. Reports to analyze or print data in a specific layout. 1. Store data once in one table, but view it …
Examples of query criteria - Microsoft Support
A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query.
Add records to a table by using an append query
This article explains how to create and run an append query. You use an append query when you need to add new records to an existing table by using data from other sources. If you need to change data in an existing set of records, such as updating the value of a …
Create and run an update query - Microsoft Support
You use update queries in Access databases to add, change, or delete the information in an existing record. You can think of update queries as a powerful form of the Find and Replace dialog box. You cannot use an update query to add new records to a database, or to delete records from a database.
Use parameters to ask for input when running a query
Use parameters to ask for input when running a query. Applies To. To make a query in Access databases ask for criteria when you run it, create a parameter query. This allows you to use the same query over and over without having to constantly open it in Design view to edit the criteria.
Join tables and queries - Microsoft Support
Use joins in Access queries to combine records from different data sources so that each pair of records from the sources becomes one record in the query results.
Create, edit or delete a relationship - Microsoft Support
A relationship in Access helps you combine data from two different tables. Each relationship consists of fields in two tables with corresponding data. For example, you might have a ProductID field in a Products table and in an OrderDetails table.
Introduction to data types and field properties
A field's data type is the most important property because it determines what kind of data the field can store. This article describes the data types and other field properties available in Access, and includes additional information in a detailed data type reference section.
Guide to table relationships - Microsoft Support
A table relationship works by matching data in key fields — often a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table.
Basic tasks for an Access desktop database - Microsoft Support
Access databases can help you store and track just about any kind of information, such as inventory, contacts, or business processes. 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.
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 …