• Course
  • Vendor

Topics included in this 1-day course: Producing Advanced forms; Working with field/record level data validation; Automating tasks using macros; Distributing and securing database; Creating a switchboard...

  • Course Start Date: 2019-10-30
  • Time: 08:30:00 - 16:30:00
  • Duration: 1 Day(s)
  • Location: Vancouver
  • Delivery Methods(s): Instructor Led
$329.00
October 30th
Click for more dates
2 seats left!
or make an offer

Course Outline

Pre-Requisites

Microsoft Access 2013 Level 2 or equivalent experience

Lessons

Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.

Objectives
  • Producing Advanced forms
  • Working with field/record level data validation
  • Automating tasks using macros
  • Distributing and securing database
  • Creating a switchboard
Outline
  • Lesson 1: Implementing Advanced Form Design
    • Topic A: Add Controls to Forms
    • Topic B: Create Subforms
    • Topic C: Organize Information with Tab Pages
    • Topic D: Enhance Navigation of Forms
    • Topic E: Apply Conditional Formatting
  • Lesson 2: Using Data Validation
    • Topic A: Field and Record Validation
    • Topic B: Form Validation
  • Lesson 3: Using Macros to Improve User Interface Design
    • Topic A: Create a Macro
    • Topic B: Restrict Records Using a Condition
    • Topic C: Validate Data Using a Macro
    • Topic D: Automate Data Entry Using a Macro
    • Topic E: Convert a Macro to VBA
  • Lesson 4: Using Advanced Database Management
    • Topic A: Link Tables to External Data Sources
    • Topic B: Manage a Database
    • Topic C: Determine Object Dependency
    • Topic D: Document a Database
    • Topic E: Analyze the Performance of a Database
  • Lesson 5: Distributing and Securing a Database
    • Topic A: Splitting a Database for Multiple User Access
    • Topic B: Implement Security
    • Topic C: Set Passwords
    • Topic D: Convert an Access Database to an ACCDE File
    • Topic E: Package a Database with a Digital Signature
  • Lesson 6: Managing Switchboards
    • Topic A: Create a Database Switchboard
    • Topic B: Modify a Database Switchboard
    • Topic C: Set Startup Options

Cancellation Policy

Should you postpone or cancel your course you must give 5 business days notice.

Training Location

On Track New Location
609 Granville Street 6th Floor

Vancouver, BC
Canada   

About On Track Computer Training

x

For the best in Microsoft Excel Training in Vancouver, or any other Microsoft product training, including Access, Word, Outlook, PowerPoint or Project training come to On-Track Computer Training. In addition to Microsoft program we also offer: Dreamweaver MX training FrontPage training HTML training courses Flash MX & CS3 training Acrobat 7.0 Professional Illustrator CS2 & CS3 training InDesign CS2 & CS3 training Photoshop CS2 & CS3 training MS Publisher 2003 Visio 2002 training and much more in the Vancouver area. On-Track Computer Training Ltd. has been providing corporate computer training since 1989 and has established itself as a leader in innovative training, consulting and development. As a Microsoft GOLD Certified Partner On-Track continually strives to achieve the best in computer training and guarantees results and rates through our client satisfaction program. GUARANTEE'S Results: On-Track will retrain you at our cost if you are unable to understand objectives and provide complimentary refresher courses within 6 months Rates: On-Track will beat any written corporate computer training rate Support: On-Track provides free technical support through our email and phone system for those difficult situations Service: On-Track staff are all owners of the company and take pride in the service we offer

Training Provider Rating

This vendor has an overall average rating of 4.36 out of 5 based on 146 reviews.

I was expecting to see and learn more advanced materials like pivot point and vlookup in Level 2, but they are in level 3 so I ha ... Read more
x

I was expecting to see and learn more advanced materials like pivot point and vlookup in Level 2, but they are in level 3 so I have to come back for level 3.

She did a wonderful job with our group. It was fun and educational.
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
Great course, great teacher.
No comment
No comment
No comment
No comment
Course was more than I had expected and the trainer was very pleasant and enjoyable to learn from!
Learned what I needed and more. Good class size.
No comment
No comment

Course Reviews

No Reviews Yet

More Courses from On Track Computer Training

ON TRACK COMPUTER TRAINING
2019-10-15
Vancouver
ON TRACK COMPUTER TRAINING
2019-09-23
Vancouver
ON TRACK COMPUTER TRAINING
2019-10-23
Vancouver
ON TRACK COMPUTER TRAINING
2019-10-18
Vancouver

More Courses in 'Microsoft Access Training Seminars and Courses' Category

ON TRACK COMPUTER TRAINING
2019-10-16
Vancouver
GLOBAL KNOWLEDGE
2020-03-04
Vancouver
GLOBAL KNOWLEDGE
2020-01-02
Vancouver
GLOBAL KNOWLEDGE
2020-03-02
Vancouver