Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


This course is intended as a starting point for Access beginners, or people who use databases created by others. The main focus is to learn how to create tables and queries. A brief look at forms and reports is also covered.


 
Course Outline

This course provides the first step in learning how to use this powerful database program.  The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data.  Forms and Reports are briefly introduced using the Wizards provided.

This course is classroom style instruction: Instructor-led, hands-on training.

Overview
What is a Database?
Database Objects in Access
Creating / Opening Databases

Tables (Design View)
Creating a Table
Adding Fields
Field Data Types
Saving
Insert Fields
Moving Fields
Change Field Name
Change Field Data Type
Field Size
Format & Decimal Places
Default Value
Caption
Validation Rule/Text
Required
Allow Zero Length
Indexed
Input Mask

Tables (Datasheet View)
Entering Data
Adding Pictures
Zoom and Line Breaks
Column Widths/Row Height
Navigating Records
Formatting Cells
Hiding Columns
Freezing Columns
Cut, Copy & Paste
Deleting Records
AutoNumbers
Sorting
Finding
Filter by Selection
Filter by Form
Save Filter as Query

Queries
Creating Queries
Adding Fields to Grid
Entering Criteria
Running a Query
Sorting and Hiding
Saving a Query
Moving Columns
Performing Calculations
Formatting Columns
Parameter Queries
Totals Queries

Forms
AutoForms
Design & Form Views
Moving/Sizing Controls
Edit Text Labels
The Form Header/Footer
Entering Data in the Form

Reports
AutoReports
Report Bands
Adjusting Controls
Merging Fields
Previewing and Printing

Database Objects
Rename Objects
Making a Copy
Deleting Objects

 


Prerequisites & Certificates
Pre-Requisites

Course Prerequisite: Required: Knowledge of Windows Introduction topics and ability to use keyboard and mouse. Recommended: Use of one or more other programs, such as Excel or Word.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion


Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 730 times.