portfolio

portfolio
click

networks

networks

INFORMATICA

INFORMATICA
discover this world

format

format
click

education

education
click

e difference

e difference
click

programs

programs
click

DATA BASE ACCESS AND MICROSOFT 11:35
Filed under:




DATABASE:



may be defined as a set of related information that is pooled or estructurada.Desde the standpoint of the computer, the database is a system formed by a set of data stored on disks that allow direct access to them and a set of programs that manipulate the whole work was carried datos.Este order to learn more about a database, their characteristics, uses, structures, designs, among otros.Una database is very importance in the rhythm of life we have at the present time because it is accelerating the pace at the time conducting a search for information.


MICROSOFT ACCESS

is a program management system relational database created and modified by Microsoft for use in small organizations. Is a component of Microsoft Office suite but is not included in the package "core." One possibility is to create additional database files which can be accessed by other programs. Within an information system would fall within the management category and not in the office automation as some believe. Basic concepts of a database Field: the basic unit of a database. A field may be, for example, a person's name. The field names can not start with blanks and special characters. Can not carry points, or exclamation or brackets. If you can have spaces in between. The description of a field, to clarify information regarding the names of the field. The type field specifies the type of information you carry in the field, this can be.

Written to introduce character strings up to 255


Memo: to introduce an extensive text. Up to 65,535 characters

Numeric: to enter numbers

Date / Time: to enter data into a date or time

Currency: To enter data in the number and currency AutoNumber in this field, Access automatically numbered content

Yes / No: logical field. This type of field is only if a content type Yes / No, True / False, etc.. OLE Object: To enter a photo, graphic, spreadsheet, audio, etc.. Hyperlink: we can define a link to a website

SearchWizard: Creates a field that lets you choose a value from another table or a list of values through a list box or combo box.


This program can be used for databases, design queries, forms, reports, reports

0 comentarios:

Publicar un comentario

Suscribirse a: Enviar comentarios (Atom)



© 2008 INTERACTIVE SYSTEMS
Design by Templates4all
Converted to Blogger Template by BloggerTricks.com