Downloads – Page 6 – iAccessWorld.com

Student Database -MS Access

Download Sample Access File: Student Database This is an example file of Student Database (you can call it Classroom database). This database is created on a single form as a Main form, not using a Navigation Form. The main purpose of this database is keeping record of student attendance for each class he/she is taking. It also keeps a record of test score and final grade of each student for each class taken. It is ready to use or it can be modified as you want. You can also learn…

Create Automatic Email Reminder from Access

Download Sample Access File: Create Automatic Email Reminder from MS Access This is an example file of how to make MS Access to generate the Auto Email to employee to reminder this task will due in 30 days or less. The program also sends auto email to manager when task is overdue for his employee. Highlight functions or features in this sample file include: 1. Navigation Form consists of the list of all tasks, tasks due in 30 days, and task over due. 2. Example of a calculated field on query…

Search Form using Combo Box and Link Two Subforms

Download Sample Access File: Create Search Form Using Combo box and Link Two Subforms This is an example file of how to create a Search or Filter data by using the combo box and how to link two subforms under the same main form. This example shows three different types of data source for combo box. Highlight functions or features in this sample file include: Part 1 1. Create a combo box with data source links the table. 2.Create a combo box with the data source by manually entering the…

Sample Code Collection Database

Download Sample Access File: My Code Collection DB This is an example file of Code Collection database that I created for myself. There are 96 VBA Access code names/functions included in this file. This database can be modified for another similar data collection type such as song collection, video/movie collection, address book etc. Highlight functions or features in this file include: 1. The technique of how to remember the last selected Program Language on the 1st combo box. When program is opened, the Program combo box will display the program type that…

Login Form with Advance Security Level

Download Sample File: Login Form with Advance Security Level This sample Access file is implemented from Login Form and Set Security Level. I have combined these two things together as requested from many of our friends. Highlight functions in this file include: 1. 6 different types of user level/permission on the tblSecurityLevel table as shown below: 2. If user login with temp password with “password”, program will direct a user to a Change Password Form to change password 3. The Admin Page will be enable only for the user logged…

Open Link from MS Access

Download Sample Access File: Open file link or folder or web link from MS Access database You can open the links for any file document or folder on your local computer or network drive. It is also able to open any website link. You can collect all your favorite links into one database and can retrieve them quickly to use. You also can modify the Access file implement it into your database. (See more on How To..) Highlight functions in this file include: 1. Open links from the drop-down list…

Create Access Search Form by Keyword

Download Sample Access File: Search Form by Keyword More details of How To Create Search Form by Keyword at: How to Create Search Form Part 1 How to Create Search Form Part 2 Highlight functions in this file include: 1. Search function by Keyword using SQL statement in VBA for a record source for form 2. Search function by Keyword with options of selecting Customer type for searching 3. Email customer via MS Outlook. 4. Set security level for user type. The Admin tab will be disabled if user logged…