Access 2007 Essentials

Improve your understanding in the essentials 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 Essentials Course Outline:

Module One: Getting Started

• Icebreaker
• Housekeeping Items
• Pre-Assignment Review
• Workshop Objectives
• Action Plans And Evaluation Forms

Module Two: Opening And Closing Access

• Common Database Terms
• Opening Access
• Understanding The Getting Started Window
• Creating A Blank Database From A Template

Module Three: Using The Access Interface

• Understanding Security Warnings
• Interface Overview
• Overview Of The Ribbon Interface
• Using the Navigation Pane

Module Four: Working With Database Objects

• Viewing Database Objects
• Exporting An Object
• Renaming An Object
• Sorting And Filtering Your View

Module Five: Creating Tables

• Creating A Blank Table In Datasheet View
• Creating A Blank Table In Design View
• Creating A Table From A Template
• Adding A Table From A SharePoint List
• Key Features On The Table Tools Tabs

Module Six: Working With Tables

• Adding Information To A Table
• Editing Records
• Deleting Records
• Searching For Records

Module Seven: Creating Forms

• Types Of Controls
• Creating A Form With The Wizard
• Creating A Form In Layout View
• Modifying Your Form In Design View
• Key Features On The Form Tools Tabs

Module Eight: Working With Forms

• Common Formatting Tasks
• Using AutoFormat
• Adding Controls
• Moving Controls
• Deleting Records

Module Nine: Creating Reports

• Using The Report Wizard
• Using Design View
• Adding A Logo
• Working With Controls
• Key Features On The Report Tools Tabs

Module Ten: Creating Queries

• Types Of Queries
• Creating a Query With The Wizard
• Executing A Query
• Viewing The Query
• Key Features On The Query Tools Tabs

Module Eleven: Managing Your Database

• Using Alternate File Formats
• Printing An Object
• Backing Up Your Database
• E-mailing Your Database

Module Twelve: Wrapping Up

• Words from the Wise
• Parking Lot
• Action Plans and Evaluations

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 ‘nex’t 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.