skip navigation
Access 2016 Tutorials

Access 2016 Tutorials

Access 2016 Tutorials - Database Terms

 
 
 Customize Access 2016 Main Menu Creating 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.

 Table

To view data in a table:

  • Click the arrow to open the navigation pane
  • Double-click on the table name to open the table

All Access 

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 duplicate queries 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

Queries 

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

Forms 

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

Reports

 Customize Access 2016 Main Menu Creating a New Database