service portfolio

service portfolio
haz clic en la imagen

community project

community project
haz clic en la imagen

sistem operations

sistem operations
haz clic en la imagen

technological developments

technological developments
haz clic en la imagen

software free

software free
haz clic en la imagen

16:33

THAT IS ACCESS?




In order to understand what is Access, we must understand the concept of data base.


data base: set of related, grouped information like a whole.
it is made up of:fields, registries and archives,
Field :it is the set of elements that compose a registry,
Registry: the set of related fields to each other
File: the union of several registries that contain fields such.we can understand to Access, like a computer science program with which it is possible to be managed different related files, made up of registries.



OBJECTS OF A DATA BASE ACCESS.



Tables: it contains fields and registries, we can define it as the basic unit of storage of data in a data base, that contains a category of registries normally. In the tables the information like registries is stored .
Consultations: it is one of the objects most useful of the data base Access, since by means of them we can select to information (registries) of a base data, according to certain conditions fixed by us. The result of a consultation always is record number that fulfills the criterion specified by the user.



Forms: It is a picture of dialogue designed by we ourself, who will allow us not only to enter registries a table, but also to appreciate the results of a consultation. When you have a form of registry load or consults, you will be able to appreciate by means of the information of a registry in clear and concise form.


Information: The consultations that we do to a data base give back a determined number to us of “registries in gross”. This result we can visualize it by screen through a form,
Macros: A macro is an object that allows to automate of a fast form and simple a series of actions that made of normal way would tolerate several steps.


Modules: Access provides tools that will allow to automate or to conduct battles more complex than by means of macros you could not do it. These tools are the modules that the language VBA uses (Visual BASIC for Applications) that will allow you to automate any task of your data base and of interacting or of controlling from Access other applications.






0 comentarios:

Publicar un comentario