Database Terms - III

« Cutomize Access Database Terms Create a New Database » Table A table is a collection of information arranged in rows and columns.  Information about an item is displayed in a row.  Columns contain the same type of information for each item.  The table has a header row that tells you what data is contained in the columns. To view data in a table: Click the arrow to open the navigation pane Double-click on the table name to open the table Query Queries select records from one or more tables in a database so they can be viewed, analyzed, and sorted on a common datasheet. A query can also perform calculations and display the results.  The resulting collection of records, called a dynaset (short for dynamic subset), is saved as a database object and can therefore be easily used in the future. The query will be updated whenever the original tables are updated. Types of queries are select queries that extract data from tables based on specified values, find duplicatequeries that display records with duplicate values for one or more of the specified fields, and find unmatched queries display records from one table that do not have corresponding values in a second table. To run a query: Click the arrow to open the navigation pane Double-click on the query name Recordset A recordset is a table that displays groups of records from a base table or as a query result.  Form A form is a graphical interface that is used to display and edit data.  Forms can be developed from a table or a query.  Forms can include calculations, graphics and objects. To view data using a form: Click the arrow to open the navigation pane Double-click on the form name Report A report is an output of data arranged in the order you specify.  Reports can perform calculations and display the results.  Reports can be used to print data. To view data using a form: Click the arrow to open the navigation pane Double-click on the report name