A database is a collection of similar information, storing it on a computer provides a means of analysing and manipulating this information. The database can store just about any type of information, including numbers, pages of text, and pictures. The database also ranges wildly in size. Its structure makes the information easy to select, sort, display, and print in a variety of formats. With access, you can create and maintain as many databases as you need.
Microsoft Access is a general purpose program that works with almost any kind of information. Access 2007 is the Microsoft database management program that enables you to maintain a database.
To start Microsoft Access 2007
Click on start>all program>microsoft office>microsoft office access 2007
1. Choose the Run....option after clicking the start button.
2. Type ms access in the open
3. Then click ok
TERMINOLOGY USED IN MS ACCESS
1.Fields: A field contains a single piece of information such as name, city, street address or phone number.
2.Records: A record consists of one or more fields. A student record can have Roll No, Name, Address, and City as its fields.
3.Tables: A table displays records in rows and columns, much like a spreadsheet. A table group related record., such as records of all students or records of all account holders.
4. Forms: A form displays all the fields of a single record onscreen, just like a paper form, so that you can add, edit or view a single record at a time,
5. Queries: A query lets you retrieve certain information based on your criteria such as only retrieving roll numbers and names of a student who scored more than 75% marks in a certain examination.
6. Reports: A report arranges your data in a certain way, such as showing all the students who have scored more than 75% marks in an exam.
CREATING A NEW DATABASE-
In access, every database is stored in a single file. Access can create a blank database or a database using one of many templates available locally on your hard disk or from the Microsoft web site. However, you always need to modify a database created from a template.
1. Click Office button > New option
2. Type the new name of the database file. The default name of the database is Database 1.
3. Click the Browse icon to specify a different folder or drive to store the database if you wise to.
4. Click Create. You will notice that the extension of a database in Access 2007 is .accdb.
CREATING A NEW TABLE-
Tables are the most basic building block in your database- they hold the data that you need to save and to analyze. Tables are the main way if displaying data in Microsoft Access. All data is stored in tables. One database can have many different tables, but each table should concentrate on one subject only, for example, the products that a company sells or the customers that the company has. The rows in the table represent the records of the database. The columns represent the fields.
When you first create a database, it's almost empty. But in order to get you started, Access creates your first table named Table 1. The problem is, this table begins life completely blank, with no defined fields(and no data).
When you create a new database, you are in the Datasheet view in which you can display the records in a table, where one row is one record. The columns headers are the fields you have defined for the table. When you create a database, Access automatically creates a special ID field to help you sort and organize your data. You don't have to use this ID field if you don't want to.
In the design view, you can view all the fields with the data types and descriptions. The records of information that has been added to the database are not viewable.
To go to the design view, click the view button in the datasheet tab and choose a design view option.
As soon as you choose the design view, Access 2007 asks you for a table name by displaying the Save As dialog box.
Microsoft Access is a general purpose program that works with almost any kind of information. Access 2007 is the Microsoft database management program that enables you to maintain a database.
To start Microsoft Access 2007
Click on start>all program>microsoft office>microsoft office access 2007
1. Choose the Run....option after clicking the start button.
2. Type ms access in the open
3. Then click ok
TERMINOLOGY USED IN MS ACCESS
1.Fields: A field contains a single piece of information such as name, city, street address or phone number.
2.Records: A record consists of one or more fields. A student record can have Roll No, Name, Address, and City as its fields.
3.Tables: A table displays records in rows and columns, much like a spreadsheet. A table group related record., such as records of all students or records of all account holders.
4. Forms: A form displays all the fields of a single record onscreen, just like a paper form, so that you can add, edit or view a single record at a time,
5. Queries: A query lets you retrieve certain information based on your criteria such as only retrieving roll numbers and names of a student who scored more than 75% marks in a certain examination.
6. Reports: A report arranges your data in a certain way, such as showing all the students who have scored more than 75% marks in an exam.
CREATING A NEW DATABASE-
In access, every database is stored in a single file. Access can create a blank database or a database using one of many templates available locally on your hard disk or from the Microsoft web site. However, you always need to modify a database created from a template.
1. Click Office button > New option
2. Type the new name of the database file. The default name of the database is Database 1.
3. Click the Browse icon to specify a different folder or drive to store the database if you wise to.
4. Click Create. You will notice that the extension of a database in Access 2007 is .accdb.
CREATING A NEW TABLE-
Tables are the most basic building block in your database- they hold the data that you need to save and to analyze. Tables are the main way if displaying data in Microsoft Access. All data is stored in tables. One database can have many different tables, but each table should concentrate on one subject only, for example, the products that a company sells or the customers that the company has. The rows in the table represent the records of the database. The columns represent the fields.
When you first create a database, it's almost empty. But in order to get you started, Access creates your first table named Table 1. The problem is, this table begins life completely blank, with no defined fields(and no data).
When you create a new database, you are in the Datasheet view in which you can display the records in a table, where one row is one record. The columns headers are the fields you have defined for the table. When you create a database, Access automatically creates a special ID field to help you sort and organize your data. You don't have to use this ID field if you don't want to.
In the design view, you can view all the fields with the data types and descriptions. The records of information that has been added to the database are not viewable.
To go to the design view, click the view button in the datasheet tab and choose a design view option.
As soon as you choose the design view, Access 2007 asks you for a table name by displaying the Save As dialog box.
No comments:
Post a Comment