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 3,982.50 EX VAT 3 Person R 2,729.81 EX VAT 10 Person R 1,885.40 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
Access 2010 Advanced 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.
Access 2010 Advanced Course :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
Securing Databases for Distribution
Preventing Database Problems
4. Customise Access
Changing Default Program Options
Customising the Ribbon
Customising the Quick Access Toolbar
Access 2010 Advanced Course: Course Duration
Who should attend: Access 2010 Advanced Course
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