Managing data with microsoft access. It provides tools to create tables, quiries, forms, and reports.

Microsoft access is a database tool used to store, organize, and manage data efficiently

1. TeachingMethodologyandPracticumICTSupport
MOFPIB3

2. A database
•Databases evolved in the early 1960s. Thedatabase process is to collect and
organize data typically stored electronically in a computer system. A database is
said to be a list that is kept written (or) typed on paper, in a computer
spreadsheet or word processing document. Accessing data becomes more
accessible and integrated with the rest of our work. Handling information using
a database allows us to become strategic users and easy of the data we have.
A database is versatile which can be integrated into all sorts of project

3. WHATISADATABASE?
It’sastructuredsystemtoputyourdatainthat
imposesrulesuponthatdata,andtherulesareyours,
becausetheimportanceoftheseproblemschanges
basedonyourneeds.

4. What isthepurposeofadatabase?
1.Thepurposeofadatabaseistostoreandretrieveinformationina
waythatisaccurateandeffective.

5. IsExceladatabase?

6. SowhyisExcelnotgoodtorunasadatabase?
•Whatifyouhaveabunchofdata,maybe10,000customer,“Areyougoingto
scrolldowninthespreadsheetto get the 9999 customer?!”,What if the security was
aconcern,“Doyoucareaboutifsomeoneelsegotanaccesstoyourdata?”, What
ifyouaccidentallyputaredundantinformation,“Isitfinetohave duplicate
informationalongthespreadsheet?”.

7. WHENDOWENEEDADATABASE

8. WHENDOWENEEDADATABASE

9. WHEREDOWESTART!!!!!!!

13. DATASHEETVIEW
AdatasheetviewinanAccessappdisplaysdataarrangedinrowsandcolumns.

15. DESIGNVIEW
Designviewallowsyoutoworkwiththeunderlyingstructureofyourtables,queries,
forms,andreports....InDesignviewfortables,eachrowcorrespondstoafield.You
canedit,insert,anddeletefieldsinyourdatabasetablesinDesignview

19. WhatisthepurposeofthePrimaryKey??
GOOGLE!!!

20. A primary key is a field or set of fields with values that are unique
throughoutatable.Valuesofthekeycanbeusedtorefertoentirerecords,
becauseeachrecord hasadifferent valuefor thekey. Each tablecan only
haveoneprimary key.

23. OpenMoodle[Youcandothis
afterthelecture]

24. Doubleclick!!!!!

26. Let's work in the database!!
1.Create a new field for ID numbers
2.Assign a primary key to the ID field
3.Create a new field and title it gender (reflect a dropdown of Male and
Female)