Access 2007 Part 2: Tables and Relationships

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.
Course info
Rating
(35)
Level
Beginner
Updated
Jun 3, 2008
Duration
4h 7m
Table of contents
Description
Course info
Rating
(35)
Level
Beginner
Updated
Jun 3, 2008
Duration
4h 7m
Description

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.

About the author
About the author

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.

More from the author
End-user Communications for Better IT
Beginner
2h 37m
May 17, 2017
Word 2016 for Power Users
Beginner
2h 23m
Dec 21, 2016
Microsoft Word (2016): Essentials
Beginner
1h 32m
May 4, 2016
More courses by Heather Ackmann
Section Introduction Transcripts
Section Introduction Transcripts

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.