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.
Learn Microsoft Access 2010 with this comprehensive course from TeachUcomp, Inc. Mastering Access Made Easy features 102 video lessons with over 8 hours 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 three printable classroom instruction manuals (Introductory, Intermediate and Advanced), 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 a video lesson or open one of the manuals and you’re on your way to mastering Access.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Acquainted with Access|
The Access InterfacePreview
Overview of a DatabasePreview
Working with Database ObjectsPreview
Opening and Closing Databases
|Section 2: Creating Relational Database Tables|
Creating New DatabasesPreview
Flow Overview of a DatabasePreview
The "Flat-File" Model of Data Storage
The Relational Model of Data Storage
Tips for Creating a Relational Database
Creating Relational Database Tables
Assigning a Primary Key to a Table
|Section 3: Using Tables|
Using Datasheet ViewPreview
Navigating in Datasheet ViewPreview
Adding Records in Database ViewPreview
Editing and Deleting Records in Datasheet View
Inserting New Fields
|Section 4: Field Properties|
Setting Field PropertiesPreview
The 'Field Size' PropertyPreview
The 'Format' Property for Date/Time Fields
The 'Format' Property for Logical Fields
Setting Default Values for Fields
Setting Input Masks
Setting Up Validation Rules and Responses
Requiring Field Input
Allowing Zero Length Entries
|Section 5: Joining Tables|
The Relationships Window
Enforcing Referential Integrity
Creating Lookup Fields
|Section 6: Indexing Tables|
|Section 7: Queries|
Using the Simple Query Wizard
Joining Tables in a Query
Adding Criteria to the QBE Grid
Running A Query
How is Using the QBE Grid Writing SQL Code?
Sorting Query Results
Hiding Fields in a Query
Using Comparison Operators
Using 'AND' and 'OR' Conditions
|Section 8: Advanced Queries|
Using the 'BETWEEN...AND' Condition
Using Wildcard Characters in Criteria
Creating a Calculated Field
Creating 'Top Value' Queries
|Section 9: Advanced Query Types|
The 'Find Duplicates' Query
The 'Find Unmatched' Query
|Section 10: Creating Forms|
The Form Wizard
Form and Report Layout View
Form and Report Design View
Viewing the Ruler and Grid
The "Snap to Grid" Feature
Creating a Form in Design View
|Section 11: Form and Report Controls|
Moving and Resizing Controls
Sizing Controls 'To Fit'
Aligning, Spacing and Sizing Controls
Viewing Control Properties
|Section 12: Using Controls|
The Controls Group
Adding Label Controls
Adding Logos and Image Controls
Adding Line and Rectangle Controls
Adding Combo Box Controls
Adding List Box Controls
Setting Tab Order
|Section 13: Subforms|
Using the Subform/Subreport Control
|Section 14: Reports|
Using the Report Wizards
Using Basic Reports
Creating a Report in Design View
Founded in 2001, TeachUcomp, Inc. began as a licensed software training center in Holt, Michigan - providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.
At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.
In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 80 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.
Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use.
You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.