How to Create a Database with Microsoft Access (with Pictures)

Table of contents:

How to Create a Database with Microsoft Access (with Pictures)
How to Create a Database with Microsoft Access (with Pictures)

Video: How to Create a Database with Microsoft Access (with Pictures)

Video: How to Create a Database with Microsoft Access (with Pictures)
Video: How to Convert JPG to PDF on PC, iPhone & Android 2024, November
Anonim

This article will walk you through creating a database with Microsoft Access.

Step

Make a Database Using MS Access Step 1
Make a Database Using MS Access Step 1

Step 1. Create a blank database

Open Microsoft Access, then choose File > New.

Make a Database Using MS Access Step 2
Make a Database Using MS Access Step 2

Step 2. Select Blank database because you will be creating a database from scratch

Make a Database Using MS Access Step 3
Make a Database Using MS Access Step 3

Step 3. Table 1 will appear on the screen. Click Click to Add.

Make a Database Using MS Access Step 4
Make a Database Using MS Access Step 4

Step 4. Enter the details for the two new fictional employees

Enter "Jeng", press Enter to enter a new field, then type "Kelin". Press Enter twice to enter a new line, then enter "Ucup". Press Enter again, then enter "bin Sanusi".

Make a Database Using MS Access Step 5
Make a Database Using MS Access Step 5

Step 5. Change the table design

Now, you have to change the table design because the table doesn't have a table head. By changing the table design, you can use employee ID numbers. To change the table design, click the View menu on the Home tab of the Ribbon bar, then select Design View.

Make a Database Using MS Access Step 6
Make a Database Using MS Access Step 6

Step 6. When the "Save as" dialog box appears in the tabs at the bottom of the menu bar, write "Employee" as the table name, then click OK

Make a Database Using MS Access Step 7
Make a Database Using MS Access Step 7

Step 7. After entering the data, adjust the table design by going to Design View view.

Make a Database Using MS Access Step 8
Make a Database Using MS Access Step 8

Step 8. In the Design View view, change the column name "ID" to "Employee Number"

Make a Database Using MS Access Step 9
Make a Database Using MS Access Step 9

Step 9. Press Tab, then select Number in the Data Type list

Make a Database Using MS Access Step 10
Make a Database Using MS Access Step 10

Step 10. Rename the fields Field1 and Field2 to "FirstName" and "LastName"

Make a Database Using MS Access Step 11
Make a Database Using MS Access Step 11

Step 11. Return to the Datasheet View view by clicking View > Datasheet View.

Make a Database Using MS Access Step 12
Make a Database Using MS Access Step 12

Step 12. When prompted to save the table, click Yes

Make a Database Using MS Access Step 13
Make a Database Using MS Access Step 13

Step 13. Enter "2011" and "2012" in the first column of the table

Make a Database Using MS Access Step 14
Make a Database Using MS Access Step 14

Step 14. Once the table is complete, save it by right-clicking the "Employees" table and selecting Save

Make a Database Using MS Access Step 15
Make a Database Using MS Access Step 15

Step 15. Create a new table to store additional information, such as electronic devices used by employees

To create a new table, click the Create tab on the Ribbon toolbar, then click Table.

Make a Database Using MS Access Step 16
Make a Database Using MS Access Step 16

Step 16. Click Click to Add, enter "T23", then press Enter

