Microsoft Access 2007 is a part of Microsoft Office Package. It is an application software. It is a Data Base type program. It is also known as “Relational Data Base Management System” (RDBMS).
The extension name of MS Access file is “.MDB”.
Example of RDBMS software: -
• MS Access
• Oracle
• MS SQL SERVER
• IMDB 2
• Visual Fox- Pro
1) Data Base creation.
2) Table creation in Data Base.
3) Input any Data in the table.
4) Delete, Move, Copy the Data.
5) Form, Query, Report creation.
6) Import and Export the data from one location to another location.
7) Short the Data Base.
8) Filtering the Data Base.
Data Base: - Data Base is a collection of related information. In another word, Data Base is a group of related information.
Object: - An Object is a competition in the Data Base. Such as – a Table, Query, Form, Macro.
Table: - A Table is a grouping of related data organized in fields (column) and records (rows) on a data sheet.
Fields: - A Fields is a column on a data sheet and defined a data type for a set of values in a Table. For example – SL No, Name, Course, Duration, Date of Birth etc.
Record: - A record is a row on a data sheet and it is a set of value defined by fields.
Data type: - Data type is the type of value that will be entered into the fields.
There are 11 types of Date type in MS Access 2007. Their name is: -
1) Text (Maximum 255 characters)
2) Memo (32000 characters)
3) Number
4) Date / Time
5) Currency (15 + 4 characters)
6) Auto-number
7) Yes / No
8) OLE object
9) Hyperlink
10) Attachment
11) Look up wizard
Primary Key: - Primary key is a rule which is used to lock the database table. A primary key field holds a data that un quickly identified each record in a Table.
Filter: - Filter is a quick easy way that is used to find any record from a list of Table.
There are two types of Filter. They are –
• Auto Filter ( simple creation)
• Advanced Filter ( complex creation)
Form: - Form is an object of Date Base window that is primarily used to enter and display the data or record in Data Base.
The extension name of Form is “.frm”.
Control: - Control is a graphics icon that user allows on Forms and display the information.
Example: - Label box, Textbox, Command button, frame, List box, Picture etc.
Query: - Query is an object of Data Base window that is used to view, change, update, and analyzed the data in different ways.
It can also use them as a source of record for forms, reports, and Data Access pages.
Report: - Report is an object the database window that is used to present data in a printed format.
There are two ways (types) create the report. They are –
• Report design (Design View)
• Report wizard.
Macro: - Macro is an object of Data Base window which helps us to “ automated common task”.
The extension name of MS Access file is “.MDB”.
Example of RDBMS software: -
• MS Access
• Oracle
• MS SQL SERVER
• IMDB 2
• Visual Fox- Pro
Features of MS Access
The features of MS Access: -1) Data Base creation.
2) Table creation in Data Base.
3) Input any Data in the table.
4) Delete, Move, Copy the Data.
5) Form, Query, Report creation.
6) Import and Export the data from one location to another location.
7) Short the Data Base.
8) Filtering the Data Base.
Different Parts of MS Access
There are different parts of MS Access which you help you to know more about MS Access.Data Base: - Data Base is a collection of related information. In another word, Data Base is a group of related information.
Object: - An Object is a competition in the Data Base. Such as – a Table, Query, Form, Macro.
Table: - A Table is a grouping of related data organized in fields (column) and records (rows) on a data sheet.
Fields: - A Fields is a column on a data sheet and defined a data type for a set of values in a Table. For example – SL No, Name, Course, Duration, Date of Birth etc.
Record: - A record is a row on a data sheet and it is a set of value defined by fields.
Data type: - Data type is the type of value that will be entered into the fields.
There are 11 types of Date type in MS Access 2007. Their name is: -
1) Text (Maximum 255 characters)
2) Memo (32000 characters)
3) Number
4) Date / Time
5) Currency (15 + 4 characters)
6) Auto-number
7) Yes / No
8) OLE object
9) Hyperlink
10) Attachment
11) Look up wizard
Primary Key: - Primary key is a rule which is used to lock the database table. A primary key field holds a data that un quickly identified each record in a Table.
Filter: - Filter is a quick easy way that is used to find any record from a list of Table.
There are two types of Filter. They are –
• Auto Filter ( simple creation)
• Advanced Filter ( complex creation)
Form: - Form is an object of Date Base window that is primarily used to enter and display the data or record in Data Base.
The extension name of Form is “.frm”.
Control: - Control is a graphics icon that user allows on Forms and display the information.
Example: - Label box, Textbox, Command button, frame, List box, Picture etc.
Query: - Query is an object of Data Base window that is used to view, change, update, and analyzed the data in different ways.
It can also use them as a source of record for forms, reports, and Data Access pages.
Report: - Report is an object the database window that is used to present data in a printed format.
There are two ways (types) create the report. They are –
• Report design (Design View)
• Report wizard.
Macro: - Macro is an object of Data Base window which helps us to “ automated common task”.
