Structure of a Access database
In addition to the tables in Access queries, forms, reports, macros, and modules.
- All data are first organized into tables. A table can contain, for example, address or article information. The data is held in columns and rows ready.
- The rows are called records and the columns as fields.
- With queries, you can filter the included in the table data, merge, or compute. For this purpose, different tables if necessary can be connected to each other via relationships.
- In forms the data input by the respective user. Also, the data can be viewed in forms. Query results can be used in forms to spend.
- Reports are the forms similar to and used for printing.
- Macros are used to Automation of work processes. Several actions, such as menu commands, you can run automatically after each other.
- In modules, you can save it via VBA self-programmed functions and procedures.

Databases in Microsoft Access
An Access-database design
A database that starts in your head. It is important that the structure to pre-define.
- Consider what data (e.g. items, orders, customer information) to be included in their database.
- Divide the different data into themes. Each topic will later be recorded in a separate table.
- Determine which information must be stored in the individual tables. In a table with articles, you need to have, for example, as a column item name, item number and price headings.
- Duplicate records to avoid, place a so-called primary key is fixed. This ensures that redundant data cannot occur at all. In the case of articles, the article number would be the primary key to offer.
- Set the relations between the individual tables. In a later query from different tables, you need to connect the tables to each other. In the case of an order, for example, items to be covered numbers. Thus, the relationship between the products table and the orders table, the field "product number" would be.
Views in an Access database
To have any object, you always have at least two different view types.
- In design view, you specify which fields are to be used and to set options. In forms and Reports, you make the view.
- In Datasheet view, you will see the contents of the tables and the results of queries.
- For forms and Reports, the data is displayed in the form or the report view.
The first simple Access database create
The beginning of every database is the table.
- Navigate in the menu "Create" button table design".
- Specify in the column "field name" means the name of the fields. Rename the fields e.g., article name, article number, etc.
- You then specify the data type. In the case of article name the text field as the type. Access provides you with a selection available.
- If you switch to the Datasheet view, you can enter test data.
- You have created several tables, specify relationships between the tables. To do this, select in the tab "database tools" the button "relationships".
- With the mouse, you can draw a line between the fields.
- Filtered data in a form or report, select the tab "Create" command on the "query design". Add one or more tables by clicking on it, which fields you want to use.
- Select from the tables, the fields you want to use. You can either drag a field from the list in a blank column, or you can double-click on an entry in the list.
- You are using multiple tables, make sure that you have set the relationships correctly.
- Save the table.
- To Create a form, navigate to Create tab and select "form design".
- Then, click the "Tools" group on the "Existing fields". Now select the fields from tables, or the just created query and place these in the design.
- You have now created your first simple database in Access.
As in Access, a crosstab query can read in the next tip.
Latest Videos
To create a new table in Access
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_1.jpg)
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_1.jpg)
To create a new table in Access
Fields, field data types and primary key in a table festelgen
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_2.jpg)
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_2.jpg)
Fields, field data types and primary key in a table festelgen
Check the table in which you enter test data
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_3.jpg)
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_3.jpg)
Check the table in which you enter test data
Relationships between tables in Access set to group output data, or to calculate
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_4.jpg)
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_4.jpg)
Relationships between tables in Access set to group output data, or to calculate
A query design open
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_5.jpg)
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_5.jpg)
A query design open
Tables for query select
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_6.jpg)
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_6.jpg)
Tables for query select
The query fields to add
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_7.jpg)
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_7.jpg)
The query fields to add
A form from tables or queries in Access to create
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_8.jpg)
:fill(000,true):no_upscale()/praxistipps.s3.amazonaws.com%2Faccess-tutorial-die-grundlagen-einfach-erklaert_8.jpg)
A form from tables or queries in Access to create