1. Home
  2. Course
  3. Microsoft Access 2007 Advanced

Microsoft Access 2007 Advanced

  

About this Course

This instructor led course empowers the participants to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. 

The participants shall be able to use the database to organize, extract, view and report on data using what are deemed to be advanced data management skills. The participant shall understand the variety of ways that data can be related and organized. In addition the candidate shall be able to run and record simple macros and to import, export and link data.

COURSE OUTLINE

Module 1. Designing Advanced Queries

Module 2. Creating Action Queries

Module 3. Using Advanced Query Wizards

Module 4. Using Advanced Form Design

Module 5. Using Advanced Report Design

Module 6. Using Subforms/Subreports

Module 7. Using Other Form Techniques

Module 8. Creating Macros

Module 9. Using Macros

Module 10. Using Advanced Database Features

Module 11. Exporting Data

Module 12. Replicating Database

PRE-REQUISITE

An understanding of Windows / MS Access 2000 to MS Access 2003 will be an added advantage.

Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Other Similar Courses Provided By COMAT TRAINING SERVICES PTE LTD

  • MCSD SharePoint Applications

    Information and Communications  

    Earning an MCSD: SharePoint Applications certification will qualify you for such jobs as software developer or web developer.MODULESProgramming in HTML5 with JavaScript and CSS3Developing ASP.NET MVC Web ApplicationsDeveloping Microsoft SharePoint Server 2013 Core SolutionsDeveloping Microsoft SharePoint Server 2013 Advanced Solutions FORMAT & PACKAGEFormatCombination of instructor presentations ...


    Provider:

  • MCSA Windows 7

    Information and Communications  

    The MCSA Windows 7 certification validates a set of core Windows 7 skills and aimed at those individuals who need to support, manage and maintain Windows 7 devices.Course Installing and Configuring Windows 7 ClientTroubleshooting and Supporting Windows 7 in the EnterpriseTARGET AUDIENCEThese courses are intended for IT Professionals who work with Windows 7 environment.Pre-requisiteCandidates ...


    Provider:

  • ICDL Module 9 Image Editing

    Information and Communications  

    In this 3 days course, participants will learn the main concepts underlying digital images and to use Photoshop Cs4 /Cs5 to enhance images, apply effects, and prepare an image for printing. Participants will also learn the techniques to capture and save an image, use various selection tools, and manipulate images.COURSE OUTLINEModule 1. Imaging ConceptsModule 2. Graphic FormatsModule 3. Colou...


    Provider:

  • ICDL Module 5: ES WSQ - Perform Database Functions (Microsoft Access 2010 Fast Track)

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Database Functions Database exam.The exam requires the candidate to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The module is divided in two sections; the first section tests the candidate's ability to design and plan a simple database ...


    Provider:

  • ICDL Module 5: ES WSQ - Perform Advanced Database Functions (Microsoft Access 2010) Fast Track

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.The exam requires the candidate to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The candidate shall be able to use the database to organize, extract, view and report on data using what are dee...


    Provider: