access tutorial
Microsoft-Access Tutorial
Soren Lauesen
E-mail: slauesen@itu.dk
Version 2.4b: July 2011
Contents
1. The hotel system................................................... 4
2. Creating a database ............................................. 6
2.1 Create a database in Access ............................. 6
2.2 Create more tables ......................................... 10
2.3 Create relationships ....................................... 12
2.4 Look-up fields, enumeration type .................. 14
2.5 Dealing with trees and networks.................... 16
3. Access-based user interfaces ............................. 18
3.1 Forms and simple controls............................. 18
3.1.1 Text box, label and command button...... 18
3.1.2 Adjusting the controls............................. 20
3.1.3 Cleaning up the form .............................. 20
3.1.4 Shortcut keys for the user ....................... 22
3.1.5 Lines, checkbox, calendar....................... 22
3.1.6 Combo box - enumeration type .............. 24
3.1.7 Combo box - table look up ..................... 26
3.1.8 Control properties - text box................... 28
3.2 Subforms........................................................ 30
3.2.1 Subform in Datasheet view..................... 31
3.2.2 Adjust the subform ................................. 34
3.2.3 Mockup subform..................................... 36
3.2.4 Subform in Form view............................ 36
3.2.5 Summary of subforms............................. 38
3.2.6 Prefixes ................................................... 38
3.3 Bound, unbound and computed controls........ 40
3.3.1 Showing subform fields in the main form42
3.3.2 Variable colors - conditional formatting. 42
3.4 Tab controls and option groups...................... 44
3.5 Menus ............................................................ 46
3.5.1 Create a new menu bar............................ 46
3.5.2 Add commands to the menu list
Soren Lauesen
E-mail: slauesen@itu.dk
Version 2.4b: July 2011
Contents
1. The hotel system................................................... 4
2. Creating a database ............................................. 6
2.1 Create a database in Access ............................. 6
2.2 Create more tables ......................................... 10
2.3 Create relationships ....................................... 12
2.4 Look-up fields, enumeration type .................. 14
2.5 Dealing with trees and networks.................... 16
3. Access-based user interfaces ............................. 18
3.1 Forms and simple controls............................. 18
3.1.1 Text box, label and command button...... 18
3.1.2 Adjusting the controls............................. 20
3.1.3 Cleaning up the form .............................. 20
3.1.4 Shortcut keys for the user ....................... 22
3.1.5 Lines, checkbox, calendar....................... 22
3.1.6 Combo box - enumeration type .............. 24
3.1.7 Combo box - table look up ..................... 26
3.1.8 Control properties - text box................... 28
3.2 Subforms........................................................ 30
3.2.1 Subform in Datasheet view..................... 31
3.2.2 Adjust the subform ................................. 34
3.2.3 Mockup subform..................................... 36
3.2.4 Subform in Form view............................ 36
3.2.5 Summary of subforms............................. 38
3.2.6 Prefixes ................................................... 38
3.3 Bound, unbound and computed controls........ 40
3.3.1 Showing subform fields in the main form42
3.3.2 Variable colors - conditional formatting. 42
3.4 Tab controls and option groups...................... 44
3.5 Menus ............................................................ 46
3.5.1 Create a new menu bar............................ 46
3.5.2 Add commands to the menu list