Use Microsoft Access databases to store 5 employees informat

Use Microsoft Access databases to store 5 employees\' information 5 products or services information You should use Form Report Query

Solution

Hello. We can prefer Microsoft Access databases to store our data amd also can retrieve our data from the database.

Here are some of the steps which can be usedto create your own databse of employees information and products.

1.Firstly you should create a file database for storing your employee\'s information for your company. So you need to open MS Access & open a new sheet and rename it as \"Employees Data\".

2.In row 2, enter the entity names like First_Name, Last_Name, Gender, Job Position, Salary, Address and City etc. As it is the information about 5 employees, you can create your data with different people names with different job possitions.

3. In thesame way we can create a data table for the product\'s and services using the same criteria.

4. The data table for the Products and Services can be created with the entities like Product_name, Product_number, Cost etc. We can also Import Existing Data from an existing Spreadsheet.

5. With the usage of Form,Report and Query, we can make good usage of the data table and use it in a responsive way.

a). We can create an input Form for adding new employee and for adding new products by clicking on the Form Wizard option. You can name it is Customer\'s Form. After modifying the details of the newly created form, click the finsish.

b). We can create a Report for the fields of the data from the created tables using the Report Wizard. The Report can be created for the Customers and the Product tables for the Fields of Customer Name and the Products_number and Cost. Modify the reports design and click the Finish button.

c). We can create any number of quiries for the tables we create. Through the quiries, we can extract the data from the data tables and form them in a systematic order. Click on the Quiery Wizard button . For generating a query, select the table ie, Table_name followed by the field names. eg: Product Table followed by Product_name and Product_number.

In this way we can create and retrieve the data we have created using the MS Access and opereate the Form, Report and Query actions on the present data and modify the acquired data from the data tables.

Thank you.