Transcript 7-ms-access - WordPress.com

VII CLASS
CHAPTER---->3
3. WORKING WITH MS-ACCESS
WHAT IS DATABASE?
THE DATABASE IS A COLLECTION OF DATA
WHAT IS DBMS ?
• DBMS----> DATABASE MANAGEMENT
SYSTEM.
• THE DBMS IS A COLLECTION OF SIMILAR
DATA.
• THE DBMS IS MAINLY USED TO STORE &
RETRIVE DATA FROM DATABASE.
DBMS APPLICATIONS:
• DB IN BANK :
ALL TRANSACTIONS ACCOUNTS.
• DB IN SCHOOL & COLLEGES :
STUDENT DETAILS.
• DB IN LIBRARY :
INFORMATION ABOUT BOOKS.
• DB IN HUMAN RESOURCE :
EMPLOYEE DETAILS, THEIR SALARIES.
FUNCTIONS OF DBMS :
• CONCURENCY :
THE DBMS ALLOWS MULTIPLE USERS
TO ACCESSS DATABASE.
• SECURITY :
DBMS INCREASES SECURITY
& RELIABILITY.
• BACKUP & RECOVER :
DBMS IS USED TO BACKUP THE DATA &
RECOVERS IF A PROBLEM OCCURS.
POPULAR DBMS :
1)
2)
3)
4)
5)
ORACLE
MS-ACCESS
MS-SQL SERVER
CLIPPER
FOXPRO
WHAT IS MS-ACCESS ?
MS-ACCESS IS A RDBMS WHICH STORES
INFO IN MULTIPLE TABLES
• MS-ACCESS TASKS :
1) WE CAN ORGANIZE THE DATA
2) WE
CAN
ENTER,MODIFY THE
DATA
3) WE CAN
CREATE
FORMS &
REPORTS
4) WE CAN ADD CLIPART, GRAPHS.
DATA TYPES IN MS-ACCESS DB
THE DATA TYPE TELLS US WHICH TYPE
OF DATA YOU ARE ENTERING
DATA TYPE
TEXT
USED FOR
• COMBINATION OF
TEXT AND NUMBERS.
• LENGTHY TEXT AND
MEMO
NUMBERS.
• NUMBERS WITH
DECIMAL VALUES.
SIZE
225 CHARACTERS
64,000 CHARACTERS
NUMBER
16 BYTES
DATA TYPE
USED FOR
SIZE
D/TIME
• COMBINATION OF
DATE AND TIME.
8 BYTES
CURREN
• USED TO ROUNDOFF
THE VALUES.
8 BYTES
AUTO
NUMBER
• INCREMENTS VALUE BY
ONE.
4 BYTES
DATA TYPE
YES/NO
OLE OBJ
HYPERL
USED FOR
• EITHER YES/NO.
• WORD,EXCEL,PPT FILES
CAN BE LINKED TO MSACEESS.
• WE CAN STORE ANY
URL.
SIZE
1 BIT
1 GB
UPTO 64,000 CHARAC
MS-ACCESS COMPONENTS
• THE MS-ACCESS COMPONENTS ARE :
• TABLES
• QUERIES
• FORMS
• REPORTS
1) TABLE :
TABLES ARE USED TO STORE DATA IN A FORM
OF ROWS & COLUMNS.
2) QUERIES :
IN MS-ACCESS THE
QUERY IS USED TO
EXTRACT DATA FROM THE DATABASE.
3) FORMS :
FORM IS LIKE A PRINTED DOCUMENT
WHICH IS USED TO ENTER DATA.
4) REPORTS :
THE REPORTS ARE USED TO DISPLAY
DATA.
THE