Microsoft Access Made Easy

Watch Microsoft Access Made Easy

  • 1969
  • 1 Season

Microsoft Access Made Easy is an educational show that stars Tom "The PC Trainer" Fragale. The show aims to teach beginner and intermediate computer users how to use Microsoft Access, a popular relational database management system. Throughout the series, Tom Fragale takes users step-by-step through the process of creating and using databases, tables, queries, forms, and reports within Microsoft Access. He also covers various features of the software, including macros, VBA programming, and data validation.

Tom Fragale is a Microsoft Certified Trainer with over 25 years of experience in computer training. He brings his wealth of knowledge and expertise to the show, making it accessible and easy to understand for users of all levels.

In each episode, Tom Fragale starts by explaining the purpose and requirements of that specific lesson. He then guides users through the process of completing the task, providing clear instructions and demonstrating the process on screen. The episodes are designed to be watched in sequence, with each lesson building on the previous ones.

One of the highlights of the show is Tom Fragale's teaching style. He is engaging and enthusiastic, using real-world examples and scenarios to illustrate the concepts. He also includes helpful tips and tricks that can save time and improve productivity.

The show covers a wide range of topics, including creating and managing databases, designing tables and fields, creating and running queries, building forms and reports, and automating tasks using macros and VBA programming. Users can also learn how to use advanced features like data validation, indexes, relationships, and security settings.

Microsoft Access Made Easy is particularly useful for small business owners, educators, and non-profit organizations who want to manage their data more effectively. It teaches users how to organize and manipulate information to make informed decisions and track performance.

Overall, Microsoft Access Made Easy is a comprehensive and well-structured show that provides a great learning experience for anyone looking to improve their Microsoft Access skills. Tom Fragale's expertise and teaching style make it a must-watch for beginners and intermediate users alike.

Filter by Source
No sources available
Seasons
Access Query SQL
3. Access Query SQL
 
This video will introduce you to the Microsoft Access query language. It's really a version of SQL, or the Structured Query Language. It can be used to write your own queries or to customize queries in Access. This is a great way to start to learn the SQL language, and build more powerful queries in Access. It covers the Select , From, Where, Order By, Inner Join, and Group by SQL statements.
Access Tables Part 2 - Importing Data, Sorting, Filtering, and Table Relationships.
2. Access Tables Part 2 - Importing Data, Sorting, Filtering, and Table Relationships.
 
This video will show you how to create and manage your tables in Microsoft Access. It includes importing and linking to following data sources: Microsoft Excel, text and CSV files, ODBC data sources such as Oracle, Microsoft SQL Server, and SAP, other Access Databases, and Microsoft SharePoint lists. It also shows you how to sort and filter your tables, and it also talks about table relationships.
Access Tables - The Buiding Block of your Access database
1. Access Tables - The Buiding Block of your Access database
 
This video will show how to make a table from scratch using design view in Microsoft Access. It will also cover: Access terms, Access data types, Table field properties, how to create a drop-down, pull-down field in Access using the Lookup Wizard, how to make a custom field using the Input Mask Wizard, changing a table, and adding data to a table. This is the first on many Access videos to come.
Description