Access Step By Step

Step No. 1 :

Open Microsoft Access by Clicking Start>Run> Then type “MSACCESS” Click ok or press enter.

2

1 Step No. 2

Click on File > New Click on Blank Database Type Name for database Press Enter.

3

1 2

3 Step No. 3

Double Click on 3rd Option “Create table by entering data”

Step No. 4

Rename the fields. 1. By Double Click 2. Right Click on Field and click Rename

Step No. 5

Enter relevant information and save table with the name of Admissions

Click “Yes” for Primary

Step No. 6

Double Click on Table to view the difference/changes

Step No. 7

Close Table. Double click on 2nd option

Step No. 8

Select Business > Students and classes Click on Add Button

Step No. 9

Click Next > Type the Name for Table “Fee Receipt” don’t select any other option click Next>Next>Finish.

Step No. 10

Rename the Fields enter required data, save and close the table.

Step No. 11

Double Click on 1st option type the required Fields as mentioned at first table.

Step No. 12

Save the table, Click Yes for Primary Key.

Step No. 13

Create a New Table with only one Field named “Courses Offered” Save the table with the name Courses with out Primary Key

1

3 5

2

4

Step No. 14

Open Admission Table. Click on Design View Icon> Click Courses> click Lookup> Select Combo Box. > Click on Row Source > Select “Courses”

1

2 4

3

5 6

Step No. 15

Save the changes, Close the Table. Reopen to check the links.