Microsoft Access Exam point of view computer Operator Notes

   MICROSOFT OFFICE  ACCESS …… ?

⇛ A database System consists of software that operates database, providing storage , access and security backup and other facilities. Microsoft Access is powerful programme to create and manage and your database. It has many built in features to assists you in contrasting and viewing your information.

1. How to Start MS Access ?

1. Click on Start menu 

2. Click on Programme 

3. Select Microsoft office 

4. Click on it. 

Or,

1. Click on start menu 

2. Click on Run (Run box will appear)

3. Type “msaccess”

4. Click on Ok or Press Enter key 

2. How to create a database ?

1. CLick on Blank Database 

2. Type the Name of the DataBase 

3. Click on Create 

 3. How to create a table by using a design view?

1. Click on create tab 

2. Select Table Design

3. Type Field Name into field box and choose the despite data type  

Eg. 

Field Name Data Type 

Name Text 

Address`         Text 

Fee Currency

4. Click on Save

4. How to Modify the Table ?

1. Click on Home Tab

2. Click on View (∆)

3. Click on Design View 

4. Now Modify the Table 

5. How to set Lookup wizard ? 

➡  Lookup

Step1:  Open the Table that contains the field that you you want to define as a Lookup field. Make sure that you’re viewing the table in the Design view. To do this, click on View in the Home Tab of the Access ribbon and select Design View . (Click and image for a larger view)

Step2:  Select Lookup Wizard from the drop down box in the Data Type column next to the field that you want to define as a lookup field. 

Step3:  When the Lookup Wizard appears, first choose if you plan to look up the values for this field in a table or query or if you plan to manually type in the values you wish to use .

Click Next to continue  

Step4:  From here, we branch off into two paths depending which method is chosen in  Step3 - TAble/Query  or Manual Entry. 

Manual Entry 

If you choose to manually enter the information, the next portion the Lookup Wizard will Provide a blank table where you can enter the information.

Choose the Number of columns that the table should contain, and then type or paste the information into the table. When done,  Click Next to continue  and skip ahead to Step 5 below.

6. Data Type in Access

Forms:- Forms are on the screen arrangement that is used to insert and view the records in the tables. Forms are attractive so we used to enter the records.

1.  How to create form in the design view ? 

1. Click on create tab

2. Click on more from () sign

3. Select on Design view 

4. Choose the desired table

5. Click on next three time 

6. Click on finish 

7. Click on save 

2.  How to modify the forms ?

1.  Select the form

2. Under Home Tab

3. Click on view 

4. Click on Design View 

5. Modify the desired option

6. Click on Save 

3. How to insert new records in the  form ? 

1. Open the forms 

2. Click on records

3. Click on data entry.

4.  How to set Background Picture on the forms ?

1. Click on forms 

2. Click on Home TAb

3. Click on view drop down arrow

4. Click on design view 

5. Right click on the mouse button on the blank area of the forms 

6. Click on Properties 

7. Choose the “FORM” option From the section type drop down list box 

8. Look where is the picture 

9. Click on it 

10. Choose the desire Picture 

11. Click on insert

12. Save it 

1. How to save database Password ?

1. Click on database tool 

2. Click on Encrypt with password 

3. Type the password

4. Click on Ok

2. How to unset database password ?

1. Close the access program and reopen 

2. Click on office Button 

3. Select Database file 

4. Click on Exclusive 

5. Click on database tool 

6. Click on Decrypt with password 

7. Type the old password 

8. Click on Ok

Thank you