Table And Query
Overview: In a relational database the data is stored in tables. The table is the fundamental concept of relational databases. It is also called relation. It is the foundation of every Relational Database Management System is a object called table. Tables are grids that store information in a database similar to the way an Excel worksheet stores information in a workbook. Access provides three ways to create a table for which there are icons in the Database Window. Double-click on any of the icons to create a able. Every database consists of one or more tables which store data. Each table has its own unique name and consists of columns and rows. It is a very convenient way to store information. The columns in a table (also called table fields) have their own unique names and have a pre-defined data type. The field can be a primary key, an index defined on i and i can have certain default value. The able columns describe he data types,