• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Office 2007 Access Beginners - Complete Video Course

Microsoft Office 2007 Access Beginners - Complete Video Course

By John Academy

4.3(43)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 4 hours 34 minutes

  • All levels

Description

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.

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

Certificate and Transcript

Order Your Certificates and Transcripts

00:00:00

About The Provider

Tags

Reviews