Can you little-bit explain what is Database Table, Form, Report and Quarries?
“When you create a database, Access offers you Tables, Queries, Forms, Reports, Macros, and Modules. Here’s a quick overview of what these are and when to use them. Tables. All data is stored in tables. When you create a new table, Access asks you define fields (column headings), giving each a unique name, and telling Access the data type. Use the “Text” type for most data, including numbers that don’t need to be added e.g. phone numbers or postal codes. Using Wizards, Access will walk you through the process of creating common tables such as lists of names and addresses. Once you have defined a table’s structure, you can enter data. Each new row that you add to the table is called a record. To define relationships between tables, click Database Tools | Relationships in Access 2007, or choose Relationships from the Tools menu in Access 95, 97, 2000, or choose Relationships from the Edit menu (Access 1, 2). Queries. Use a query to find or operate on the data in your tables. With a query
All the information in a database is stored in tables. However, tables are not very user-friendly because they tend to contain so much information that it is difficult to take in the information at a glance. They also tend to be far too large to make much sense if they are printed. For these reasons tables are normally hidden away from the end-users of the database. Forms are just a way of seeing a single entry (called a record) from the database so the user can edit existing information or add new records. Tables can be joined to each other in relationships, which is why databases are said to be relational. This allows information from more than one table to be viewed in a form or report by using queries (not quarries) to extract selected information from several related tables. Reports are used to provide information from the database in a form that can be printed on standard sized paper. This could be something as simple as a list of names and telephone numbers taken from a single t
