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
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
shows the table's contents as a datasheet.
Click to add column
provides another way for you to add new fields to a table
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
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.
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.
determines what field values you can enter for the field.
automatically inserts a unique number in this field for every record.
selects that entire column aka column selector
indicates that the record is being edited
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.
the specific value, or content, of a field
aka relational database, a collection of related tables.
a field, or a collection of fields, whose values uniquely identify each record in a table.
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
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.
creates a form containing all the fields in the table (or query) on which you're basing the form.
guides you through the process of creating a form.
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.
provides options for creating various database objects, including tables, forms, and reports.
provide another way to move vertically through the records.
make design changes to the form while it is displaying data.
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.
the process of making a copy of the database file to protect your database against loss or damage.
Upgrade to remove ads