Split an Access database - Microsoft Support
Split an Access database into front-end and back-end components to improve performance and safely share data with other users.
Guide to table relationships - Microsoft Support
When you design a database, you divide your information into tables, each of which has a primary key. You then add foreign keys to related tables that reference those primary keys. These foreign key-primary key pairings form the basis for table relationships and multi-table queries.
Examples of expressions - Microsoft Support
You can use expressions to add, subtract, multiply, and divide the values in two or more fields or controls. You can also perform arithmetic operations on dates. For example, suppose you have a Date/Time field called RequiredDate.
Database design basics - Microsoft Support
Divides your information into subject-based tables to reduce redundant data. Provides Access with the information it requires to join the information in the tables together as needed. Helps support and ensure the accuracy and integrity of your information.
Guide to expression syntax - Microsoft Support
Divide the first number by the second number. [Total]/[ItemCount] Round both numbers to integers, divide the first number by the second number, and then truncate the result to an integer.
Use a union query to combine multiple queries into a single result
Use a union query to combine multiple queries into a single result. Sometimes you might want to list the records from one table or query with those from one or more other tables to form one set of records - a list with all the records from the two or more tables. This is the purpose of a union query in Access.
Use parameters to ask for input when running a query
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. Before getting into the step-by-step below, it’s helpful to understand these terms:
Video: Get started with databases - Microsoft Support
Step 3: Divide information into tables. Divide your information items into major entities or subjects, such as products, customers, and orders. Each subject becomes a table.
Table of operators - Microsoft Support
Access supports a variety of operators, including arithmetic operators such as +, -, multiply (*), and divide (/), in addition to comparison operators for comparing values, text operators for concatenating text, and logical operators for determining true or false values. This article provides details about using these operators.
Add records to a table by using an append query - Microsoft …
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 …
Import or link to data in a text file - Microsoft Support
To use a text file as a source file for importing or linking, the contents of the file must be organized in such a way that the importing and linking wizards can divide the contents into a set of records (rows) and each record into a collection of fields (columns).