universityofstandrews.docVIP

University of St AndrewsLibrary and Information Services  Getting started withMicrosoft Access An introduction to Relational Database Management Systems Index Section 1: Introduction to Relational Database Design 5 1.1 What is a database? 5 1.2 The relational model 5 1.3 Designing the database 6 1.4 Data Normalisation 6 1.5 The Student/Module database 7 1.6 The Student/Module database Logical Design 8 Section 2: Introduction to Microsoft Access 9 2.1 What is Microsoft Access? 9 2.2 A note on versions 9 2.3 Using Microsoft Access at the University of St Andrews. 9 2.4 Starting up and creating a blank database 10 Section 3: Table Creation 11 3.1 tblStudent Table in Design View 11 3.2 tblStudent Table Design Details 12 3.3 tblModule Table in Design View 13 3.4 tblModule Table Design Details 14 3.5 tblStudMod and tblSchoolDept Tables 15 Section 4: Form Creation 16 4.1 Designing the Student Form 16 4.2 Designing the Module Form 19 4.3 frmModule Form Design View Properties 19 4.3 frmModule Form Design View Properties 20 4.4 The Dropdown Combo Box 21 Section 5: Entering and Deleting Data 25 5.1 Adding and Editing Records 25 5.2 Deleting records 25 5.3 tblStudent Table Data 26 5.4 tblModule Table Data 27 Section 6: Report Creation 28 6.1 rptStudent Report in Design View 29 6.2 rptStudent Report Design View Properties 30 6.3 rptModule Report in Design View 31 6.4 rptModule Report Design View Properties 32 Section 7: Querying the Database 33 7.1 Opening the database 33 7.2 Querying the database 33 7.2.1 Querying the tblModule table 33 7.2.2 Saving your query 35 7.3 More Criteria 35 7.4 Comparison operators 36 7.5 More on the Modules report 37 Section 8: Linking Tables and Setting Relationships 38 8.1 Relating Tables 38 8.2 Referential Integrity 39 Section 9: Manipulating Data Using Linked Tables 41 9.1 The Finished Students Modules Form 41 9.2 The Main Student/Module Form 42 9.3 Properties for frmStudMod 43 9.4 The Modules Subform 44 9.5 fr