In Access 2010: Queries in Depth, author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw data into usable information. The course covers setting up queries, performing calculations, using the built-in Access functions to further refine query results, and identifying top performers or areas for improvement based on a range of criteria. Exercise files are included with the course.

Up and Running with VBA in Access shows how to enhance productivity by automating routine tasks and providing custom functionality not built into Access. Author Curt Frye introduces object-oriented programming and provides database designers with a foundation in the Access object model and the Visual Basic for Applications (VBA) programming language. The course covers automating tasks with macros, working in the Visual Basic Editor, writing functions, adding logic, reading data, controlling forms, and more. Exercise files are included with the course.

Migrating from Access 2003 to Access 2010, author David Rivers walks through the switch to Access 2010 from Access 2003. The course covers key differences in Access 2010 and shows how to perform common Access 2003 tasks in Access 2010, such as filtering data and designing forms and reports. Exercise files accompany the course.

Web site and database assimilation is a necessity for many of today's businesses, and learning to work with PHP is key to integration success. The objective of PHP with MySQL Essential Training is to teach both new and experienced web developers the comprehensive steps for building dynamic, data-driven, interactive websites. Using PHP 5.2.x and MySQL 5.0.x, instructor Kevin Skoglund demonstrates the entire process of building a content management system. He starts with the basics of the PHP language (variables, arrays, loops, functions, etc.) and works up to building dynamic web pages with a MySQL back end. Kevin also covers blueprinting applications; structuring and interacting with databases; building, validating, and processing forms; and regulating user access with passwords.

Watch expert-taught Photoshop tutorials and learn image editing, retouching, and color correcting for all skill levels. Find out how to use Photoshop shapes and layers, how to retouch photos, and more.

At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server's advanced features, and maintain a link to the data in Access. Watch this course to learn how to leverage what you already know to take that next step. Adam Wilbert reviews the basics of SQL Server Management Studio (SSMS) and introduces two workflows for migrating Access data: one using a simple export/import process and the other using the free SQL Server Migration Assistant (SSMA).

Learn the no-code way to create powerful browser-based SharePoint apps that let users view and enter data from many sources: Access, Excel, and even SharePoint lists! Gini Courter walks through creating a simple Access web app with data imported from Excel, linked via SharePoint lists, or even from tables you create from scratch.