Booking options
£22
£22
On-Demand course
4 hours 34 minutes
All levels
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.
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.
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.
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.
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.
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 |