Author Michael Mumford, Quan Dang
Institution London Metropolitan University
Module Title Rapid Application Development
Module Homepage N/A
Original Resource N/A
Programme of study BSc Computer Science
Academic Level NQF level 5 or FHEQ Intermediate (for BSc year 2)
Credit Value 20
Rationale The module introduces students to developing applications in high productivity development environments and exemplifies the feature set and support tools of such environments by exposing the student to one exemplar in depth and then requiring them to develop a software artefact using this toolset and to reflect on the process.
Aims This module aims to teach Rapid Application Development through the study of Access 2007 and Visual Basic for Applications with a particular emphasis on the data input, validation, processing, reporting and summarization features which typify many commercial applications. It also addresses wider issues about
  • what 4GLs are
  • what characterizes Visual programming languages
  • how visual programming languages and rapid application development environments affect the development process
  • how the implementation of Visual programming languages relates to object oriented language ideas
  • how object oriented ideas can be extended to deal with complex 'Business Objects'
  • how systems can be scaled through single machine through client server to three layer models
Benefits The material was designed for use in a teaching semester with 11 teaching weeks. There is a weekly lecture and a practical session in a PC-based lab with Access 2007 on the lab PCs. The material includes aims and objectives for the semester weeks, PowerPoint slides for the lectures and notes and instructions for the practical sessions. The instructor can use the provided lecture slides as such, or customise it to their own requirements/preference. The material for the practical sessions provides reading guidance and a wealth of practical exercises with detailed instructions for students to follow to achieve the weekly learning objectives. This helps to engage students in the practical sessions, which results in improved student achievement. Sample solutions are provided for the majority of the exercises
Date of use 2001-2009
Download module The module can be downloaded as a zip file at the following URL: http://open.jorum.ac.uk/xmlui/handle/123456789/1990
Accessibility If you wish to view the material in alternative formats, then you may wish to access the software tools collated by TechDis and available at http://www.techdis.ac.uk/getaccessapps (as found on 2/2/10)
Module Level Elements
Reading Material: Module Summary
Reading Material: Scheme of Work
Reading Material: General Introduction
Reading Material: Assessment
Assignment: Coursework & Marking scheme
Reading Material: Learning Resources
Reading Material: Web Resources
Topic

Elements
Introduction to 4GLs and Access 2007 development

Lecture: Introduction to Rapid Application Development
Task Guide: Week 1 - Introduction to 4GLs and Access 2007 with Visual Basic for Applications
Task Guide: Week 1 Reading and Practical Tasks
Practical: A Simple Access 2007 Database
Topic

Elements
Review of Forms

Lecture: Review of MS Access forms
Task Guide: Review of Forms
Task Guide: Week 2 Reading and Practical Tasks
Practical: Understanding the form and its uses
Practical:: Creating Forms from a Single Table
Practical: Creating Forms using Queries
Practical: Adding Calculated Fields
Practical: Adding Navigation Buttons with the Button Wizard
Topic

Elements
Introduction to Visual Basic for Applications and relationship to VB 6

Lecture: Visual Basic for Applications in Access
Task Guide: Introduction to Visual Basic for Applications and relationship to VB 6
Task Guide: Week 3 Reading and practical tasks
Reading Material: Introduction to VBA and comparison with VB6
Practical: Modules and the VBA IDE
Practical: Adding code in a class module and in a code module and using controls which are not databound
Practical: Using Combo boxes, List Boxes, Check Boxes and Option Groups to validate input and display data
Practical: Objects in Access
Topic

Elements
Manipulating Form Data using VBA - introduction

Lecture: Manipulating Form Data using methods of Recordset and RecordsetClone in VBA
Task Guide: Manipulating Form Data using VBA - introduction
Task Guide: Week 4 Reading and Practical Tasks
Practical: Introduction to the RecordsetClone object
Practical: Examples of manipulating the RecordsetClone from Wizard generated forms and controls
Practical: Methods of the RecordsetClone
Practical: Queries for Forms and SQL, Using the RecordSource and Filters
Topic

Elements
Characteristics of VBA, Debugging and Validation

Lecture: Characteristics of VBA and Debugging and Data Validation
Task Guide: Characteristics of VBA, Debugging and Validation
Task Guide: Week 5 Reading and Practical Tasks
Practical: Tools for the prevention and detection of error
Practical: Rules of Scope and Persistence in Access 2007 and VBA
Practical: Validation in Access 2007 and VBA
Topic

Elements
Reports, VBA in Reports and Coursework

Lecture: SQL
Task Guide: Reports, VBA in Reports and Coursework
Task Guide: Week 6 Reading and Practical Tasks
Practical: Reports review and revision
Practical: Using VBA in reports
Practical: Some Examples which may help with the Coursework
Topic

Elements
Menus and Toolbars, passing parameters to Reports

Lecture: Reports, VBA in Reports
Task Guide: Menus and Toolbars, passing parameters to Reports
Task Guide: Week 7 Reading and Practical Tasks
Practical: Designing Menu Structures for Windows Applications
Practical: Specifying the Starting Form
Practical: Using the Switchboard Manager
Practical: Constructing menus and Showing and Hiding Toolbars
Practical: Controlling report data
Topic

Elements
Action queries, Using other RecordSets

Lecture: Menus and Toolbars- Passing parameters to Reports
Task Guide: Action queries & unbound recordsets
Task Guide: Week 8 Reading and Practical Tasks
Practical: Action Queries
Practical: Unbound recordsets
Practical: Using an unbound recordset for a simple application login
Topic

Elements
Object concepts revisited, Classes and User Controls, RAD methodologies and Development

Lecture: Queries
Task Guide: Object Concepts revisited, Classes and User Controls, RAD methodologies and Development
Task Guide: Week 9 Reading and Practical Tasks
Practical: Help in Access Databases
Reading Material: Creating Class modules
Reading Material: Classes, Components and Active-X objects reviewed
Reading material: RAD methodologies
Topic

Elements
Client Server and Multitier architectures

Lecture: Object-based and Component-based programming in MS Access - Client Server and Multitier architecture
Task Guide: Client Server and Multitier architectures
Task Guide: Week 10 Reading and Practical Tasks
Reading Material: Multitier Architectures
Reading Material: Linking Mutitier Applications
Reading Material: Introduction to .NET
Reading Material: Some sample projects using Visual Studio.NET
Topic

Elements
Web delivery and ASP.net

Lecture: Sharing Access data with others - Deploying Access Data over the Web
Task Guide: Web Delivery and ASP.NET
Task Guide: Week 11 Reading and Practical Tasks
Reading Material: Sharing Access data with others
Practical: Deploying Access 2003 data over the web
Practical: Data Access Pages