- Intoduction hotel system.
- Creating a database. Construct a database that cor-responds to the data model behind the design. The user will only see the database indirectly - through the screens we construct.
- Access-based user interfaces. Construct the screens and menus that the user will see. We follow the pa-per-based mockup designed in User Interface De-sign. You can use the result as a tool-based mockup.
- Queries - computed tables. Connect the screens to the database, usually by means of queries - com-puted data tables. The result will be a partially functional prototype.
- Access through Visual Basic. Program what the buttons and menus will do when the user activates them. The result will be a fully functional prototype and later the final system to be delivered to the customer. The first part of the chapter is tutorial - mandatory reading if you want to work with Visual Basic and Access. The rest of the chapter is for looking up various subjects. We assume you know a bit of programming already.
- Visual Basic reference. A reference guide to the Visual Basic language for Applications (VBA).
- Access and SQL. An overview of the remaining parts of SQL, for instance how to update the database through SQL. We also explain how to generate matrices of data with dynamically chan-ging headings.
Step 1 Intoduction hotel system.
In this section we illustrate MS-Access by means of asystem for supporting a hotel reception. The system is used as the main example in User Interface Design - a Software Engineering Perspective, by SorenLauesen.