Introduction to Microsoft Access 2007


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
• IMDB 2
• Visual Fox- Pro

Introduction to Microsoft Access 2007

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”.



Computer,9,MS Office,2,Visual Basic,8,
Computercoursestudy: Introduction to Microsoft Access 2007
Introduction to Microsoft Access 2007
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy