Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Access Titlebar
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
« 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.

Table Picture

To view data in a table:

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

Navigation Pane

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

Query

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

Form Page

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

Report

« Customize Access Database Terms Create a New Database »


Office 2007 Tutorials · Word · Excel · PowerPoint · Access

FGCU does not provide personal support for Office 2007 programs to outside parties.


© FGCU 2007. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory