Part 2 of 5 in the Access 2007 series. If you are tasked with building a new database, fixing your company's Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you.
Part 2 of 5 in the Access 2007 series. If you are tasked with building a new database, fixing your company's Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you. This course will teach you to track and report data more efficiently by walking you through the database design process, teaching you how to build tables and forms to enter data, and how to design queries and reports to retrieve and view data. No experience with Access or database design is necessary; however, experience with Microsoft Office applications and data entry is helpful.
Heather Ackmann is an accomplished instructor with a decade of teaching experience, helping students at the high school, college, and adult levels in a variety of topics. Specializing in Microsoft Office computer applications, she is a Microsoft Office Certified Master and holds a degree in English and Secondary Education.
Building and Modifying Tables: Extra Practice This next video is designed for anyone who would like a bit more practice with building tables. In other words, I won't be showing you anything that I haven't shown you already in the Building Tables or the Modifying Tables videos. We're just going to practice what we learned by building the rest of our tables for our Picaroon Publishing database. For starters, we're going to build our customer and our orders table, tblCustomers, tblOrders, OrderDetails. We're going to build fields, we're going to set formats, input masks, and other properties. Then we'll move on to build our author and products tables, tblBooks, tblAuthorInfo, and tblTitles. And finally, we'll build our last three tables, kind of the leftover tables, tblGenres, tblTitlesJunction, and tblAuthorBookJunction. Just to give you a little refresher of our structure. We've already built the top five tables in this kind of picture, all of our employees tables, Departments, EmployeeInfo, Employees, HRData, and Benefits. The rest, as you see them below, that's what we'll be building. We won't though be building the relationships just yet, just the tables themselves.