oit_content_123128 - University Technology Training Center...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: University Technology Training Center Access 2007: Advanced Database Development 4.30.09 U N I V E R S I T Y T E C H NO L O G Y T RA I N I N G C E N T E R Access 2007: Advanced Database Development © 2009 Regents of the University of Minnesota University Technology Training Center All Rights Reserved uttc.umn.edu The University of Minnesota is committed to the policy that all persons shall have equal access to its programs, facilities, and employment without regard to race, color, creed, religion, national origin, sex, age, marital status, disability, public assistance status, veteran status, or sexual orientation. This publication/material can be made available in alternative formats for people with disabilities. Direct requests to: University Technology Training Center 190 Shepherd Labs 100 Union Street Southeast Minneapolis, MN 55455 612.625.1300 [email protected] UNIVERSITY TECHNOLOGY TRAINING CENTER I Table of Contents LESSON 1 1 INTRODUCTION 1 Database Design Vocabulary Review 1 Relationships as of the Access 2007 Basics Class 3 Security Options 3 Design Mode vs. View Mode Refresher 4 LESSON 2 5 IMPROVING THE EXISTING DATABASE 5 Improvements and Additions 5 Creating a New Table and Setting Properties 6 Appending Data from tblMemberCD to tblCDLoan 8 LESSON 3 13 UPDATING RELATIONSHIPS 13 Updating Relationships 13 LESSON 4 17 DATA INTEGRITY 17 Additional Data Integrity Checks at the Table Level 17 Creating Validation Rules 17 Exercise 1: Creating Field Level Validation Rules 21 Using Indexes to Prevent Duplicates 23 Exercise 2: Creating No Duplicates Indexes 25 LESSON 5 27 EDITING FORMS AND COMBO BOXES 27 Combo Boxes 27 Exercise 3: Editing Combo Boxes 32 LESSON 6 35 ADVANCED FORM CREATION 35 Handling of CD Loans 35 Create Query that the Main Form Will Be Based Upon 36 Create the Main Form Showing All CDs and Their Owners 37 Exercise 4: Creating a Subform 39 Adding a Search Combo Box to the Main Form 43 LESSON 7 47 IMPORTING DATA INTO AN ACCESS DATABASE 47 Adding a New Member to the Club 47 Exercise 5: Adding New Genres to the Genre Table 55 Adding new CDs to the Database 57 I I U N I V E R S I T Y T E C H N O L O G Y T R A I N I N G C E N T E R Exercise 6: Assigning CDs to the New Member 59 Reusing Action Queries 61 Exercise 7: Importing Excel Data Using an Existing Set of Append Queries 61 LESSON 8 67 QUERY/REPORT OPTIONS FORM 67 Creating the Query/Report Options Form 67 Exercise 8: Set up the Performer Search for the Query/Report Options Form 74 LESSON 9 79 CREATING REPORTS BASED ON DYNAMIC QUERIES 79 Informing Members of Newly Added CDs 79 LESSON 10 83 CREATE A NEW DATABASE BASED ON AN EXCEL SPREADSHEET 83 Exercise 8: SNORCA Database 83 APPENDIX A 99 USING THE OBJECT DEPENDENCIES FEATURE 99 Example: tblMember 100 Example: frmMemberCD 101 APPENDIX B 103 CREATING THE CD CONDITION LOOKUP TABLE 103 APPENDIX C 107 ACCESS CROSSTAB QUERY WIZARDS 107 APPENDIX D 111 ADVANCED REPORT CREATION 111 Creating an Overdue CD letter 111 APPENDIX E 119 ADDING A PRIMARY...
View Full Document

Page1 / 135

oit_content_123128 - University Technology Training Center...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online