Microsoft Office 2007 Access Advanced - Complete Video Course

(7 Reviews)

stds487 Students

stds

GET ACCESS TO THIS COURSE ALONG WITH 2500+ COURSES FOR A YEAR FOR JUST £49. GET NOW

Description:

This Microsoft Office 2007 Access Advanced – Complete Video Course builds on knowledge gained in the introduction and intermediate levels. This advanced series will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. You will also learn to automate functions by creating simple and then very advanced macros, advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects and the fundamentals of database management. Finally, you will be taught how to protect your valuable data sources.

Before getting this course you must have the basic and intermediate skills of Microsoft Office 2007. This level will give you an advanced knowledge you need to know about Microsoft Office 2007. By taking this course you will have a complete understanding of the higher functions of Access.

Assessment:

  • At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.
  • Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

  • After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.
  • Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

Microsoft Office 2007 Access Advanced – Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our Microsoft Office 2007 Access Advanced – Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

  • video SQL and Access
    00:02:00
  • video Examining an SQL Statement in Access
    00:02:00
  • video Writing SQL Statements
    00:03:00
  • video Writing an SQL SELECT Statement
    00:04:00
  • video Using the WHERE Clause
    00:02:00
  • video Creating Aliases
    00:04:00
  • video Displaying Matching Records from Related Tabs
    00:03:00
  • video Finding Unmatched Records
    00:03:00
  • video Getting Context-Sensitive Help in SQL
    00:01:00
  • video Attaching SQL Queries to Controls
    00:02:00
  • video Assigning a SQL-Specific Query to Controls
    00:04:00

What Our Students are Saying

 

Other Students Also Bought

courseImg
star
£18 ex Vat
courseImg
star
£24.99 ex Vat
courseImg
star
PRIVATE
2
  • Item added to cart
  • Item added to cart
2
Your Cart

SPRING SALE – All Courses For Just £49/ year

ADD OFFER TO CART

No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

    Apply Coupon