Enter iPhone, then press Enter twice. ("T23" and "iPhone" are just examples in the article. Use a numbering scheme appropriate to your company's circumstances.)

Make a Database Using MS Access Step 17
Make a Database Using MS Access Step 17

Step 17. Allocate each item to the employee who uses it

Click the View menu on the Home tab of the Ribbon bar, then select Design View.

Make a Database Using MS Access Step 18
Make a Database Using MS Access Step 18

Step 18. Enter the table name "Electronics", then click OK

Make a Database Using MS Access Step 19
Make a Database Using MS Access Step 19

Step 19. In the Design View view, enter "Employee Number" instead of ID

Make a Database Using MS Access Step 20
Make a Database Using MS Access Step 20

Step 20. Press Tab, then select Number in the Data Type list

Make a Database Using MS Access Step 21
Make a Database Using MS Access Step 21

Step 21. Rename the Field1 and Field2 fields to "Device Code" and "Description"

Make a Database Using MS Access Step 22
Make a Database Using MS Access Step 22

Step 22. Do not rush to enter multiple data

Currently, the column "EmployeeNumber" has a primary key. Thus, you cannot enter duplicate data. You'll need to change the key to be able to enter the employee's ID number multiple times if the employee has multiple devices.

Make a Database Using MS Access Step 23
Make a Database Using MS Access Step 23

Step 23. Click the "Employee Number" column in the table, then click the Primary Key button on the Ribbon toolbar to clear the table's primary key setting

Make a Database Using MS Access Step 24
Make a Database Using MS Access Step 24

Step 24. Return to the Datasheet View view by clicking View > Datasheet View. When prompted to save the table, click Yes. Enter "2011" as the employee number for the first electronic item on the list, then continue entering data, or follow the image below.

Make a Database Using MS Access Step 25
Make a Database Using MS Access Step 25

Step 25. Make relationships between tables

After designing the table, you can enter data into the table.

Make a Database Using MS Access Step 26
Make a Database Using MS Access Step 26

Step 26. First, close each table by right-clicking the tab of each table, and selecting Close

If prompted, click Yes.

Make a Database Using MS Access Step 27
Make a Database Using MS Access Step 27

Step 27. Then, select the Database Tools tab on the Ribbon toolbar, then click the Relationships button

Make a Database Using MS Access Step 28
Make a Database Using MS Access Step 28

Step 28. When the Show Table dialog box appears, select the name of each table

Click Add, then Close.

Make a Database Using MS Access Step 29
Make a Database Using MS Access Step 29

Step 29. Drag the Employee ID column from the Employees table, then drop it above the Employee ID column in the Electronic table

Make a Database Using MS Access Step 30
Make a Database Using MS Access Step 30

Step 30. When the Edit Relationships dialog box appears, check the Enforce Referential Integrity box, then click Create.

Make a Database Using MS Access Step 31
Make a Database Using MS Access Step 31

Step 31. Connect the two data tables via the Relationship function

Now, you will see a line between the two tables, with the number "1" in the Employees table and the symbol infinity in the Electronics table. The symbol represents a "one-to-many" relationship: An employee can have multiple devices, but each device can only be allocated to one employee.

Make a Database Using MS Access Step 32
Make a Database Using MS Access Step 32

Step 32. Create a form to enter and display data after you connect the tables

Make a Database Using MS Access Step 33
Make a Database Using MS Access Step 33

Step 33. In the Ribbon toolbar, click Create > Form Wizard.

Make a Database Using MS Access Step 34
Make a Database Using MS Access Step 34

34 When the Form Wizard opens, select Table: Employees from the Tables/Queries menu, and click the double arrow button to add the entire column to the Selected Fields list.

Make a Database Using MS Access Step 35
Make a Database Using MS Access Step 35

35 Next, in the Tables/Queries menu, click the Table entry: Electronic, click DeviceCode, and then click the single arrow button.

Make a Database Using MS Access Step 36
Make a Database Using MS Access Step 36

36 Then, click Description, click the single arrow button, and then click Next.

Make a Database Using MS Access Step 37
Make a Database Using MS Access Step 37

37 When you see the question How do you want to view your data?, click "Employees", select Form with subform(s), then click Next.

Make a Database Using MS Access Step 38
Make a Database Using MS Access Step 38

38 Click Datasheet > Next, then click Finish to give the form a default name and open the form to display the information

Make a Database Using MS Access Step 39
Make a Database Using MS Access Step 39

39 Watch the screen

Your form will appear on the screen, with the first information from the Employees table, and the electronic device that the employee is using.

Make a Database Using MS Access Step 40
Make a Database Using MS Access Step 40

40 You can move between employees by using the navigation buttons at the bottom of the screen

You'll also find a New (blank) Record button that you can use to add employees. When you add a new electronic device, Access will allocate it to all employees automatically.

Recommended: