asdeducation.net

Access

     

 

 

Basic Access Skill Sets

 

       

 

 

The Access Environment

What is Access?

Opening a new file

Using database wizards

Opening an existing database
 

 

 

The Access Environment

The database window

The design view

The datasheet view

Working with databases
 

 

 

Working with Tables

What is a Table

Fields and Records (rows & columns)

Navigating tables

Creating a table
 

 

 

Entering Data I

Moving between records

Entering a new record

Searching records

copying a record

deleting a record
 

 

 

 

 

 

 

Creating Databases

Creating a database of periodic elements lesson

How to create a chemical database

 

Creating a Student Database
 

 

 

Customizing Tables

Finding and replacing text

Entering data using autocorrect

Relocate columns

Insert columns

Rename a column

Copy a column

Change column width

changing row heights
 

 

 

Customizing Fields

Add a field

assign a data type to the field

create an input mask for the field

assign required fields

setting default values

validating data entry
 

 

 

Queries I

What is a Query

How to create a query using query wizard

Editing queries in design view

Using criteria to focus query results

Using queries to calculate values

Finding duplicate records

How to make a parameter query

How to find unmatched records
 

 

Working with Forms

What is a Form

Creating forms with form wizard

Creating a forma in design view

Modifying an existing form

Adding fields to a form
 

 

 

Creating Data Reports

What is a Report

displaying the design view

How to create a report from a table or query (design view)

How to create a report from a query (report wizard)

how to add fields to a report

how to add labels to a report

adding page numbers to a report

adding the date a time to a report

changing the size of the report section

previewing a report

auto formatting a report

changing the background color of a report

setting a background picture
 

 

 

 

 

 

 

© 2002 - 2006 The American School of Durango Education Network. All Rights Reserved
| PRIVACY | Terms of Use