Access 2007 Advanced
Improve your understanding in the advanced abilities of Access 2007…
Course delivery method: – online tutorial or 1-day corporate workshop
This Course is just 1 of the 43 in our ‘Skills, Strategies and Solutions Series’ of:
- Online Tutorials
- Corporate Training Programs – Soft Skills Collection
So, Register NOW, gain instant access and start straight away…
How to register get started straight away:
Click ‘register’ and follow the prompts on the screen.
Access 2007 Advanced Course Outline:
Module One: Getting Started
- Workshop Objectives
Module Two: Advanced Table Tasks
- Adding, Moving, and Removing Controls
- Formatting Controls
- Setting the Primary Key
Module Three: Advanced Form Tasks
- Creating a Split-Form
- Creating a Modal Dialog
- Creating a Pivot Table
- Creating a Pivot Chart
Module Four: Advanced Reporting Tasks
- Grouping and Sorting Data
- Adding Calculated Controls
- Creating Labels
Module Five: Understanding Relationships
- Viewing Relationships
- Editing Relationships
- About Referential Integrity
- Establishing Referential Integrity
Module Six: Advanced Query Tasks
- Adding Calculated Fields
- Using the Expression Builder
- Using Logical Functions
Module Seven: Working with SQL
- What is SQL?
- Understanding SQL Statements
- Basic SQL Syntax
- Uses for SQL in Access
Module Eight: Linking Data
- Linking to an Excel Spreadsheet
- Linking Access Database
- Linking to a SharePoint List
- Linking to a Text or XML File
- Other Types of Links
Module Nine: Importing Data
- Importing from an Excel Spreadsheet
- Importing from an Access Database
- Importing from a SharePoint List
- Importing from a Text or XML File
- Other Types of Imports
Module Ten: Exporting Data
- Saving an Object as PDF
- Exporting to an Excel Spreadsheet
- Exporting to a SharePoint List
- Exporting to a Word or Text File
- Other Types of Exports
Module Eleven: Advanced Database Tools
- Using the Database Documenter
- Analyzing Table Performance
- Analyzing Database Performance
- Compact and Repair a Database
Module Twelve: Wrapping Up
- Words from the Wise
Enrolment Process
You can enrol and start on your course today!
1. Click the ‘Enrol Now’ tab to begin the buying process.
2. Your cart will show that you can buy more than one copy of this course. You can add other courses by going back to the courses page and selecting another course of your choice. Click ‘add to cart‘ to add a new course to your purchase. Click ‘proceed to checkout‘ on the right hand side of the page, when you have finished shopping.
3. The next page will display your order information. Click ‘next’ to continue.
4. If you are a new customer you need to register an account under the registration column. NB. Make sure you remember your username and password as this information grants you access to your online tutorial (course). If you are an existing member (customer) of Global Training Institute, you can ‘login‘ on the left side of the page. Click ‘next‘ to go to the payment page.
5. On this page you can choose your payment method, either bank transfer or PayPal (Accepts credit card or your PayPal account). Read the terms and conditions and check the box. You will receive an order invoice in your email inbox. Click ‘next’ to continue.
6. You will be redirected to PayPal, where you can complete the payment process.
7. Your course will be approved within our next office day and an email will be sent to confirm your course is online and available for you to commence.
8. Enjoy your online training experience and we trust that you will gain new skills and knowledge through doing your tutorial.
Start today!
Click the Button Below to Enrol in a Short Course and Start Today!
Enrol Now
How long does the course take?
1 week with (24 months access) depending how much time you can allocate to completing your Short Course
Online Prerequisites
- Computer Pc or Mac
- Google Chrome or Firefox 10+
- Internet Connection