Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


Provides competency in creating and using forms and sub forms, using advanced form features, reports, advanced report features, using data access pages, managing databases, and importing and exporting data.


 
Course Outline
Provides competency in creating and using forms and sub forms, using advanced form features,  reports,  advanced report features, using data access pages, managing databases, and importing and exporting data.

Course Outline SECTION 1:Advanced File Tasks
Lesson 1.1    
Using My Computer Within Access
Navigating With My Computer
Performing Basic Tasks With My Computer
Changing Views With My Computer
Using The My Places Toolbar
Lesson 1.2    
Database Management
Repairing A Database
Compacting A Database
Backing Up Your Database
Editing Database Properties
Lesson 1.3    
Saving Your Files
Using The Save As Dialog
Using Object Properties
Using Auto Recover
Lesson 1.4    
Exporting Files
Exporting To Word
Exporting To Excel
Exporting To Older Versions Of Access
Exporting Vs. Save As
Lesson 1.5    
Linking Files
Linking To An Excel Spreadsheet
Linking To Another Database
Creating A Hyperlink
Inserting An OLE Object
     
SECTION 2: Working With Tables Lesson 2.1    
Customizing Tables
Understanding Field Properties
Adding A Primary Key To A Table
Indexing A Field
Inserting, Deleting And Moving Fields
Importing A Table From Another Source
Lesson 2.2    
Formatting Tables
Formatting Text Fields
Adding Field Descriptions
Changing Field Data Types
Adding Captions
Lesson 2.3    
Controlling Table Data Entry
Setting A Default Value
Setting A Required Value
Creating And Using Input Masks
Creating And Removing Table Relationships
Lesson 2.4    
Managing Table Data Entry
How To Validate Data
Creating A Lookup Field
Modifying A Lookup Field
Creating A Value List
Modifying A Value List
     
SECTION 3: Working With Forms Lesson 3.1    
Basic Form Controls
Adding A Control
Using The Control Wizard
Cutting, Copying, Pasting And Moving A Control
Formatting A Control
Lesson 3.2    
Advanced Form Controls
Modifying A Control's Properties
Changing A Control's Data Source
Changing A Control's Default Value
Creating A Calculated Control
Using Form Properties
Lesson 3.3    
Formatting A Form
Formatting Gridline
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 366 times.