The database is an information complex stored in electronic form. The information in the database is stored in various formats: text, numerical. It is maximally adapted for further processing and searching for the necessary data.
Necessary
- - computer;
- - MS Access program.
Instructions
Step 1
Start Microsoft Access to create an electronic database. You can create it in one of the following ways: create a database using the wizard, i.e. based on the selected template. This method is the fastest and most convenient when the selected template fully meets your requirements. The template already contains tables, forms, queries and reports. Finally, you can create an empty database yourself without a wizard. To do this, you need to add the required objects and then fill the database with information.
Step 2
Create the base immediately after starting the program, in the window that appears, enter the name for the base and the location where it was saved. Next, the main Access window will open, in the tabs of which you can create database objects. The foundation of any database is tables, so you should start with them.
Step 3
Go to the "Tables" tab, click on the "Create" button. Select the "Constructor" option, this mode allows you to build the structure and set the settings for the table. Enter the names of the fields (columns) of your table in the design window. One field must be key, i.e. the main one. This field is unique, i.e. there will be no duplicate data. Select the required field and click on the button with the key on the toolbar.
Step 4
Set the field type for each of them in the Data Type column. Click on an empty cell and select the required type from the list: text (for alphabetic and numeric unchangeable data), MEMO field (for entering long texts or numbers), numeric (for entering numerical information), date / time, currency, counter (automatically fills in unique sequential numbers), boolean (data that can take one of two values - yes / no), OLE object (inserting pictures, diagrams, pictures, photos), hyperlink, substitution wizard (allows you to insert data from one table into another or create combo box).
Step 5
Establish links between the created tables, for this they must have the same fields. For example, the table "Employees" with the key field "Personnel number" can be linked to the table "Customers", in which each client is assigned to a specific employee using the field "Personnel number".
Step 6
To establish a connection, go to the "Data Scheme" window using the button on the toolbar and drag the key field of one table ("Employees") to a similar field in the other table ("Clients"). In the window that opens, check the box "Cascade deletion of related fields", click "OK".
