Access 2007 Part 2: Tables and Relationships
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Building Tables- 1h 2m
—Overview of Methods for Building Tables 5m 20s
—Building Picaroon's Main Employee Table (tblEmployees) 16m 14s
—Introduction to Table Naming Conventions 3m 27s
—Overview of Different Data Types 3m 10s
—Adding Records 10m 15s
—Navigating in Datasheet View 3m 5s
—Building tblHRData in Design View 8m 11s
—Keyboard Shortcuts for Design View 5m 3s
—Looking at Table Templates 5m 35s
—What We Covered 2m 13sModifying Tables- 1h 20m
—Controlling Data Entry 3m 34s
—Using Formats 14m 15s
—Using Input Masks 12m 39s
—Using Data Validation 5m 3s
—Using Look-Up Fields 20m 42s
—Indexing 5m 20s
—Unicode Compression, IME Mode/IME Sentence Mode 1m 24s
—Smart Tags 2m 52s
—Functioning Inside Tables 8m 25s
—Customizing Tables 4m 21s
—What We Covered 1m 40sBuilding and Modifying Tables: Extra Practice- 23m 3sCreating Relationships- 49m 35sAdvanced Relationships- 31m 42s