Macros in Access can be considered like a simplified programming language that can be used to increase the functionality of the data base. For example, it can enclose a macro to a command button in a form, so the macro is executed when clicking in the button.....
A datasheet is the visual representation of the information contained in a database table, or of the results returned by a query. When you add or remove a column from a datasheet, you add or remove a field from the table that underlies the datasheet. If that field contains data, you also eliminate that information.....
Relational databases are constituted by one or more tables than contain the information in an organized form. Databases usually contain more than one table and each one will have a fixed number of fields.....
Reports summarize and present data stored on tables. A report can be executed at any time and it will always reflect the updated data of the data base....
Thanks to his improved interface and its capacities of design, that do not require deep knowledge on data bases, Microsoft Office Access 2007 facilitates the pursuit and the creation of information....
A form is a database object that can be used to write, to modify or to show the data of a table or queries. The forms can be used to control the access to the data, as what fields or rows of data are going to be showed.....
There are many ways to take data of a data base from Access to another one. The simplest method is to copy them and paste them, but importing and linking it allow you to have better control and provide greater flexibility respect to the data.....
Database normalization is the process to organize the data of a data base. It includes the creation of tables and the establishment of relations among them according to designed rules by eliminating the incoherent redundancy and dependencies....
A data base is a data collection that belongs to the same context stored systematically for later use. In this sense, a library can be considered as a data base composed by books and indexed for its query........
101 times | 
category: [Miscellaneous]
