Ms Access is one of the nationwide applications noted to be a relational database, which means that it stores data in tables that are related to each other. Access is used to create and manage databases, and to create forms, reports, and queries.
1. Open Microsoft Access.
2. Click on the “Blank Database” option.
3. Enter a name for your database and click “Create”.
4. In the “Tables” section, click on the “Create” button.
5. Enter the name of your first table and click “OK”.
6. In the “Field Name” column, enter the names of the fields you want to create.
7. In the “Data Type” column, select the data type for each field.
8. Click on the “Primary Key” button to set the primary key for the table.
9. Click on the “Save” button to save the table.
10. Repeat steps 4-9 to create additional tables.
11. In the “Relationships” section, click on the “Create” button.
12. Select the tables you want to create a relationship between.
13. Select the fields you want to use to create the relationship.
14. Click on the “Create” button to create the relationship.
15. Repeat steps 12-14 to create additional relationships.
16. In the “Forms” section, click on the “Create” button.
17. Select the table or query you want to create a form for.
18. Click on the “Create” button to create the form.
19. Repeat steps 17-18 to create additional forms.
20. In the “Reports” section, click on the “Create” button.
21. Select the table or query you want to create a report for.
22. Click on the “Create” button to create the report.
23. Repeat steps 21-22 to create additional reports.
About Author
Discover more from SURFCLOUD TECHNOLOGY
Subscribe to get the latest posts sent to your email.
