Microsoft Access is a management system relational database (DBMS). A database is usually defined as a set of systematically organized information. In the terminology of databases, there are three key concepts in the tables, fields, records and data.A field is each of the types of data to be used. Reference is made to the fields by name.A record consists of the set of information in particular.Data is the intersection between a field and a record.
Elements of Access
Tables
Tables with basic or elemental component of the databases. Or what is the same, a database is primarily composed of multiple related tables. The tables contain data on something or someone, suppliers, customers, library books, purchasing, sales, etc.
Consultations
Queries are questions that a user makes to the database. With them you can get information from multiple tables and the structure that interests you. Also, queries can be archived so that the next time you want to ask the same question you will not need to raise it, it is sufficient to call the previously created query. The importance of consultation is huge, in fact, the power of this tool that allows database administrators are almost indispensable in our daily work.
Forms
The forms are a mechanism that greatly facilitates the general surgical tables, especially when it comes to display, enter and modify data. Proper use of these resulting quite at the level of usability of an application or an information system developed with Access.
Reports
Reports allow you to present information with a highly professional appearance when printed our data.
Data Access Pages
A data access page is a Web page that can be used to add, edit, view or manipulate current data in a database in Microsoft Access or SQL Server. You can create pages that will be used to specify and modify data, similar to Access forms. You can also create pages that display records grouped hierarchically, similar to Access reports.
HERE YOU'LL SEE MS ACCESS DATABASE OF GENERAL SERVICE
http://www.4shared.com/file/FSvwwfdl/SAAE_2_.html
No hay comentarios:
Publicar un comentario