LEARNFAST CMS

Welcome

Course Info
Course ID
140
Author
Matthew Fritz
Published
08 Jan 2013
Last Updated
08 Jan 2013

Control Panel

EDIT COURSE: Microsoft Office Access Advanced

Course Name

CRM Qualification Value

Netsuite Product

Course Level
None Beginner Intermediate Advanced

Show Page Title
Yes, Show the page title No, Hide the page title

Header Block
Information Block Contact Form Block

Information Block

Left Right

Font Colour

Background Fill
Yes No

Contact Block
Left Right

Publish

Learning Methods
Instructor-Led Classes Mentored Learning Distance Learning

Instructor-Led Classes

Online learning

Title
Microsoft Office Access 2016 Advanced

Title Background color

Block Colour

Dashboard Image

Youtube Video Url

Category

External link

Accreditation
Promo

Accredited by - MICT SETA: <a href="https://learnfast.co.za/Library/Learnfast_MICT SETA Accreditation_31 March 2021 - 30 March 2026 (1).pdf">ACC/2012/07/748</a>, US258875, NQF4, Credits: 4 (Accredited option applies at an additional fee) -This is an authorised Microsoft Official Course (MOC), a preparation course for MOS: Microsoft Office Access 730 certification exam.
Credit Details

Full Time Fee Part Time Fee Online Cost Cost Terms

Registration Fee Laptop Cost Laptop Registration Fees

Core Spec Med Spec High Spec

Laptop Terms

Terms

Installments
2M 3M 6M 9M 12M 18M 24M Early Bird Discount 10%

Page Title <div class="topBarB innerheading"> <h2>Microsoft Office Access Advanced </h2> </div>

Price Description <div class="field-content"> </div>

Payment Terms

Overview Your training in and the use of Microsoft Office Access has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access. You have worked with the various Access objects, such as tables, queries, forms and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database. This course is for individuals whose job responsibilities include working with related tables, creating advanced queries, forms and reports, writing macros to automate common tasks and performing general database maintenance.

Duration <ul> <li> Full Time: 1 Day (08:30 - 16:00) </li> </ul> 

Career Options

Financing Options

Admission Requirements <ul> <li> Microsoft Office Access: Beginners and Microsoft Office Access: Intermediate training or equivalent working knowledge. </li> </ul>

Important Notes <ul> <li> <div>Learners to arrive at the training venue from 08:00 in preparation for 08:30 starting time</div> </li> <li> <div>Bookings are only confirmed upon receipt of the proof of payment or an official company purchase order.</div> </li> <li> <div>For full day, on campus courses, Learnfast will supply you with a computer to use for training (if applicable),& tea/coffee and a full lunch. Catering is not included for On-Site training and laptops are available for hire at an additional cost if required.</div> </li> <li> <div>Cancellation or rescheduling requests must be in writing and reach us via email at least 5-10 working days prior to the course commencement date. Full course fees will be retained for no shows.</div> </li> <li> <div>Virtual learners are required to have a stable internet connection & a working headset available for sound purposes.</div> </li> <li> <div>Learners who use their own laptops are fully responsible to ensure that administration rights, software installations, etc. are working sufficiently prior to training.</div> </li> <li> <div>Learnfast reserves the right to cancel or postpone dates if we require to do so and undertake to inform clients in writing and telephonically of these changes.</div> </li> <li> <div>Learnfast is not responsible for costs associated with cancellation of classes such as flight and accommodation for clients.</div> </li> </ul> <div> </div>

