Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


This course provides competency in database fundamentals, working with Access objects, creating databases & tables, working with table data &structure, working with related tables, using select queries & advanced query features, creating advanced queries


 
Course Outline

This course provides competency in database fundamentals, working with Access objects, creating databases & tables, working with table data &structure, working with related tables, using select queries & advanced query features, creating advanced queries.

Course Outline SECTION 1: Starting Out Lesson 1.1    
Starting Out
What is Microsoft Access
What is new in Access 2003
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing Microsoft Access
Lesson 1.2   
Using The Access Interface
Using The Access Menus
Using Access Task Panes
Using Toolbars
Adding, Removing, And Moving Toolbars
Using The Switchboard
Using The Database Window
Lesson 1.3    
Getting Help
Using The Help Menu
Using The Help Task Pane
Using The Office Assistant
Configuring The Office Assistant
Using The Type A Question Box
Getting Help In A Dialog Box
Using The Sample Databases
     
SECTION 2:  Creating A Database Lesson 2.1    
First Steps
Planning A Database
Creating A Blank Database
Using Database Objects
Lesson 2.2    
Records
What Is A Record?
Adding Records
Editing Records
Deleting Records
Printing Records
Lesson 2.3    
Creating A Table
About Tables
Creating A Table In Design View
Creating A Table Using The Wizard
Entering Data Into A Table
Formatting A Table
Lesson 2.4    
Formatting Text
Using The Zoom Toolbar
Selecting Data
Cutting, Copying And Pasting
Using The Format Painter
Using Undo And Redo
Checking Your Spelling
Lesson 2.5    
Formatting Controls
Changing The Color Of A Control
Using Control Properties
Aligning Controls
Applying Special Effects
     
SECTION 3: Doing More With Your Database
Lesson 3.1    
Creating Forms
What Is A Form?
Bound Vs Unbound Controls
Creating A Form With The Wizard
Creating A From In Design View
Using Forms
Lesson 3.2    
Creating Queries
What Is A Query?
Creating A Query With The Wizard
Using Design View To Modify A Query
Using Queries 
Lesson 3.3    
Reports
What Is A Report?
Creating A Report With The Wizard
Creating A Report In Design View
Using Reports
Lesson 3.4    
Sorting And Filtering Data
Using Find And Replace
Sort Ascending Or Descending
Using Filter By Form
Using Filter By Selection
Creating A Filter
     
SECTION 4:  Viewing And Printing Your Data Lesson 4.1    
Formatting A Data Sheet
Adjusting Row Height And Column Width
Rearranging Columns
Freezing A Row Or Column
Hiding A Column
Changing The Datasheet Font
Lesson 4.2    
Viewing Data
Using The View Menu
Using The Window Menu
Hiding And Unhiding Windows
Arranging Windows
Closing Individual Windows
Lesson 4.3    
Printing A Database Object
Using The Print Icon
Using Print Preview
Using Page Setup 
Prerequisites & Certificates
Pre-Requisites

Certificates offered

Certificate of completion


Cancellation Policy
Commitment of resources and industry standards require that we be notified of any cancellation. As such, you may reschedule any training course up to five (5) working days before the actual training date. Simply call us, and we send you a new registration confirmation without extra charge. If training is rescheduled less than five (5) working days before the training date, a rescheduling fee of 50% of the course fee will be invoiced.

The latest time we accept rescheduling is until noon on the working day before
the training date. "No-shows" without prior notification are charged as if you had attended the course. There are no refunds. We reserve the right to cancel any course and reschedule if attendance is not sufficient to run the course. In this case you will be notified, usually five (5) working days or more prior to the
training day and the training is rescheduled.

Map & Reviews
Careers in Transition
[ 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 222 times.