Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This Microsoft Access 2010 training course offers a ground-up guide to form and database creation and management with this powerful office productivity tool. Narrated by teacher, author and technology trainer Robert Tucker, this beginner friendly course begins with the very basics and gradually builds to a level of professional proficiency every users should know. Starting with the user interface, the hands-on training takes you through the creation of a single table, then moves to field types and properties, creating input forms, generating reports, and all the associated functions you would expect to know in a business environment. As you move through the video tutorial, Robert even begins to cover some advanced features such as Crosstab Queries, importing data from multiple sources, join queries, and more. By the end of the MS Access course, you will be fully versed in the creation and use of Microsoft Access databases, and know how to get quickly get your data in and out.
What You Will Learn
- How to create professional quality user forms, databases and reports with one of the world's leading office productivity tools.
- How to manipulate and implement data and data sources across a wide range of projects.
- How to create secure, compatible databases that can be accessed by users working with Office products and common industry standards.
Who Should Take This Course
- Anyone who has used Microsoft Access in the past but wanted a better understanding of its full range of features.
- Anyone who needs an understanding of Microsoft Access software as it applies to a professional work or academic environment.
- Anyone new to MS Access wanting a user-friendly guide that introduces the program from the ground up.
What People Are Saying
"Probably the one program in the Office suite that was a little intimidating is now in reach. We're integrating our office's appointment system, and with these tutorials it's going great."
- Angela Card
"Beginners should not be afraid...I was nervous that this course might be too technical but the author is very direct and his examples are very easy to follow along with."
- Roy Metzger
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started|
Working Files - Download These FirstPreview
Overview Of Access 2010Preview
The New File Menu In Access 2010
Making The Most Of The Navigation Pane
Customize The Quick Access Toolbar
Enable Content Using A Trusted Location
Choose Between Tabbed Or Overlapping Windows
Using The Files Included With This Course
What Will I Be Able To Do At The End Of This Course
|Section 2: Database Theory And Design|
What Constitutes A Database
The Components That Make Up A Database
Why Do We Need A Relational Database Like Access
Creating A Database Using The Database Wizards
Create A Database WITHOUT The Wizard (Recommended)
|Section 3: Tables|
Designing Then Creating A Single Table Database
Using The Correct Data Types
Managing The Each Fields Properties
Adding Lookup Options To A Field
Adding An Input Mask To Safeguard Data Entry
Adding A Validation Rule To Safeguard Data Entry
The New Calculated Field In Access 2010
The Primary Key
Entering Data Into A Table
Sorting Data In A Table
Deleting Records From A Table
Editing Records In A Table
Finding Records In A Table
Find And Replace Field Values
Filtering Table Data
|Section 4: Queries|
What Is A Query
Creating Saving And Running A New Query
CAREFUL Editing Data In A Query
Changing The Design Of A Query
Add Criteria To A Text Field To Filter Records
Filtering A Query On A Number Field
Using Date Filters In A Query
Boolean Fields In Querying
Adding Wildcards To Query Criteria
Retrieving Empty Values With A Query (NULL)
Selecting Using Different Criteria On The Same Field (OR)
Selecting Using Different Criteria On Different Fields (AND)
Sorting The Results Of A Query
Hiding Filtering Columns From A Query Result
Evaluating Calculations With Queries
Working Out The Current Age Of Contacts
Produce Totals Using An Access Query
Finding Duplicate Records With A Query
|Section 5: Forms|
Creating A Form Using The Wizard
Column Or Tabular Forms - Which To Choose
Viewing And Editing Records Through A Form
Adding Records Through Forms And Associated Problems
Searching For Records In Forms
Deleting A Record In A Form
Applying Filters Within Forms
Modifying The Design Of A Form
Adding Fields Not Currently Displayed
Aligning And Spacing Form Controls
Amending The Tab Order
Add Logos And Images
Adding Todays Date
Calculating Fields In Forms
|Section 6: Reports|
Creating A Basic Report Using The Wizard
Grouped Reports Through The Wizard
Basing A Report On A Query
The Quick Report Tool
Editing The Layout Of A Wizard Generated Report
Creating A PDF From A Report
|Section 7: Multiple Table Databases|
How To Create A Multi Table Database
Creating Links Between Tables
What Is The Foreign Key
Removing Or Editing A Relationship
Viewing And Editing Data In A Sub Datasheet
Creating A Query That Extracts Data From More Than One Table At A Time
Create A Form Based On A Multi Table Query
Generating A Report Based On More Than One Table
|Section 8: Database Normalization|
What Is Normalization
Normalizing The Sample Database
|Section 9: Advanced Tables|
Importing Data Into Access From Excel
Importing Data Into Access From Access
Importing Data Into Access From Text Files
Converting An Access 2010 Database To A Previous Version
Making Use Of Lookups In Tables
Why Do I Need To Index Fields In Tables
Multiple Field Primary Keys
Printing The Relationship Diagram
|Section 10: Advanced Select Queries|
Using More Than One Table To Feed A Query
Changing The Join Type Of Links In Queries
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.