CourseOutline 1. SQL and Microsoft Access <ul> <li>Importing Information</li> <li>Exporting Information</li> <li>Copying o and from Other Office Programs</li> </ul> <hr /> 2. Using the SELECT Statement <ul> <li>Selecting All Data</li> <li> Selecting Specific Data</li> <li> Selecting Conditional Data</li> <li> Using the ORDER BY Statement</li> </ul> <hr /> 3. Using SQL Joins <ul> <li>Creating Simple Joins</li> <li> Using an Alias</li> <li> Sorting Joins</li> <li> Creating Outer Joins</li> </ul> <hr /> 4. Using Subqueries <ul> <li>What is a Subquery?</li> <li> Creating a Subquery</li> <li> Subqueries with Aggregate Functions and Nested Subqueries</li> <li> Using the IN Keyword with Subqueries</li> </ul> <hr /> 5. Advanced Form Tasks, Part One <ul> <li>Limiting User Access to a Form</li> <li> Creating Checkboxes and Command Buttons</li> <li> Building Command Button Events</li> <li> Creating Event Procedures</li> </ul> <hr /> 6. Advanced Form Tasks, Part Two <ul> <li>Using Hyperlinks in a Form</li> <li>Adding Links to Other Database Objects</li> <li>Inserting a Mailto Link in a Form</li> <li>Adding a Browser Control to a Form</li> <li>Performing Calculations in a Form</li> </ul> <hr /> 7. Advanced Form Tasks, Part Three <ul> <li>Exporting Your Form to XML</li> <li>Exporting a Form as a Word Document</li> <li>Exporting a Form as HTML</li> <li>Sending a Form as an E-mail Attachment</li> <li>Exporting a Form to Other Formats</li> </ul> <hr /> 8. Creating Split Forms <ul> <li>Creating a Split Form</li> <li>Splitting an Existing Form</li> <li>Using a Split Form</li> <li>Fixing the Form Separator</li> </ul> <hr /> 9.Using Digital Signatures <ul> <li>What is a Digital Signature?</li> <li>Obtaining a Digital Signature</li> <li>Attaching Your Signature to a Database</li> <li>Extract and Use a Signed Database</li> </ul> <hr /> 10. Using the Trust Center <ul> <li>Opening the Trust Center</li> <li>Trusting a Database</li> <li>Configuring Macro Security</li> <li>Customizing the Message Bar</li> </ul> <hr /> 11. Managing COM Add-ins <ul> <li>Viewing Add-ins</li> <li>Opening the Add-in Manager</li> <li>Installing Add-ins</li> <li>Disabling All Add-ins</li> <li>Uninstalling Add-ins</li> </ul> <hr /> 12. Customizing Access <ul> <li>Changing User Information</li> <li>Changing the Office Background and Theme</li> <li>Setting the Default Database Type and Location</li> </ul>

Available Exams and Certifications

Articulation Options <div class="sp-row"> <div class="sp-col"> <div class="sp-box special-offer"> <div class="sp-box-description"> <div class="special-green"> </div> </div> </div> </div> </div>

Outcomes

Who Should Attend

Learning Methods & Delivery

Study Kit

Assessment

Career Video

Hardware Requirements

PDF Link URL

Header

Form Email

SEO / Meta Values

Notice: Undefined variable: include_seo in /home/learnfast/public_html/cadcocms/includes/seo_view.php on line 8

Notice: Undefined variable: include_seo in /home/learnfast/public_html/cadcocms/includes/seo_view.php on line 16

Meta Title

Meta Description Your training in and the use of Microsoft Office Access has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access. You have worked with the various Access objects, such as tables, queries, forms and reports.

Meta Keywords

Available Products

Microsoft Exchange Server
SharePoint
SQL
Visual Studio
Windows

Active Products

Office

Available Widgets

COMPUTER COURSES

DID YOU KNOW?

GRAPHIC DESIGN COURSES

ALL BUSINESS & SOFTSKILLS COURSES

TEST CENTRE

Contact Us

MORE OFFICE TRAINING

EXPERT PROGRAMS

OTHER SQL CERTIFICATION

OTHER SQL CERTIFICATION

OTHER CAD COURSES

OTHER EXCHANGE CERTIFICATION

OTHER SHAREPOINT CERTIFICATION

OTHER VISUAL STUDIO CERTIFICATION

OTHER WINDOWS SERVER CERTIFICATION

PRJ Management

Active Widgets

Sidebar Title

Available Testimonials Categories

Microsoft Technical Courses
General Computer Courses
Graphic And Web Design Courses
Pastel Courses
Softskills
Project Management
Learnfast Training Centre
Technical
Training & Education

Active Testimonials

Microsoft Office Courses

LEARNFAST CMS

Course Info

Control Panel