Intrduction to ms access.pptx+ASSSSSSSSSSSSS

HI

1. Intrduction to ms access

2. W hat is database A DATABASE IS A COLLECTION OF DATA RELATED TO A PARTICULAR TOPIC OR SUBJECT FROM WHICH SPECIFIC INFORMATION CAN BE EFFICIENTLY RETRIEVED. EXAMPLE OF DATABASE A DICTIONARY IS A DATABASE OF WORDS A LIBRARY CAN BE CONSIDERED A DATABASE OF BOOKS .

3. RELATIONAL DATA BASE A RELATION DATABASE IS A COLLECTION OF DATA ITEMS ORGANISED AS A SET TABLES FROM WHERE DATA CAN BE ACCESSED OR ORGANISED IN DIFFERENT WAYS WITHOUT HAVING TO REORGANISE THE DATABASE TABLES.

4. Database terminology TABLES TABLES ARE THE BUILDING BLOCKS OF ACCESS DATABASE. A TABLE IS A COLLECTION OF RELATED DATA ORGANISED IN ROW AND COLUMN. QUERIES QUERY MEANS A QUESTION. QUERIES ARE USED TO PROVIDE FILTERED DATA FROM THE TABLES AS DESIRED BY THE USER BASED ON SOME CONDITIONS.