Viewers: in countries Watching now:
Discover how to manage data entry and reporting tasks more efficiently using Access 2010. Author Adam Wilbert presents lessons on designing forms, organizing and displaying data with form controls, creating flexible queries, and building a form-based navigation system. The course also shows how to build reports from wizards and queries, highlight important data with conditional formatting, and automate reporting processes with macros.
When starting any new database project it's really important to be familiar with the data tables that we will be working with. Throughout this course we are going to be taking a look at data from the Two Trees Olive Oil Company. Let's take a look at some of the data that we will be working with. On the left-hand side of my Navigation Pane I can see I have a bunch of tables, I have a table called DirectCustomers, Employees, FieldReps, Orders, and Products, I also have a couple of additional tables that are marked as lookup tables here with this tag for GradeID, OilID, Sizes, and States. Let's take a look at the Orders table. I will double-click on it to open it and we will review the data inside.
The Orders table has fields for OrderID, OrderDate, the customer that placed the order and this is their ID number, the product that was ordered, and again, the ID reference, and the ID number for the salesperson that assisted with that order. Now if we go to the Database Tools menu here and take a look at the relationships, by pressing the Relationships button here, we can see how all of the data tables within our database relate to each other. So here is that Orders table, we can see the fields inside of the Orders table and we can see that if we take a look at the CustomerID, the CustomerID is linked to the DirectCustomers table based off of that ID number.
So from the Orders table I can get the ID number, I can follow that to the DirectCustomers table or I can get additional information such as their first and last name, their address, the state that they live in, and their email address. Similarly, I can follow the ProductID to the left to the Products table and I can find out the name of the product, the size of the product, the cost of the product. Once I have that information I can find other information about that product. For instance, I can translate the size in ounces to the text name of its size, for instance small or medium. I can also find what oil it was made of and what the retail grade of that oil is.
Now all of these tables are related to each other in this database which makes it very efficient and I can use the data in multiple ways. So this is the data that we will be working with throughout this course as we create forms and reports to organize it. Let's get started.
There are currently no FAQs about Access 2010: Forms and Reports in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.