Download Access File: Report Generator to Excel with Formatting (for Access 2010 and Up) This is a MS Access application that is used to generate a report and export to MS Excel. It is ready to use. You can export data from table to MS Excel with your own format. You can modify the format of report on Access form before exporting to Excel. After you update all formatting, you can click There are two version of this Access application. Use Only version ($14.99). This version is for use only.…
Read MoreArchives: Downloads
Create Photo Album
Download Example Access File: Create Photo Album (for Version 2010 and up) Many photos can be displayed in one form of MS Access. The form with many photos will be linked to one item (product in this example). We can call it as an album of that item. The form will display those photos as a thumbnail. There is a view button for each photo to view a large photo. In this example file, I will create a photo album of 8 photos for each product as shown in the…
Read MoreSearch Up to 3 Keywords
Download Sample Access File (Version 2010 and up): Search any field up to 3 Keywords This is a simple search form that can search up to three (3) keywords at once. The search form is created under a Split Form format which has the detail section displayed similarly to the datasheet subform. You can use the function on subform as well by changing the record source of subform to the SQL of search function. The search function will search all fields on the current form. The use can enter keywords…
Read MoreMS Access: Car Rental Database
Download Sample Access File: Car Rental Database (for Access 2010 and up) This is an example file of Car Rental Database. It is the basic of rental database, but you can add as many more fields or tables as you want. The Admin User can add new vehicles, new users, new customers, and other information. The regular user can reserve a vehicle, customer, and rental. The rental process will start with finding the available vehicle then select the vehicle to reserve or rent. Highlight functions or features in this sample…
Read MoreStaff Training Database
Download Sample Access File: Staff Training Database (for Access 2010 and up) This is an example file of Employee/Staff Training Database. The main purpose of this database is to keep a training record for employees. This database will provide a report of training catalog, mandatory training for staff, available training for staff, completed training, and not completed training etc. The user also can search data for completed training and not completed training by department, training class, manager and staff. Highlight functions or features in this sample file include: #1 Login…
Read MoreSend a Message to User and Close Program
Download Sample Access File (Access 2010 and Up): How to Send Message to Users This sample file demonstrates how to send a message to the logged in users and notify them to close database. The program also will automatically close program if the users fail to close program timely. This tool will help the admin to force database to close for maintenance. How it Works: Users logon database via a Login Form A Detecting Message Form is monitoring if a notification is created by the Admin Admin sends a message…
Read MoreCustomer Order and Payment
Download Sample Access File (Access 2010 and Up): Customer Order and Payment This sample file includes a search form, customer navigation form, order form, payment form, receipt report, and invoice report. Both VBA and Macro are used in this sample file. The navigation form also displays a credit or owed amount for each customer. Highlight functions are included in this download file: Search Form: This form is first loaded when program is opened. This form can search on one field or multiple fields from Customer name field thru Email field.…
Read More