Download Sample Access File: Search Multiple Fields Create Search Form for multiple items in multiple fields using different search methods. There are five forms in this sample file. Each form shows different type of search function or filtering multiple data items by using text box, combo box and/or list box. This sample file also shows how the text boxes, combo boxes and list box works together. Highlight functions or features in this sample file include: Form 1 – Search Multiple Fields It is considered a complete search form since it…
Read MoreArchives: Downloads
Business Account Ledger
Download Sample Access File: Business Account Ledger This is a simple Business Account Ledger Access Database file. It will be used to record the expenses and revenues of business transaction. This sample file provides the input form for both transaction types of Expense and Income. It also provides the reports and charts of each transaction type for certain period of time. Highlight functions in this file include: 1. Expense Form: All transaction of expenses will be recorded on this form. 2. Revenue form: All transaction of revenue will be recorded…
Read MoreMS Access Vs MS Word
Download Sample Access File: MS Access Vs MS Word MS Access is a database based program, but MS Word is a graphical word processing program that users can type with. The purpose of the MS Word is to allow the users to type and save documents. MS Access can be programmed to work with MS Word by sending data from Access to Word documents instead of typing and also to save to word or PDF then send to another user via email. The communication between these two programs can be…
Read MoreAdvance Search by Keyword for MS Access
This sample Search Form contains 4 different types of searching with different ways of coding in VBA, from the simple way to the difficult way.
Read MoreMS Access Vs MS Outlook
Download Sample Access File: MS Access Vs MS Outlook MS Access is a database based program, but MS Outlook is communication program of sending and receiving mail. MS Access can be programmed to work with MS Outlook by sending data in Access to another user via email. It can also set task due to another from data in the Access tables. There are two MS Access Files in this download zip file: Access Vs Outlook Format HTML Body Email File 1 -Access Vs Outlook Highlight functions or features in this…
Read MoreSample Tracking User Login
Download Sample Access File: Sample Tracking User Login The sample file demonstrates how to track user who logged into the database. The Login Form is integrated into this sample tracking file. That means you get the example file how to create Login Form and Tracking User file. If you don’t use the Login Form then you can track user login by using the computer login with assigning User = Environ(“UserName”). Highlight functions in this file include: Login Form – require user to login with user name and password when Access…
Read MoreSample Assign Jobs to Employees Evenly
Download Sample Access File: Assign Jobs to Employees evenly This sample file is for assigning jobs or tasks to many employees evenly in rotation. It can be skipped for non-active employee or employee who is not working on that day. The Assign Job function is using the multiple Recordsets, do while loop, and updating data in Recordset. Highlight functions in this sample file include: 1. Navigation form for Assign Job tab, # of Job Assigned tab, Employee List tab and Exit program tab. The navigation form also displays a current…
Read More