Microsoft Office access Tutorial

1. Microsoft Office access Tutorial By: Jose Mahendra Aji

2. Running the application 2. Then, click the all programs section 3. Go to the Microsoft office section and find Microsoft office access there 1. First click the start button which is located on the bottom of your screen

3. Making a new database 1. Click the ‘new’ button on the top left of your screen 2. then, click the ‘blank database’ button

4. 3. Name your database and then click ‘create’

5. Making table 2. then, click the ‘create table in design view 1. Chose the ‘Tables’ options

6. 3. Enter the Field Name and Data Type like shown above. And set the ‘No’ as a primary key 4. Quit and click save

7. Making Queries 2.Cick add 1. Click Table1 (or your table name)

8. 3. Manage your table based on whatever order you want.

9. Making Form 1. Enter the Forms section, and click the ‘Create form by using wizard.’

10. 2.Click this button to select all fields to the selected field section. 3. Then, click next.

11. 4. Chose the layout format that you like. 5.Then, click next.

12. 6. Pick whatever style you like. 7. Then, click next.

13. 8.Insert form name here 9.Then, click finish

14. 10. Now you can insert data in your query

15. Making reports 2. Use wizard to create the report 1. Enter the report section

16. 3. Click this button to move all fields to the ‘Selected field section’ 4. Then, click next

17. 5. Keep clicking next until you reach this part 6. Click the ‘Finish’ Button

18. 7. And the result will be like this.