Download Example Access File: Project Maintenance with Photo album This download file is an example of the project maintenance database with an ability to save photos up to 12 photos on each maintenance. One project can have many maintenances. For instance, a new road project started last year and may need maintenance in next 3 years. We can save all photos of the maintenance in this database. This database will save only the file name and file description of each photo. The actual file will be saved in the specified…
Read MoreArchives: Downloads
Store and Search Document Database
Download Sample Access File: Store and Search documents (Version 2010 +) MS Access has a built-in function to attach an external file or image to database; however, it will increase a file size quickly when more files are attached. It might be okay to use this function for a small database. Those attached files also cannot be searched by user. The efficient way is to store only the file name, file description, and file location in database. Then we can use a function to search for those files/documents and…
Read MoreHotel/Room Rental Database
Download Sample Access File: Hotel/Room Rental Database This is an example file of Hotel Rental Database. It is the basic of rental database, but you can add more fields or tables as you want. The Admin can add new rooms, new employees, new customers, and other information. The regular user can book a room, add customer, and search for booking. Highlight functions or features in this sample file include: #1 Login Form This form is first loaded when the program is opened. It asks user to enter a UserName and…
Read MoreSearch Multiple Items Using Combo boxes and List boxes
Download Sample Access File: Search Multiple Items Using Combo boxes and List boxes (Version 2010 +) This is an example of using the Combo box and List box in combination to search in the formation in two different fields. The data in the 2nd Combo box or the 2nd List box is depending on the selection from the 1st Combo box or the 1st List box. In this sample file, I used the Customer table to search for the customers by the State and City. There are two different type…
Read MoreSale and Inventory Transaction Using a Scanner
Download Sample Access File: Sale and Inventory Transaction Using a Scanner (Version 2010 +) This is an example of Sale and Inventory Access database file. This database file can be implemented to use for the small sale venders, food trucks, grocery stores, small shops, etc. The key feature for this database is using the scanner to add the inventory and to scan item or product to sale. There are many other features that include in this sample file below. Video: How it works: Scanner is Needed (Not included in this…
Read MoreMembership Check in Using a Scanner
Download Sample Access File: Membership Check in Using a Scanner (Version 2010 +) This is a simple membership time tracking Access database file. This membership database can be implemented to use for the church service, fitness center, sport club, internet café, etc. It can track the members who come to use the services. The key feature for this database is using the scanner to check in and check out members. The staffs or members are also able to check in quickly by using the scanner to scan the barcode on…
Read MoreCreate Electronic Signature in Word and Excel
Download Sample File: Create Electronic Signature in Word and Excel Most of the time, you will sign a letter with your signature. However, you can sign a soft copy of your letter with the electronic signature. It does not have to be your actual signature like you sign on the paper. It can be something that represents your identity. The most popular method is to use your computer login username. The computer login username is the unique name that is assigned to you from your company. In this download file,…
Read More