Download Sample Access File: Customer Phone Book (For Version 2010 and up) This Access database is a collection of customer information. We can store the customer’s name, address, and phone number in this database. I will call this sample file “Customer Phone Book.” The main purpose of this sample file is to save customer information and search for the customer’s address and phone number. There are three examples of the search function included in this download file: Search Customer Name Search Phone number Search the Initial name 1. Search Customer…
Read MoreArchives: Downloads
Search Multiple Keywords
Download Sample Access File: Search by Multiple Keywords (For Version 2010 and up) This search form is able to search for multiple keywords from one input textbox. 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 Recordsource of subform to the SQL of search function. The user can enter multiple keywords in the provided text box to search for those keywords. All search forms come with…
Read MoreAuto Close Program when No Activity
Download Sample Access File: Auto Close Program when No Activity This sample download file is a small file that will automatically close your Access program when there is no activity. The program will close in certain minutes when no activity. I have created a table IdleTime to enter a minute of non-activity. In this sample file, I set the idle time to 2 minutes. However, you can change to the minutes you want. How It Works: Open MS Access file The Detect Idle Form will open as hidden form The…
Read MoreJob Assignment Sample Database
Download Sample Access File: Job Assignment Database (for MS Access 2010 and Up) This is an example Access file for assigning a job to employees. Also this sample file provides two security levels; Admin and Regular User. The user with Admin type only will be able to use the Admin Page tab to assign a job to employee. The admin user will select the employee, enter a number of jobs to assign, and select a number of days before job due. Job can be assigned to one employee or many…
Read MoreUnlock or Reset Password with Security Code
Download Sample Access File: Unlock or Reset Password with Verification Code by Email or SMS (For Access 2010 or Up) This sample file provides an extra function to the Login Form. It provides a Forgot Password button for the users who forget their password. The users have ability to reset password or to unlock the login form and pass through to the main form. How Does It Work? Before reading the description below, please take a look on the structure of how this download file works. When the Forgot Password…
Read MoreSend SMS/MMS without Service Provider
Download Sample Access File: Send SMS/MMS without Service Provider (For MS Access 2010 and up) Usually, there are two ways to use text messaging with Outlook 2010; Use an Exchange Server 2010 account to connect to a Windows Mobile device running Windows Mobile 6.5 Subscribe to a third-party Short Message Service (SMS) provider using OMS. For this sample download file, it will send SMS or MMS via MS Outlook without subscribing to a third party Service. Many cellular carriers assign email addresses to cellular phone numbers and support SMS or…
Read MoreBanking Transactions
Download Sample Access File: Banking Transactions (for MS Access 2010 and up) This is an example Access file for banking transactions. The basic transaction of banking consists of a date of transaction, transaction description, debit amount, credit amount. The balance of each transaction will change when the debit or credit is entered. The transaction can be entered via a New Transaction form. A Search Transactions form will be used to search for description and for the range of transaction date. This sample file also provides four different types of report.…
Read More