SYSTEMS TODAY

Order data .- In everyday life is continually interacts with entities such as individuals, or other documents. In a corporation, the entities are represented by the operators, employees, customers, suppliers, invoices. We would be in a hospital with doctors, patients, nurses, clinical pictures, etc.. Since in each case has to deal with a large amount of data, there arises the need to store so that we are easily accessible at all times and, therefore, useful to our activities. If for example every day we need to manage dozens of clients and invoices, using a system to store data,

such as a file, rather than rely solely on memory Objects from the database Tables: drive where we create the dataset from our database. These data are arranged in vertical columns. Here we define the fields and their characteristics. Later we will see what a field.

Consultations: here we define the questions to the database in order to extract and present the resulting information in different ways (screen, printer

Form: form element in the form of allowing the management of data in a more visibly appealing and comfortable.

Macro: a set of instructions that can be stored to automate repetitive tasks.

Module: a set of instructions or in Visual Basic language : 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. A description of the 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 Search Wizard: Creates a field that lets you choose a value from another table or a list of values through a list box or combo box. Registration: is the set of information about a person or object. A record would be something like a tab.