• LOGIN
  • No products in the cart.

Description:

This Microsoft Office 2007 Access Beginners – Complete Video Course will allow you to get started quickly with prebuilt applications that can modify or adapt to changing business needs. Collect information through form in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Sharing information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permission, and back up your information at regular intervals.

This series will provide you an overview of the features and functions of Microsoft Office Access 2007. If you are interested to learn all the basics of Microsoft Access 2007, then you should join this course now.

So, if you want to learn beginning level Access 2007 Skills.

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 Beginners – 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 Beginners – 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.

Course Curriculum

Getting Started
MS Access 2007 Basic Course 1 Topic A Database Concepts 00:05:00
MS Access 2007 Basic Course 1 Topic A – Demo 1 – Indentifying Database Components 00:04:00
MS Access 2007 Basic Course 1 Topic B Exploring the Access Environment 00:03:00
MS Access 2007 Basic Course 1 Topic B – Demo 1 – Starting Access and Examining the Access Window 00:06:00
MS Access 2007 Basic Course 1 Topic B – Demo 2 – Opening a Database 00:04:00
MS Access 2007 Basic Course 1 Topic C Getting Help 00:01:00
MS Access 2007 Basic Course 1 Topic C – Demo 1 – Using Help 00:03:00
Databases and Tables
MS Access 2007 Basic Course 2 Topic A Planning and Designing Databases 00:05:00
MS Access 2007 Basic Course 2 Topic A – Demo 1 – Creating a Database from a Template 00:01:00
MS Access 2007 Basic Course 2 Topic A – Demo 2 – Creating a Blank Database 00:01:00
MS Access 2007 Basic Course 2 Topic B Exploring Table 00:01:00
MS Access 2007 Basic Course 2 Topic B – Demo 1 – Navigating in a Table in Datasheet View 00:05:00
MS Access 2007 Basic Course 2 Topic B – Demo 2 – Examining a Table in Design View 00:04:00
MS Access 2007 Basic Course 2 Topic C Creating Tables 00:05:00
MS Access 2007 Basic Course 2 Topic C – Demo 1 – Creating a Table by Using the Table Templates 00:06:00
MS Access 2007 Basic Course 2 Topic C – Demo 2 – Creating a Table in Design View 00:02:00
MS Access 2007 Basic Course 2 Topic C – Demo 3 – Adding Fields and Descriptions to a Table 00:05:00
MS Access 2007 Basic Course 2 Topic C – Demo 4 – Setting the Primary Key 00:01:00
MS Access 2007 Basic Course 2 Topic C – Demo 5 – Saving the Table 00:01:00
MS Access 2007 Basic Course 2 Topic C – Demo 6 – Adding a Record 00:02:00
MS Access 2007 Basic Course 2 Topic C – Demo 7 – Copying, Modifying, and Deleting a Table 00:03:00
MS Access 2007 Basic Course 2 Topic C – Demo 8 – Creating a Composite Key 00:03:00
Fields and Records
MS Access 2007 Basic Course 3 Topic A Changing the Design of a Table 00:05:00
MS Access 2007 Basic Course 3 Topic A – Demo 1 – Modifying Field Names 00:01:00
MS Access 2007 Basic Course 3 Topic A – Demo 2 – Deleting and Inserting Fields 00:02:00
MS Access 2007 Basic Course 3 Topic A – Demo 3 – Moving a Field 00:01:00
MS Access 2007 Basic Course 3 Topic A – Demo 4 – Using the Attachment Data Type 00:04:00
MS Access 2007 Basic Course 3 Topic A – Demo 5 – Adding a Total Row 00:03:00
MS Access 2007 Basic Course 3 Topic B Finding and Editing Records 00:02:00
MS Access 2007 Basic Course 3 Topic B – Demo 1 – Finding and Replacing a Value 00:03:00
MS Access 2007 Basic Course 3 Topic B – Demo 2 – Undoing Changes 00:01:00
MS Access 2007 Basic Course 3 Topic C Organizing Records 00:04:00
MS Access 2007 Basic Course 3 Topic C – Demo 1 – Sorting Records by a Single Field 00:01:00
MS Access 2007 Basic Course 3 Topic C – Demo 2 – Sorting Records by Multiple Fields 00:02:00
MS Access 2007 Basic Course 3 Topic C – Demo 3 – Using Filter by Selection 00:02:00
MS Access 2007 Basic Course 3 Topic C – Demo 5 – Using Filter Excluding Selection 00:01:00
MS Access 2007 Basic Course 3 Topic C – Demo 6 – Using Advanced FilterSort 00:02:00
MS Access 2007 Basic Course 3 Topic C – Demo 7 – Deleting a Record 00:02:00
Data Entry Rules
MS Access 2007 Basic Course 4 Topic A Setting Field Properties 00:04:00
MS Access 2007 Basic Course 4 Topic A – Demo 1 – Setting the Required Property 00:04:00
MS Access 2007 Basic Course 4 Topic A – Demo 2 – Using the Allow Zero Length Property 00:03:00
MS Access 2007 Basic Course 4 Topic A – Demo 3 – Setting the Field Size Property 00:02:00
MS Access 2007 Basic Course 4 Topic A – Demo 4 – Setting the Append Only Property 00:03:00
MS Access 2007 Basic Course 4 Topic B Working with Input Masks 00:02:00
MS Access 2007 Basic Course 4 Topic B – Demo 1 – Creating an Input Mask 00:03:00
MS Access 2007 Basic Course 4 Topic B – Demo 2 – Working with the Input Mask Wizard 00:03:00
MS Access 2007 Basic Course 4 Topic C Setting Validation Rules 00:01:00
MS Access 2007 Basic Course 4 Topic C – Demo 1 – Creating Validation Rules 00:03:00
MS Access 2007 Basic Course 4 Topic C – Demo 2 – Setting Validation Text 00:02:00
Basic Queries
MS Access 2007 Basic Course 5 Topic A Creating and Using Queries 00:05:00
MS Access 2007 Basic Course 5 Topic A – Demo 1 – Using the Query Wizard 00:04:00
MS Access 2007 Basic Course 5 Topic A – Demo 2 – Creating a Query in Design View 00:02:00
MS Access 2007 Basic Course 5 Topic A – Demo 3 – Saving and Running the Query 00:01:00
MS Access 2007 Basic Course 5 Topic A – Demo 4 – Sorting Query Results 00:01:00
MS Access 2007 Basic Course 5 Topic A – Demo 5 – Filtering a Query by Adding Criteria 00:01:00
MS Access 2007 Basic Course 5 Topic A – Demo 6 – Creating a Query from a Filter 00:03:00
MS Access 2007 Basic Course 5 Topic B Modifying Query Results and Queries 00:02:00
MS Access 2007 Basic Course 5 Topic B – Demo 1 – Editing Query Results 00:02:00
MS Access 2007 Basic Course 5 Topic B – Demo 2 – Adding Fields to a Query 00:01:00
MS Access 2007 Basic Course 5 Topic B – Demo 3 – Finding Records with Empty Fields 00:01:00
MS Access 2007 Basic Course 5 Topic C Performing Operations in Queries 00:04:00
MS Access 2007 Basic Course 5 Topic C – Demo 1 – Using Comparison Operators 00:01:00
MS Access 2007 Basic Course 5 Topic C – Demo 2 – Using the OR Condition 00:01:00
MS Access 2007 Basic Course 5 Topic C – Demo 3 – Using the AND Condition 00:01:00
MS Access 2007 Basic Course 5 Topic C – Demo 4 – Using the Wildcard 00:01:00
MS Access 2007 Basic Course 5 Topic C – Demo 5 – Using Calculations in a Query 00:03:00
MS Access 2007 Basic Course 5 Topic C – Demo 6 – Totaling a Group of Records 00:02:00
MS Access 2007 Basic Course 5 Topic C – Demo 7 – Using the Avg and Count Functions 00:01:00
Using Forms
MS Access 2007 Basic Course 6 Topic A Creating Forms 00:05:00
MS Access 2007 Basic Course 6 Topic A – Demo 1 – Examining a Form 00:03:00
MS Access 2007 Basic Course 6 Topic A – Demo 2 – Creating a Basic Form 00:01:00
MS Access 2007 Basic Course 6 Topic A – Demo 3 – Creating a Form Using the Form Wizard 00:02:00
MS Access 2007 Basic Course 6 Topic B Using Design View 00:04:00
MS Access 2007 Basic Course 6 Topic B – Demo 1 – Creating a Form in Design View 00:01:00
MS Access 2007 Basic Course 6 Topic B – Demo 2 – Addings Controls 00:03:00
MS Access 2007 Basic Course 6 Topic B – Demo 3 – Modifying Properties 00:06:00
MS Access 2007 Basic Course 6 Topic B – Demo 4 – Applying Conditional Formatting 00:03:00
MS Access 2007 Basic Course 6 Topic C Sorting and Filtering Records 00:01:00
MS Access 2007 Basic Course 6 Topic C – Demo 1 – Using a Form to Sort Records 00:01:00
MS Access 2007 Basic Course 6 Topic C – Demo 2 – Using a Form to Filter Records 00:01:00
Working with Reports
MS Access 2007 Basic Course 7 Topic A Reports 00:03:00
MS Access 2007 Basic Course 7 Topic A – Demo 1 – Examining a Report 00:01:00
MS Access 2007 Basic Course 7 Topic A – Demo 2 – Creating a Basic Report 00:01:00
MS Access 2007 Basic Course 7 Topic A – Demo 3 – Creating a Report Using the Report Wizard 00:02:00
MS Access 2007 Basic Course 7 Topic A – Demo 4 – Creating a Report Using Design View 00:04:00
MS Access 2007 Basic Course 7 Topic B Modifying and Printing Reports 00:05:00
MS Access 2007 Basic Course 7 Topic B – Demo 1 – Modifying Reports in Design View 00:03:00
MS Access 2007 Basic Course 7 Topic B – Demo 2 – Modifying Reports in Layout View 00:03:00
MS Access 2007 Basic Course 7 Topic B – Demo 3 – Grouping, Sorting, and Filtering a Report 00:02:00
MS Access 2007 Basic Course 7 Topic B – Demo 4 – Adding Summary Fields Using the Report Wizard 00:02:00
MS Access 2007 Basic Course 7 Topic B – Demo 5 – Modifying the Layout and Style of a Report 00:01:00
Mock Exam
Final Exam

Course Reviews

4.9

4.9
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

498 STUDENTS ENROLLED

Our Students Say..

About

We are a company who is best known for offering awarding body accredited courses for anyone who wishes to take their professional life to the next level.

 2nd Floor, 16-18 Whitechapel Rd, London E1 1EW, United Kingdom.
020 3744 3990
info@johnacademy.co.uk

Certificate Code

Coming Soon

   

top

© Adams Academy Inc. Ltd. T/A John Academy.