A database is information that is structured in a certain way. It is very convenient to work with such data, and the search process is greatly accelerated. So how do you create a simple database?
Instructions
Step 1
Think carefully about your database structure. Decide on the information that will be contained and count the number of required columns, for example, email addresses are required for customer mailing. Please note that it is more convenient to place all data in several tables, rather than in one. It will then be much easier to correct the data without looking at all the information.
Step 2
Create a database in Microsoft Office Access. First, open the program and select the "Create File" command. Then in this section select "New Database".
Step 3
Give your database a name that will be associated with the hosted data and save it in the correct folder. The database can be automatically saved in My Documents.
Step 4
Select "Create table in design mode" - double-click. This option is the most convenient because allows you to create a table not with a standard number of columns, but with the number you need.
Step 5
Examine the window that appears to create a table. The first column will be "Field name" - enter the name of the corresponding attributes there. A drop-down list will appear in the next column "Data type", from which select the appropriate type, for example, text, numeric, etc. The third column is called Description. Fill in the required data details.
Step 6
Change the values. To save disk space, set the size of the fields, i.e. columns of the required size, for example, does not always require 50 standard characters to write a name, often only 10-15 characters are required. Save the file after all the procedures.
Step 7
Change the structure of the tables. Hover over the dialog box and select the "Insert" - "Rows" command. Thus, increase the number of fields for entering new data. Add a field in which to place the primary key of the table. This key will identify each line, and be its individual number, which will not be duplicated anywhere.
