Tables
In relational databases and flat file databases, a table is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizontal rows. A table has a specified number of columns, but can have any number of rows. Each row is identified by the values appearing in a particular column subset which has been identified as a candidate key.


Queries
The implementation of a database, its interface, and its query language is a project far too ambitious for the scope of this book and for the Objective CAML knowledge of the reader at this point. However, restricting the problem and using the functional programming style at its best allows us to create an interesting tool for query processing. For instance, we show how to use iterators as well as partial application to formulate and execute queries. We also show the use of a data type encapsulating functional values.


Forms
A database form is a window or screen of related fields from a database. It is used to enter data or browse and view data. All forms contain a number of fields, each with a field-label . The field is a space to enter data. Forms layout the fields and field labels in a logical manner to make data entry user friendly. In a database form the input is checked against the rules for the field-type and may be additional rules, such as not null. Forms may be also checked against field or table constraints defined in a database, such as foreign keys and table relationships. OpenOffice.org Base can create database forms with the Form Wizard quickly.

Reports
With Database Reports, you can produce a printed report of the information in your database. Database Reports are generated automatically from database views.







Pages
A page is a unit of storage whose size is configurable on a system-wide, database-wide, or conglomerate-specific basis. By default, a conglomerate grows one page at a time until eight pages of user data (or nine pages of total disk use, which includes one page of internal information) have been allocated. (You can configure this behavior; see "derby.storage.initialPages" in Tuning Derby.) After that, it grows eight pages at a time.


Macros
Macro adds more functionality and control to your Access database. You can create macros to perform almost any task in your database and it is not that hard. Using macros is the next step of using building and designing your database after mastering all the basics like tables, forms, queries and reports. But it is still easier than writing VBA code for Access. You can quickly learn to use macros and automate some of your database tasks to save your time and effort. There are different macros in Access and one of them in autoexec macro.


Modules
Database modules, actually named AutoIncrementModule, contains configuration information how to retrieve a value for an auto increment column. It is possible to obtain the value before inserting a row, while inserting as part of the SQL or after successful insert. If the value is obtained before inserting, it can be generated externally. Currently, supported database management systems include HSQL, Informix, MySQL, and querying the database for the current max value.

before

after

cuty

hi!!!you know???this is my first time to have blog!!!!!...