Join Alicia Katz Pollock for an in-depth discussion in this video Analyzing your table for redundant structure, part of Access 2007: Shortcuts.
If you're new to databases are just beginning to understand how to construct…a relational database, you may have created a table that has what's called redundancy.…In other words, you maybe unnecessarily having to type in the same data…repeatedly instead of creating relationships between separate tables.…Let me show you what I mean.…Open up this Order table, in it I see orders from the same customer over and…over again, and with each order I had to type in the same information, and that…opened me up to some typos.…If I look over on the right-hand side at each of the orders, I see the…OrderDate, the Product's unique identifier, but then I also typed in the…ProductName over and over again as well as the Size.…
If you watch our Access 2007 Essential Training course, we go into detail into…how to properly design your database to prevent this, but at the moment here I…am with redundancy, and I want to fix it.…This process is called Normalization.…To do that, go to the Database tools ribbon and click on the Analyze Table button.…
Author
Alicia Katz Pollock
Released
2/8/2011- Creating new field with field templates
- Understanding errors
- Filtering data
- Aligning and distributing controls
- Customizing the interface
- Navigating quickly between records
- Speeding up data entry
- Analyzing a table for redundant data
- Creating a multi-field primary key
- Moving records with append and delete queries
- Transforming a query into a PivotTable or PivotChart
- Working with images, charts, and Smart Tags in forms
- Hiding duplicates in reports
- Formatting shortcuts
- Using macros
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome43s
-
-
1. Top Tips
-
Using input masks2m 30s
-
Four ways to filter data2m 57s
-
2. File Management
-
Opening recent files1m 49s
-
-
3. Ribbon and Quick Access Toolbar Tips
-
4. Interface Shortcuts
-
Right-clicking2m 32s
-
Using keyboard shortcuts2m 50s
-
5. Navigation Shortcuts
-
Navigating between records1m 54s
-
-
6. Data Entry and Editing Shortcuts
-
Undo and Redo tips2m 26s
-
Inserting today's date1m 14s
-
Using AutoCorrect1m 45s
-
Using concatenated fields8m 56s
-
Linking Outlook contacts2m 38s
-
-
7. Table Techniques
-
Setting data types2m 15s
-
Setting default field types2m 30s
-
Using validation rules2m 1s
-
Using flag fields2m 6s
-
Using an index1m 58s
-
Using a datasheet Totals row1m 47s
-
Filtering by selection1m 22s
-
Resizing columns and rows1m 50s
-
8. Relationship Techniques
-
Using subdatasheets1m 31s
-
Using relationship reports1m 52s
-
9. Query Techniques
-
Using wildcards5m 33s
-
Using IN instead of OR1m 34s
-
Changing captions1m 42s
-
Finding duplicate records2m 17s
-
Using make-table queries2m 23s
-
Creating an update query2m 49s
-
Using SQL statements2m 27s
-
-
10. Form Techniques
-
Creating option groups2m 35s
-
Creating tabbed form layouts4m 41s
-
Inserting charts3m 39s
-
Creating your own smart tags1m 25s
-
Hiding fields in printouts1m 32s
-
Setting tab stops4m 46s
-
11. Report Techniques
-
Creating headers and footers4m 50s
-
12. Formatting Shortcuts
-
Using the Format Painter2m 17s
-
-
13. Macro and Event Techniques
-
Using AutoExec macros1m 46s
-
14. Database Management Techniques
-
Exporting to PDF1m 50s
-
Locking files38s
-
-
Conclusion
-
Goodbye42s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Analyzing your table for redundant structure