MS Access is very easy to use because it has a simple user interface. It is also possible not only to store important information, but also to process data, including the creation of forms, reports, and various diagrams.
Necessary
- - computer;
- - MS Access program.
Instructions
Step 1
Start the Access program and through the menu in the "File" tab click on "New". Then select "Database" and click OK. A window will appear in which you will need to specify the name of the database or agree with the proposed db1, and you will also need to select the location for storing the database.
Step 2
After creating the base, a window with functions for further work will appear. On the left is a column with a list of sections. The "Tables" item should be selected by default. To the right of the column is a list of options for creating database tables: "Creating a table in design mode", "Creating a table using the wizard", "Creating a table by entering data".
Step 3
Click on "Create Table in Design Mode" to create a new table in the database. A new window will appear on the screen with a grid at its top for entering table parameters: fields, field type and description. The properties of each new field appear at the bottom of the window.
Step 4
Create a table with four fields:
1. Code. The field type is numeric.
2. Surname. The field type is text.
3. Name. Field type - text
4. Telephone. The field type is text.
Highlight the first field and right-click and select Key Field. Close and save the created table under a name convenient for you, for example "Agent". Open the created table and enter the details of the two agents.
Step 5
Create another table with three fields:
1. Position. The field type is text.
2. Wages. The field type is monetary.
Close and save the created table with a name such as "Employee". Open the created table and enter data for two employees.
Step 6
Click on the "Queries" tab and then on "Create Query in Design Mode". A window will open with a list of tables created in the program. Select both tables already created. At the bottom of the request form, in the first column, select the field "Employee. Last name", and in the second column - "Organization. Position". Close and save the Employee Title Request Form. If you open this query, you will see only two columns "Last name" and "Title". Only the information of interest will be displayed here, what position a particular employee holds.
Step 7
For the convenience of filling out the database, click on the "Form" tab, and then "Create a form using the wizard". In the window that opens, select the "Agent" table, and then from the "Available fields" window, using the arrow button, move the "Last name", "First name", "Phone" fields to the "Selected fields" window. Click the Next button and choose a convenient form format, for example, Ribbon. Click Next and select the style you want, for example Standard. Click the Next button and name the form Agent. Click the Finish button. A form will appear with two fields, which already contain information about two agents. Below is an empty field where you can enter information about the third agent, and so on.
Step 8
In the database window, select "Reports" and click on the "Create a report using the wizard" tab. In the window that opens, select the request "Employee position". From the left window, drag "Surname" and "Position" to the right fields, click the "Next" button, and then the "Finish" button. A report form with information from the selected request will appear on the screen. The report function makes it possible to select the desired information from the database for a more convenient perception. Also, reports can be printed.
Step 9
Macros allow you to automate actions on database objects. Click on the "Macros" tab and then on the "Create" button. The designer window will open. From the drop-down list, select the OpenRequest macro, and then select the name of the request, Employee Title. Close the window and save the created macro. Double-click on the created macro and the request "Position of the employee" will open.
