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

Course Reviews

4.9

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

No Reviews found for this course.

499 STUDENTS ENROLLED

Have you any inquiry?

  • By submitting your information, you agree to the terms and conditions stated in our Privacy Policy

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.

 11 Floor, 15 St Botolph Street, London EC3A 7BB
020 3744 3990
info@johnacademy.co.uk

Certificate Code

Free CV Review

free cv review

 

 

top

© John Academy.