Trusted Training Partners

Quick Look Course Summary:Access 2010 Advanced Course
  • Next Public Course Date:

  • Length: 1 day(s)

  • Price (at your venue): 1 Person R 4,475.00 EX VAT 3 Person R 3,399.06 EX VAT 10 Person R 2,529.41 EX VAT

  • Certification Type: Non-Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    Access 2010 Advanced Course

    Course Introduction

    This course follows on from Access essentials, in this course we focus on the advanced features of Access including maintaining a large database.

    Course Outline

    This is the second of three workshops on Access 2010. In this advanced workshop participants will learn how to use the advanced features of Access 2010. As participants will see, they can do much more in Access than they had previously learned in the Essentials workshop. Access can be used to create labels for mailing, the SQL features advanced settings which users can customise, and participants will learn how to publish a web database. At the end of the workshop participants will be able to create professional reports among many other skills. Some of the workshop objectives are: Using the Quick Start group Format both ordinary and calculated Controls Creating a sub-form; a web form; a split form; and a Pivot Table Understanding relationships and editing them Using the Property Sheet, Macros and Expression Builder TIP: Using the Quick Start group will allows you to input the same data, without repeatedly typing in the data. The Backstage view replaces the traditional File menu in Access 2010, this now provides a centralised, organised space to manage your database from; it also allows for quick editing of data and further allows for customisation of your database. There are three kinds of relationships between entries on a table. The one-to-one relationship is rare; each entry on Table 1 can only have a relationship with one entry on Table 2 and vice versa.

    The one-to-many relationship means that each entry on Table 1 can have a relationship with many entries on Table 2 but not the other way round. Basically Table 1 is the blue print here. The many-to-many relationship is the most common and entries on both tables can have relationships with each other. Creating professional reports form a large part of the workshop. We will teach participants to create a report cover page and how to use the report header to insert items in the Header of the cover page. The Page header is used for items the user wishes to include into the header of every page of the report. The Group header is used to identify the beginning of a new group. The Group footer is used to signal the end of a group. This space can be used for summaries. The Report footer is used to summarise the entire report or to report a total. We end off our workshop with a module on repairing databases using advanced database tools, and compacting a database, learners will also learnt to use the Analyse Performance Function. Lastly we teach participants how to use Expression Builder, which is also a new option available to users in Access 2010.

    1. Database Management and Security
    Importing and Exporting Data
    Copying to and from other Office Programs

    2. A User Friendly Database
    Creating Navigation Forms
    Creating Custom Categories
    Managing Available Features

    3. Project Database
    Assigning Passwords to the Database
    Splitting Databases
    Securing Databases for Distribution
    Preventing Database Problems

    4. Customise Access
    Changing Default Program Options
    Customising the Ribbon
    Customising the Quick Access Toolbar

    Course Duration

    1 day/s

    Who should attend

    This course is intended for intermediate users of Microsoft Access.

    **Quote does not include Any Exam Fees (if applicable)

    IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

    Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Leadership & Management Courses

      Software & IT Courses

      Top Rated