TAILIEUCHUNG - Microsoft Access Tutorial - Soren Lauesen

Preface This booklet shows how to construct a complex application in Microsoft Access (MS-Access). We assume that the user interface has been designed already as a paper-based mockup (a prototype). How to design a good user interface is a separate story explained in User Interface Design - a Software Engineering Perspective, by Soren Lauesen. | Microsoft-Access Tutorial Soren Lauesen E-mail slauesen@ Version August 2007 Contents 1. The hotel 2. Creating a Create a database in Create more Create Look-up fields enumeration Dealing with trees and 3. Access-based user Forms and simple Text box label and command Adjusting the Cleaning up the Shortcut keys for the Lines checkbox Combo box - enumeration Combo box - table look Control properties - text Subform in Datasheet Adjust the Mockup Subform in Form Summary of Bound unbound and computed Showing subform fields in the main form42 Variable colors - conditional formatting. 42 Tab controls and option Create a new menu Add commands to the menu Attach the toolbar to a Startup settings - hiding developer stuff. 48 Control tips messages mockup 4. Queries - computed Query join two SQL and how it Outer Aggregate query - Group Query a query handling null Query with user Bound main form and Editing a GROUP BY 5. Access through Visual The objects in Event procedures for text box .72 More text box Computed SQL and live Composite search Event sequence for text Visual Basic Command Open close and CRUD control in The OpenForm Multi-purpose forms hotel system .90 Dialog boxes modal .

• Tin học văn phòng
• Microsoft Access Tutorial
• Soren Lauesen
• the hotel system
• creating a database
• access based user interfaces