This section demonstrates on how our Excel consultants use MS-Access to develop various kinds of applications such as data entry forms, query and reporting tools. The first example in this section demonstrates data entry form built for a database with many-to-many relationship tables. The second example demonstrates a query and reporting application.
Data Entry Tools, Query Tools, and other Applications
Data Entry Form Example Details
This MS-Access application allows users to input data into multiple database tables that have many-to-many relationship (see Figure 1). By using multiple subforms, users can update data in multiple tables on one master data entry form (see Figure 2).
Figure 1. Screen shot of many-to-many relationship tables in the database
Figure 2. Screen shot of the master data entry form
Query and Reporting Example Details
This Access application allows users to perform keyword(s) search on a book (even book written in foreign language as shown in this example) which stored in a database. The users can choose whether to search the whole book or just a specific chapter within the book (see Figure 1). The search result can be displayed on the screen or/and be availabled in a report format for printout (see Figure 2).
Figure 1. Screen shot of query user interface
Figure 2. Screen shot of the report output
Copyright © Excel Business Solutions. All Rights Reserved.
37 advanced Excel VBA prorgrams in finance & statistics with VBA source codes.
