5-8-2011
Microsoft glide path 2007
For Windows is a Database Management System , or DBMS. star Database shadow contain more than one table.Database created in the entrance fee 2007 format create the file extension .accdb and databases created in introductory Access formats have the file extension .mdb Using Access, We shag do the following:---------------
1 Add new data to a database , such as a new spot in an inventory ,
2. Edit existing data in the database , such as changing the current location of an item.
3.Delete study , perhaps if an item is sold or discarded.
4.organize and view the data in different ways.
5.Shargon the data with others via reports, e.mail,an internet.
The parts of an Access database:--------
1 Tables
2.Forms
3.Reports
4. Queries
5.Macros
6.Modules
Tables:---A database table is similar in appearance to a spreadsheet, in that data is stored in rows and columns As a result , it is kinda easy to import a spreadsheet into a database table.
Forms:------ Forms are sometimes referred to as Data Entry Screens
Reports:----- Reports are what we use to ingeminate and present data in the tables.
Queries:--------
Queries are the real workhorses in a database, and can perform many different functions.Their some common function is to retrieve specific data
From the tables.
Queries often serve as the record source for Forms and reports.
Macros:------
Macros in Access can be thought of as a change programming languages.
Modules:--------
A module is a collection of declarations , statements , and procedures that are stored to set upher as a unit..
Creating Databases:-------
Creating a Database using a Template:------
Access provides us wide variety of Templates That can be used to speed up the database creation process.
1. If we have a database open , click the Microsoft line button and whence click close Database to display the getting started with MS office Access page.
2. Several featured templates are displayed...If you want to get a full essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment