Learn how to create relationships between tables in a database. Author Jen McBee explores the different types of relationships that can be created, and enforcing referential integrity, focusing on the specific types that may be covered on the Access 2010
- [Instructor] Good database design relies completely…on being able to remove redundant and duplicate data.…To accomplish this, we create smaller tables…that are subject based so the data only needs…to be entered one time in one table.…Then we can create relationships between those tables…and pull information from fields in both of the tables…without having redundant data.…During the Access 2010 MOS exam,…you may be asked to create relationships…between one or more tables.…
You may also be asked to enforce referential integrity.…And that means that if we have a relationship…between a customers table and an orders table…and we have a customer in our orders table…because they have placed orders with us,…we won't be able to remove that customer information…from the Customers table.…We'll get an error message if we try and do that…because that would denigrate the referential integrity…between the two tables.…So, it doesn't allow you to delete information…from one table if another table is relying on…that information to maintain the integrity of that record.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.