Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


Access 2010 and Beyond


Access 2010 and Beyond, Singapore elarning online course

Course Description

Microsoft Access is a DBMS (also known as Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Microsoft® Access® 2010 is an easy-to-use database software that helps you track and report information with ease. This training series will teach you how to use the results-oriented user interface that's context-sensitive and optimized for efficiency and flexibility. Become comfortable with the new look and feel and the many great features of Access 2010 in this online tutorial series.

Maximize your skills in Microsoft Access 2010 and beyond now!

- Use the results-oriented user interface and the many great features of Access 2010 to 2013
- Maximize your database with Microsoft Access
- Take your working knowledge of tables, queries, reports and forms to dress up your forms and reports
- Know how to build your own database with personalized tables and queries

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Know how to use the results-oriented user interface and the many great features of Access 2010
2. Be able to produce quality table, queries and reports
3. Use Pivot Tables, create relationships, charts, switchboards and macros, export and import data, use smart tags, link tables 
4. Know how to create a database, work with tables, and develop queries
5. Know how to create a form for entering data and run reports


Related Courses

  • Microsoft Visio 2013

    Microsoft Visio 2013

    SGD $40.00

    Course Description

    Microsoft Visio 2013 is a powerful diagramming tool that helps create pictures out of complex information. Business plans, processes, flowcharts, organization charts, network diagrams, and more can be easily created with a few clicks of the mouse. In this VTC course, author Brian Culp introduces you to diagram creation by looking at a variety of diagram types and then by adding and editing the shapes these diagrams contain. He then shows you how to add personal touches to your diagrams by adding text, pictures, and changing shape styles. He also demonstrates how to integrate Visio with other Office applications, allowing for easy collaboration and sharing between diagram stakeholders. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course 

    Read more...

  • Quest3D 4

    Quest3D 4

    SGD $40.00

    Course Description

    Quest3D is an innovative multimedia content creation application used to produce exciting interactive media. Whether you are working on architectural walk-throughs or video games, Quest3D's wide range of tools ensure you have what you need to build content that will engage your audience. In this VTC course, author Dwayne Ferguson will show you how to work with the Channel Graph, import 3D models, do texturing and UV mapping, create a virtual walk-through, and much more. Work files are included. Create exciting interactive media with Quest3D. - Learn about the tools and techniques available in Quest3D- Know about the different concepts in creating interactive media - Learn how you can create your own media content with this course- Know more about the wide spectrum of creating interactive media 

    Read more...

  • Produce Dynamic Presentation Slides with Microsoft PowerPoint 2013

    Produce Dynamic Presentation Slides with Microsoft PowerPoint 2013

    SGD $45.00

    Course Description

    This VTC course provides students with the knowledge and skills to use Microsoft PowerPoint 2013 for creating and making presentations. The course moves from a study of the PowerPoint interface through creating presentations with an eye towards reusing already created content whenever possible. You will learn how to add smart art objects, images, drawings, charts, and a/v content to slides. You will also learn about SkyDrive and the PowerPoint WebApp. There is a focus on using those PowerPoint features that are appropriate to the audience and presentation location. Helen Bradley teaches this course from a business perspective, introducing tools that can be used to ensure that PowerPoint presentations are consistently formatted and easy to update. She covers formatting data in tables, using the photo album tool, working with multimedia objects, and preparing a slide show for presentation. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course 

    Read more...


Content

Access 2010 - Intro Training

+
Understand the introduction to Access 2010
  • Introducing Access 2010
  • Understanding Content Security
  • Creating a Database
  • Designing a Database
  • Working with an Existing Table
  • Creating a Form for Entering Data
  • Working with Queries
  • Working with Reports

Access 2010 - Intermediate Training

+
Further your understanding of Access 2010
  • Using Access 2010 and Tables
  • Working with Field Types and Properties
  • Querying for Information
  • Working with Forms
  • Generating Reports
  • Making Forms and Reports Look Better

Access 2010 - Advanced Training

+
Complete your knowledge of Access 2010
  • Relationships & Referential Integrity
  • Tables & Fields
  • Queries
  • Forms
  • Reports
  • Charts, PivotTables, and PivotCharts
  • Switchboards
  • Macros
  • Exporting Data
  • Importing Data
  • Database Tools & Maintenance
  • Smart Tags, Startup, & Help

Access 2013 Training

+
Understand the introduction to Access 2013
  • Getting Started
  • Basics
  • Understanding Content Security
  • Creating a Database
  • Creating a Table - The First Steps
  • Working with a Table
  • Creating a Form
  • Working with Queries
  • Working with Reports
SGD $99.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.