MS Access Basic - Advanced ...tabase Relationships
X Understanding Relationships and Foreign Keys
X Creating relationships
X Setting Referential Integrity
X Cascading Updates and Deletes
X Working with Relationships
X Creating Select Query
X Create a Query with Single Criteria
X Create a query using Wildcards Forms
X Creating a form using Wizard
X Entering and Editing in Forms
X Searching for Records more...
Access 2003 Level II ... 1F: Normalize the Data
Topic 1G: Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
Topic 2A: Create a New Database
Topic 2B: Create a Table Using a Wizard
Topic 2C: Create Tables in Design View
Topic 2D: Create Relationships between Tables
Lesson 3: Controlling Data Entry
Topic 3A: Restrict Data Entry with Field Properties
Topic more...
Introduction to Programming ...ut relational data, entity relationships, and primary and foreign keys. They will also learn how XML can be used to describe and structure data.
Lessons
? Introduction to Managing Data ? Using the Entity Relationship Model ? Sorting Data by Using Keys ? Using XML
After completing this module, students will be able to:
? Describe the methods of storing and managing data. ? more...