Oit_content_126684_2 - Access 2007 2010 Basic Database Development OIT TECHNOLOGY TRAINING SERVICES Access 2007 2010 Basic Database Development The

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

View Full Document Right Arrow Icon
Basic Database Development
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
1 0 . 0 5 . 2 0 1 1 O I T T E C H N O L O G Y T R A I N I N G S E R V I C E S Access 2007 & 2010: Basic Database Development The University of Minnesota is an equal opportunity educator and employer. This publication/material is available in alternative formats upon request. Direct requests to oca@umn.edu . Printed on recycled and recyclable paper with at least 10 percent postconsumer material. ©2011 Regents of the University of Minnesota. All rights reserved.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
UNIVERSITY TECHNOLOGY TRAINING CENTER i Table of Contents LESSON 1 1 INTRODUCTION TO DATABASES 1 Database Design Vocabulary 1 Relationships 2 Design Process 3 LESSON 2 7 BUILDING A DATABASE IN ACCESS 7 Create an Access Database 7 Set Access Options 8 Creating Tables 10 Exercise 1: Creating Tables 17 Creating a Join Table 18 LESSON 3 19 SETTING FIELD PROPERTIES 19 Resizing text fields 20 Input Masks 21 Default values 24 Format number fields 26 Exercise 2: Setting field properties 28 LESSON 4 31 CREATING RELATIONSHIPS 31 Print the design 35 Removing Tables from the Diagram 36 Deleting or Editing Relationships 36 LESSON 5 37 MODIFYING TABLES AND RELATIONSHIPS 37 Adding the New Foreign Key Field 38 LESSON 6 41 CREATING INTERFACES TO INTERACT WITH DATA 41 Using Forms vs. Tables for data entry 41 Creating the Member Status type Entry Form 42 Exercise 3: Creating Entry Forms Using Multiple Items Form Option 49 Handling One-to-Many Relationships with Subforms 55 Exercise 5: Creating a Subform using Autoform 64 Linking the Main form and Sub Form 71 Navigating Records and Entering Test Data 73
Background image of page 5

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

View Full DocumentRight Arrow Icon
UNIVERSITY TECHNOLOGY TRAINING CENTER ii Creating Forms using the wizard 74 Exercise 6: Creating the CD entry form using the Wizard 79 LESSON 6 CONTINUED Adding to combo box lists “on the fly” 84 Finding a Record on a Form 86 Using a Combo Box to Find Records on the Form 89 Creating the Member CD Form and Subform in Design View 93 Date picker 101 LESSON 7 103 EDITING A FORM 103 Modifying a Form 103 LESSON 8 107 QUERIES 107 Creating a Query using the Query Wizard 107 Exercise 7: Creating a Query Using the Wizard 114 Adding Criteria to a Query 116 Creating a Query in Design View 118 Exercise 8: Creating a Query in Design View 121 End of Exercise 122 LESSON 9 123 REPORTS 123 Creating a Report Using the Auto Report option 123 Exercise 9: Creating a Report Using Auto Report 127 Creating a Report Using the Wizard 128 Exercise 10: Creating a Report Using the Wizard 133 LESSON 10 139 FINAL TOUCHES 139 Menu 139 Database Maintenance and Backups 145
Background image of page 6
LESSON 1: INTRODUCTION TO DATABASES UNIVERSITY TECHNOLOGY TRAINING CENTER iii APPENDIX A 149 USING THE LABEL REPORT WIZARD 149 APPENDIX B 153 CREATING A QUERY USING AGGREGATE FUNCTIONS 153 APPENDIX C 157 EXPORTING QUERY RESULTS157 APPENDIX D 161 CREATING A MEMBER ADDRESS REPORT USING THE WIZARD 161 APPENDIX E 165 EXPORTING A REPORT 165
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
UNIVERSITY TECHNOLOGY TRAINING CENTER 1 Introduction to Databases Database Design Vocabulary
Background image of page 9

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

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

This note was uploaded on 02/04/2012 for the course INFORMATIO Download C taught by Professor Office during the Spring '11 term at Minnesota.

Page1 / 174

Oit_content_126684_2 - Access 2007 2010 Basic Database Development OIT TECHNOLOGY TRAINING SERVICES Access 2007 2010 Basic Database Development The

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

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