Ep 2. Access Tables Part 2 - Importing Data, Sorting, Filtering, and Table Relationships.

In season 1 episode 2 of Microsoft Access Made Easy, the focus is on Access Tables Part 2 which covers the important aspects of importing data, sorting, filtering and creating table relationships. This episode is specifically designed for beginners who want to learn how to use Microsoft Access for database management.

The episode kicks off with a brief recap of the previous episode, Access Tables Part 1, which introduced the viewers to creating a new table, defining fields, and setting up a Primary Key. The viewers are quickly brought up to speed with the essential terminologies and concepts related to databases.

The second episode dives deeper into the functionalities of tables in Access by demonstrating how to import data from different sources, such as Excel sheets, CSV files, and other database management software, into Access tables. The instructor takes the viewers through the action of importing data as well as the process of mapping the columns from the data source to the table fields in Access.

Next, the episode discusses the exciting topic of sorting and filtering data in Access Tables. The instructor teaches the viewers how to sort data in ascending or descending order based on numerical or alphanumerical values. Similarly, the episode delves into how to filter the data in tables by using various filter options like text filters or date filters. The instructor also explains how filtering can be used to extract data that meets a specific criterion.

The episode continues with the crucial concept of establishing relationships between tables in Access. The instructor educates the viewers about Primary Keys and Foreign Keys, explaining how they are used to create relationships between tables. This section demonstrates the action of designing and implementing relationships between tables to provide the viewers with a hands-on experience on how to establish relationships between tables.

Towards the end of the episode, the instructor provides some critical insights on the importance of table relationships in Access and how they can make database management more efficient and accurate. The episode wraps up with an overview of all the concepts covered in Access Tables Part 2 and a sneak peek of what's coming next in season 1.

In conclusion, Microsoft Access Made Easy season 1 episode 2, Access Tables Part 2 - Importing Data, Sorting, Filtering, and Table Relationships, provides viewers with an in-depth understanding of how Access Tables are created and maintained. The episode covers core concepts such as importing data, filtering, sorting and establishing table relationships, making it an essential topic for anyone interested in database management. The explanations and demonstrations are clear-cut, easy to understand, and most importantly, practical, providing learners with the tools to start designing and maintaining their databases.