LEARNFAST CMS

Welcome

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

Control Panel

EDIT COURSE: Microsoft Office Access Essentials

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 Essentials

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>, US116936, NQF3, Credits: 3 (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 Essentials </h2> </div>

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

Payment Terms

Overview Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be sorted, linked and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various object using the Microsoft Office Access relational database application. This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities and to understand the advantages that using a relational database application can bring to their business processes. 

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

Career Options

Financing Options

Admission Requirements <ul> <li>Good working knowledge of the Windows Operating System.</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. The Basics <ul> <li>Getting Started</li> <li>Signing In</li> <li>Creating a Database</li> <li>Database Terminology</li> <li>Saving a Database</li> <li>Opening a Database</li> </ul> <hr /> 2. Your First Database <ul> <li> About Security</li> <li>Warnings </li> <li>About Relationships</li> <li>Searching for Objects</li> <li>Opening Database Objects</li> <li>Changing the Object View</li> <li>Understanding the Types of Views Available</li> </ul> <hr /> 3. Working with Tables and Records <ul> <li>Creating a Table</li> <li>Understanding Table Views</li> <li>Adding and Editing Records</li> <li>Searching and Browsing Records</li> <li>Deleting Records</li> <li>Printing Records</li> </ul> <hr /> 4. Formatting Tables <ul> <li>Selecting Data</li> <li>Changing Column and Row Width and Height</li> <li>Applying Text Formatting</li> <li>Applying Gridlines</li> <li>Changing Fill Colors</li> <li>Checking Your Spelling</li> </ul> <hr /> 5. Creating Forms <ul> <li>Creating a Form from an Object</li> <li>Creating a Form with the Wizard</li> <li>Creating a Form from Scratch</li> <li>Understanding Form Views</li> <li>Using a Form</li> </ul> <hr /> 6. Formatting Forms <ul> <li>Understanding Bound and Unbound Controls</li> <li>Changing the Theme</li> <li>Using the Format Painter</li> <li>Adding Fields</li> <li>Adding Controls</li> <li>Adding Images and Logos</li> <li>Review Questions</li> </ul> <hr /> 7. Creating Reports <ul> <li> Creating a Report from an Object</li> <li>Creating a Report with the Wizard</li> <li>Creating a Report from Scratch</li> <li>Understanding Report Views</li> <li>Printing Reports</li> </ul> <hr /> 8. Formatting Reports <ul> <li>Changing the Theme</li> <li>Using the Format Painter</li> <li>Grouping and Sorting Data</li> <li>Adding Controls</li> <li>Adding Images and Logos</li> <li>Adding Page Numbers, Headers, and Footers</li> </ul> <hr /> 9. Creating Basic Queries <ul> <li>Types of Queries</li> <li>Creating a Query with the Wizard</li> <li>Running a Query</li> <li>Understanding Query Views</li> <li>Sorting and Filtering a Query</li> </ul> <hr /> 10. Creating Advanced Queries <ul> <li> Creating and Using Parameter Queries</li> <li>Creating and Using Crosstab Queries</li> <li>Creating and Using Make-Table Queries</li> <li>Creating and Using Multiple Table Queries</li> <li> Creating and Using Append Queries</li> <li>Creating and Using Delete Queries</li> <li>Creating and Using Update Queries</li> </ul> <hr /> 11. Managing Your Database <ul> <li>Compacting and Repairing a Database</li> <li>Encrypting a Database with a Password</li> <li>Backing Up Your Database</li> <li>Exporting a Database and Database Objects</li> <li>Printing Database Objects</li> </ul> <hr /> 12. Customizing the Interface <ul> <li>Collapsing and Pinning the Ribbon</li> <li>Customizing the Quick Access Toolbar</li> <li>Hiding and Showing Ribbon Tabs</li> <li>Creating Custom Ribbon Tabs</li> <li>Resetting Interface Changes</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 This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities and to understand the advantages that using a relational database application can bring to their business processes.

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