Home Blog Archive MS Office Access Tutorial: The basics explained simply

Access Tutorial: The basics explained simply

  • Oct 01, 2025
  • 385
  • 0

You want to first create a database with Access? In this Tutorial, we will explain the most important basics and concepts from Access Version 2010.

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.
  1. Navigate in the menu "Create" button table design".
  2. Specify in the column "field name" means the name of the fields. Rename the fields e.g., article name, article number, etc.
  3. 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.
  4. If you switch to the Datasheet view, you can enter test data.
  5. You have created several tables, specify relationships between the tables. To do this, select in the tab "database tools" the button "relationships".
  6. With the mouse, you can draw a line between the fields.
  7. 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.
  8. 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.
  9. You are using multiple tables, make sure that you have set the relationships correctly.
  10. Save the table.
  11. To Create a form, navigate to Create tab and select "form design".
  12. 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.
  13. 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

To create a new table in Access

Fields, field data types and primary key in a table festelgen

Fields, field data types and primary key in a table festelgen

Check the table in which you enter test data

Check the table in which you enter test data

Relationships between tables in Access set to group output data, or to calculate

Relationships between tables in Access set to group output data, or to calculate

A query design open

A query design open

Tables for query select

Tables for query select

The query fields to add

The query fields to add

A form from tables or queries in Access to create

A form from tables or queries in Access to create

YOU MAY ALSO LIKE

0 COMMENTS

LEAVE A COMMENT

Human?
1 + 3 =