Access Tutorial 1

Created by Nyneve 

Upgrade to
remove ads

40 terms

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.

datasheet

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.

template

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.

Autonumber

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.

field

a single characteristic or attribute of a person, place, object , event or idea.

table

is collection of fields that describes a person, place, object, event or idea.

field value

the specific value, or content, of a field

database

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.

form

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.

query

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.

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

Compacting

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.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

NEW! Voice Recording

Click the mic to start.

Create Set