Once you have worked through the stages of Planning a Microsoft Access Application, you will then move onto creating the application in Microsoft Access. If you have correctly structured the database design, the application design will be much easier to implement. Having spoke to your database user's, they will have given you ideas for what is required in the database application and you can begin work on the interface that will be used.
The following checklist details the application needs and data sources:
- Talk to the users who will be working with the database application to find out their data input needs, reporting needs, querying and other data needs and application security needs.
- Create a rough prototype by using the Database Wizard and other wizards and templates.
Planning the Database Tables
- Account for all of the data.
- Normalise the data tables.
- Set up the database relationships and referential integrity.
- Create tables, write in field descriptions in design view and add sample data to test the design.
Planning the Queries
- Create queries for forms and reports.
- Create queries for selecting and modifying data.
Create the required Forms
- Start with the forms needed for data entry.
- Test the forms.
- Test the working prototype by using macros to automate tasks.
Creating the necessary Reports
- Start with the reports needed to display entered information.
- Test the reports.
Create other Forms or Reports
- Create forms or reports for other user designated uses.
- Test the forms and reports.
Connecting and automating the Tables, Forms and Reports
- Create buttons, menus and toolbars needed for navigation purposes.
- Test the buttons, menus and toolbars
Verifying Application Design with the client
- Verify that forms, reports and queries perform as desired.
- Verify that all data is accounted for.
- Discuss any additional features that may be required.
Adding the final Application Design touches
- Create a splash screen for the Microsoft Access application.
- Create a start-up form for the application.
- Add captions.
- Refine the design of the forms.
- Convert macros to Access VBA (Visual Basic for Applications)
- Set startup properties
- Create user and group security dependant upon who can access what in the database application.
- Assign permissions to the security groups.
- Make Backups of the application.
Testing, Rollout and Training Users of the Microsoft Access Application
- Test the application to verify that everything works as required.
- Roll out the application to the end users.
- Plan a training program to train the users of the application. Consider the depth of documentation appropriate to distribute to the trainers and the users.
Create database applications using Microsoft Access.
This electronic book introduces the reader to databases with an emphasis on how to create database applications using Microsoft Access. The lessons are presented in detailed step-by-step instructions that assume no prior knowledge of databases from the reader. This is a technique that was experimented and proven on its original web site (http://www.functionx.com/access). Anybody who reads this ebook and follows its instructions will surely get a hands-on experience about the capabilities of Microsoft Access.
Download the ebook now and begin creating database applications using Microsoft Access - Microsoft Access Fundamentals