40 terms

Access Tutorial 1

Microsoft Access 2010
a computer program used to enter, maintain, and retrieve related data in a format known as a database.
Shutter Bar Open/ Close Button
allows you to close and open the Navigation Pane
Navigation Pane
the area that lists all the objects (tables, reports, and so on) in the database, and it is the main control center for opening and working with database objects
Datasheet view
shows the table's contents as a datasheet.
Click to add column
provides another way for you to add new fields to a table
Fields tab
provides options for adding, removing and formatting the fields in a table
Add & delete group
contains options for adding different types of fields, including Text and Currency, to a table
Access Window
the program window that appears when you create a new database or open an existing database.
displays the table's contents in rows columns, similar to a table that you create in a Word document or an Excel spreadsheet.
ID column
created by Access as the primary key field for all new tables.
Database Management System
a software program that lets you create databases and then manipulate data in them.
Relational Database Management System
data is organized as a collection of tables.
a predesigned database that includes professionally designed tables, reports and other database objects that can make it quick and easy for you to create a database.
Data Type
determines what field values you can enter for the field.
automatically inserts a unique number in this field for every record.
field selector
selects that entire column aka column selector
pencil symbol
indicates that the record is being edited
star symbol
identifies the second row as the next row available for new record.
current record box
displays the number of the current record as well as the total number of records in the table.
a single characteristic or attribute of a person, place, object , event or idea.
is collection of fields that describes a person, place, object, event or idea.
field value
the specific value, or content, of a field
aka relational database, a collection of related tables.
primary key
a field, or a collection of fields, whose values uniquely identify each record in a table.
foreign key
a primary key from one table as a field in a second table to form a relationship between the two tables.
a database object you use to enter, edit, and view records in a database
Query Wizard
opens a dialog box with different types of wizards that guide you through the steps to create a query.
Simple Query Wizard
allows you to select records and fields quickly to display in the query results.
a question you ask about the data stored in a database.
Form tool
creates a form containing all the fields in the table (or query) on which you're basing the form.
Form Wizard
guides you through the process of creating a form.
Report Tool
places all the fields from a selected table (or query) on a report, making it the quickest way to create a report.
a formatted printout (or screen display) of the contents of one or more table (or queries) in a database.
Create tab
provides options for creating various database objects, including tables, forms, and reports.
navigational buttons
provide another way to move vertically through the records.
Layout View
make design changes to the form while it is displaying data.
Print Preview
shows exactly how the report will look when printed.
All access objects
lists all the database objects in the pane
rearranges the data and objects in a database to decrease its file size.
Backing up
the process of making a copy of the database file to protect your database against loss or damage.