Microsoft Access 2007: Essentials

0( 0 REVIEWS )
Overview This excellent Microsoft Access 2007 Essentials training course will teach you to navigate Access seamlessly, and to work with …


This excellent Microsoft Access 2007 Essentials training course will teach you to navigate Access seamlessly, and to work with database objects, how to convert older databases, and how to define a database. If you work in the IT industry, are an IT professional, or if you design and programme system-level software such as database systems this course is for you. This training has been designed by specialist teachers and will help you to become a Microsoft Access 2007 genius. The Microsoft Access 2007 Essentials course is an excellent fit if you plan to work in an office environment. The course will get you confident and give you the necessary skills to perform efficiently in your job role, impressing your colleagues and employer at the same time. You will achieve essential skills that employers currently look for that can help you achieve progression in the workplace.

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professionally narrated e-Learning modules, tutor support and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

  • This course will cover:
  • Who is it for?
  • Course Description:
  • Course Duration:
  • Method of Assessment:
  • Certification:
  • Entry Requirement:
  • Career Path:
  • Presenter Info
  • How to navigate Microsoft Access 2007
  • Working in the navigation pane
  • Creating tables, queries, forms, reports and macros
  • IT professionals
  • Technical IT professionals
  • Project-based technical analysts and engineers
  • Technical support personnel
  • Professionals who design and programme system-level software such as database systems, operating systems, and embedded systems

This online training course is comprehensive and designed to cover the following key modules:

  • Module 01 Introducing Access
  • Module 02 Exploring the New User Interface
  • Module 03 Working in the Navigation Pane
  • Module 04 Creating Tables
  • Module 05 Creating Queries
  • Module 06 Creating Forms
  • Module 07 Creating Reports
  • Module 08 Creating Macros

You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed the course.

Successful candidates will be awarded a certificate for Access 2007 – Essentials.

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT. 

Upon the successful completion of the Microsoft Access 2007 Essentials, you will gain an accredited qualification that will prove your skills and knowledge in Microsoft Access to potential employers. The certification will give you the opportunity to progress into multiple job roles. You will also be in line to demand for a salary increment or job promotion. Listed below are job titles you can attain, along with the average UK salary per annum according to

  • Software Engineer - £36,070
  • Business Analyst - £35,432
  • Web Developer - £25,312
  • Software Tester - £25,205
  • Technical Support - £24,451

Jeff ConradJeff Conrad is a technology enthusiast with many years of database application development expertise. Jeff began working with Microsoft Access when he saw a need at his full time position for a database solution. He bought a book on Access and began teaching himself how to use the program to solve his business’s needs. He immediately became hooked on the power and ease of working with Access.

Jeff has been an active participant in the Access newsgroups for many years where he is best known as the Access Junkie. He enjoys giving back to a community that helped him when first learning how to use Access. Jeff maintains a Web site with a wealth of information and resource links for those needing guidance with Access. Jeff also owns his own company, Conrad Systems Development, creating custom database and spreadsheet applications for the food service industry.

Jeff was awarded Microsoft’s Most Valuable Professional award from 2005 to 2007 for his continual involvement with the online Access community. He is co-author of Microsoft Office Access 2007 Inside Out and is a contributing author of Microsoft Office 2007 Inside Out. Because Jeff knows Access “Inside Out”, he recently joined Microsoft as a Software Design Engineer in Test working with Access and Excel technologies. To learn more, visit his website at

Course Curriculum

Free Introduction
Access 2007 Essentials FREE 00:00:55
Part 01
1. Defining a Database
2. Knowing When to Use Access™
3. Working with Database Objects
4. Converting Older Databases
1. Exploring the Getting Started Screen
2. Opening a Microsoft Template
3. Using the Navigation Pane
4. Using the Home Tab, Part 1
5. Using the Home Tab, Part 2
6. Using the Create Tab
7. Using the External Data Tab
8. Using the Database Tools Tab
9. Using the Office Menu
10. Explaining the Access Options
11. Using the Quick Access Toolbar
12. Adding Custom Commands to the Quick Access Toolbar
13. Using the Help Menu
14. Understanding the Message Bar
15. Creating Trusted Locations
16. Working in the Object Window
1. Displaying Categories
2. Showing Views
3. Sorting the Objects
4. Searching for Objects
5. Collapsing Groups
6. Creating Custom Groups
7. Adding Object Shortcuts
8. Hiding Custom Groups
9. Changing the Interface Mode
10. Final Comments & Credits
Part 02
1. Explaining the Datasheet Tab
2. Entering Data in a New Table
3. Using a Table Template
4. Identifying the Entities
5. Working with Design View
6. Creating DataTypes
7. Using Field Validation Rules
8. Defining Primary Keys
9. Adding Indexes
10. Working with Table Relationships
11. Creating Table Relationships
12. Defining Multi-Value Field Lookups
1. Creating a Select Query
2. Using Expressions in a Query
3. Sorting Data
4. Searching for Data
5. Selecting Data from Many Tables
6. Working in Layout View
7. Working in SQL View
8. Creating a Crosstab Query
9. Running Action Queries
10. Running Update Queries
11. Using the Query Wizard
1. Using Quick Create Commands
2. Exploring Form Types
3. Navigating within Forms
4. Using the Form Wizard
5. Creating a Form from Scratch
6. Working in Layout View
7. Working in Design View
8. Setting Form Properties
9. Using Form Controls
10. Using Control Layouts
11. Applying AutoFormats
12. Understanding Subforms
1. Using the Report Command
2. Running the Report Wizard
3. Exploring Report Views
4. Creating a Report from Scratch
5. Using Conditional Formatting
6. Grouping & Sorting
7. Setting Report Properties
8. Detailing Your Report
9. Applying AutoFormats
10. Adding Subreports
11. Alternating Record Colors
12. Filtering in Report View
13. Creating Labels
1. Working in Macro Design Mode
2. Assigning Macro Actions
3. Setting Macro Arguments
4. Running an AutoExec Macro
5. Creating Embedded Macros
6. Final Comments & Credits

Students feedback


Average rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

WhatsApp chat