Quality Training Since 2001

Microsoft Access Tutorial Course

  buy-now-button syllabus-button

microsoft-access-training-tutorial

Course Title: Mastering Access Made Easy
Versions Covered: 2019 through 2007 & Microsoft 365
Hours: 5
Video Lessons: 108
Manual: 189 Pages
This Course: $50 $15 Sale! | SHOP
All Courses: Every course. One price. | 
Multi-User: Group discounts | 

Course Description

Learn Microsoft Access with this comprehensive course from TeachUcomp, Inc. Mastering Access Made Easy features 108 video lessons of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our printable classroom instruction manual (189 pages), additional images and practice exercises.  You will learn all about relational databases, advanced queries, creating forms, reporting, macros and much more.

Whether you are completely new to Access or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs.  Simply launch the easy-to-use interface, click to start a video lesson or open the manual and you’re on your way to mastering Access.

Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window. 

To view a sample of the instruction manual in PDF, click here:  Sample Access Manual

     
CHAPTER 1- Getting Acquainted with Access  
Lesson 1.1- Creating a New Database free
Lesson 1.2- Overview of a Database  
Lesson 1.3- The Access Interface  
Lesson 1.4- Touch Mode free
Lesson 1.5- Viewing Database Objects in the Navigation Bar  
Lesson 1.6- Opening and Closing Databases  
CHAPTER 2- Creating Relational Database Tables  
Lesson 2.1- The “Flat File” Method of Data Storage  
Lesson 2.2- The Relational Model of Data Storage  
Lesson 2.3- Tips for Creating a Relational Database  
Lesson 2.4- Creating Relational Database Tables free
Lesson 2.5- Assigning a Primary Key to a Table free
CHAPTER 3- Using Tables  
Lesson 3.1- Using Datasheet View  
Lesson 3.2- Navigating in Datasheet View  
Lesson 3.3- Adding Records in Datasheet View  
Lesson 3.4- Editing and Deleting Records in Datasheet View  
Lesson 3.5- Inserting New Fields free
Lesson 3.6- Renaming Fields free
Lesson 3.7- Deleting Fields  
CHAPTER 4- Field Properties  
Lesson 4.1- Setting Field Properties  
Lesson 4.2- The ‘Field Size’ Property  
Lesson 4.3- The ‘Format’ Property for Date/Time Fields  
Lesson 4.4- The ‘Format’ Property for Logical Fields  
Lesson 4.5- Setting Default Values for Fields  
Lesson 4.6- Setting Input Masks  
Lesson 4.7- Setting Up Validation Rules and Responses  
Lesson 4.8- Requiring Field Input  
Lesson 4.9- Allowing Zero Length Entries  
CHAPTER 5- Joining Tables in a Database  
Lesson 5.1- The Relationships Window  
Lesson 5.2- Enforcing Referential Integrity  
Lesson 5.3- Creating Lookup Fields  
CHAPTER 6- Indexing Tables  
Lesson 6.1- Indexes  
Lesson 6.2- Creating Indexes  
Lesson 6.3- Deleting Indexes  
CHAPTER 7- Queries  
Lesson 7.1- Using the Simple Query Wizard  
Lesson 7.2- Designing Queries  
Lesson 7.3- Joining Tables in a Query  
Lesson 7.4- Adding Criteria to the QBE Grid  
Lesson 7.5- Running A Query  
Lesson 7.6- SQL View  
Lesson 7.7- Sorting Query Results  
Lesson 7.8- Hiding Fields in a Query  
Lesson 7.9- Using Comparison Operators  
Lesson 7.10- Using ‘AND’ and ‘OR’ Conditions  
CHAPTER 8- Advanced Queries  
Lesson 8.1- Using the ‘BETWEEN…AND’ Condition  
Lesson 8.2- Using Wildcard Characters in Criteria  
Lesson 8.3- Creating a Calculated Field  
Lesson 8.4- Creating ‘Top Value’ Queries  
Lesson 8.5- Function Queries  
Lesson 8.6- Parameter Queries  
CHAPTER 9- Advanced Query Types  
Lesson 9.1- Make-Table Queries  
Lesson 9.2- Update Queries  
Lesson 9.3- Append Queries  
Lesson 9.4- Delete Queries  
Lesson 9.5- Crosstab Queries  
Lesson 9.6- The ‘Find Duplicates’ Query  
Lesson 9.7- Removing Duplicate Records from a Table  
Lesson 9.8- The ‘Find Unmatched’ Query  
CHAPTER 10- Creating Forms  
Lesson 10.1- Forms Overview  
Lesson 10.2- The Form Wizard  
Lesson 10.3- Creating Forms  
Lesson 10.4- Using Forms  
Lesson 10.5- Form and Report Layout View  
Lesson 10.6- Form and Report Design View  
Lesson 10.7- Viewing the Ruler and Grid  
Lesson 10.8- The ‘Snap to Grid’ Feature  
Lesson 10.9- Creating a Form in Design View  
Lesson 10.10- Modifying Form Sections in Design View  
CHAPTER 11- Form & Report Controls  
Lesson 11.1- Selecting Controls  
Lesson 11.2- Deleting Controls  
Lesson 11.3- Moving and Resizing Controls  
Lesson 11.4- Sizing Controls ‘To Fit’  
Lesson 11.5- ‘Nudging’ Controls  
Lesson 11.6- Aligning, Spacing and Sizing Controls  
Lesson 11.7- Formatting Controls  
Lesson 11.8- Viewing Control Properties  
CHAPTER 12- Using Controls  
Lesson 12.1- The Controls Group  
Lesson 12.2- Adding Label Controls  
Lesson 12.3- Adding Logos and Image Controls  
Lesson 12.4- Adding Line and Rectangle Controls  
Lesson 12.5- Adding Combo Box Controls  
Lesson 12.6- Adding List Box Controls  
Lesson 12.7- Setting Tab Order  
CHAPTER 13- Subforms  
Lesson 13.1- Creating Subforms  
Lesson 13.2- Using the Subform or Subreport Control  
CHAPTER 14- Reports  
Lesson 14.1- Using the Report Wizard  
Lesson 14.2- Using Basic Reports  
Lesson 14.3- Creating a Report in Design View  
Lesson 14.4- Sorting and Grouping Data in Reports  
Lesson 14.5- Creating Calculated Fields  
CHAPTER 15- Subreports  
Lesson 15.1- Creating Subreports  
CHAPTER 16- Charting Data  
Lesson 16.1- Using Charts  
Lesson 16.2- Insert a Modern Chart  
CHAPTER 17- Macros  
Lesson 17.1- Creating a Standalone Macro  
Lesson 17.2- Assigning Macros to a Command Button  
Lesson 17.3- Assigning Macros to Events  
Lesson 17.4- Using Program Flow with Macros  
Lesson 17.5- Creating Autoexec Macros  
Lesson 17.6- Creating Data Macros  
Lesson 17.7- Editing Named Data Macros  
Lesson 17.8- Renaming and Deleting Named Data Macros  
CHAPTER 18- Switchboard and Navigation Forms  
Lesson 18.1- Creating a Switchboard Form  
Lesson 18.2- Creating a Navigation Form  
Lesson 18.3- Controlling Startup Behavior  
CHAPTER 19- Advanced Features  
Lesson 19.1- Getting External Data  
Lesson 19.2- Exporting Data  
Lesson 19.3- Setting a Database Password  
CHAPTER 20- Advanced Features  
Lesson 20.1- Using Access Help  
Lesson 20.2- The Tell Me Bar  


Microsoft Access Training Course Overview

Microsoft Access is the most popular commercial relational database program on the market today. During this Access video training course, our expert instructor will show you all about relational databases, forms, reporting, macros and much more. This Access tutorial covers the same material as our three-day classroom training and was designed to provide a solid foundation in Access.

Course includes video lessons, printable instruction manuals, a practice exam with evaluative feedback (find out why your answers are right or wrong), your final exam submission, and a course certificate of completion.

At TeachUcomp, Inc., you choose how you want your Access training delivered.

Online subscriptions offer the most flexibility and value. With online training, you can access your courses anytime and anywhere you have an internet connection (including all new releases and updates). Your subscription grants you instant access to ALL of our courses for one low price. There are no contracts and you can cancel at any time. You may choose between a monthly or annual plan.

Courses are also available individually via digital download and online for a one-time charge.

TOP
SALE! $29 All-Access 1 Days 15 Hours 56 Minutes 41 Seconds      $199 $29 Entire Library!
See Deal