Use this handy database to help manage your job search effort. It contains 3 main databases, 2 log (tracking) databases, and 1 lookup database.
MAIN DATABASES: The first main database (Job Company/Agency) is used to help you manage your list of companies and agencies involved in your job search. The second main database (Job Contacts) is used to manage specific contacts who are involved in your job search. This database can include contact information for recruiters, account managers, or other people involved in your job search. This database contains a child database (Job Contact Log) for managing communications with the individuals listed in the main database. It also provides a link to the third main database (Job Leads). The third main database (Job Leads) is used to help you manage specific opportunities resulting from your contacts. This database helps you keep track of what the opportunity is, where it is located, the agency/recruiter involved, the source of the lead, the start/end dates (project-based work), rate information, and other data. In addition to these main databases, there is also a lookup database that is used for state information in various popups used throughout. This is a useful database which is based off another database that I downloaded from DDH.
Has Data:
No
Has Forms:
No
Comments:
I will be posting a revision with more descriptions and explanations in the near future. Feel free to drop me a line and let me know how this database helped you in your job search. Good luck!
Order entry applet using multiple groups of DB popups.
Has Data:
Yes
Has Forms:
No
Filters:
Set a filter to show only a particular customer's orders, or a particular date range of orders.
Sorting:
Sort by date.
Reports:
Run a report for a particular customer, etc.
Comments:
There are three files in this archive: orders.pdb, accounts.pdb, and products.pdb. All three are used for this applet. Here's how it works:
Accounts.PDB - has accounts info- ie, your customers, their account number, their price rate, which is a discount rate that you could set for each customer. For example, a company might receive a 20% discount off the price, so this value would be 0.80.
Products.pdb - information about each product you are selling, including product numbers, prices, description, etc.
Orders.PDB - the main entry point once everything is set up. Open orders.PDB and add a record. You can choose the customer making the purchase by either writing in the value or, better yet, selecting the customer popup, where you will be taken to the Accounts database and you will be able to select one from the existing accounts. This will also bring over the account # of this customer. You can now fill out the quantities for up to 3 items (which was all I could fit in the 30 fields with all of the other stuff), and select the product by pressing the Item x Desc field and selecting the product from the Products database. The price will come over and be factored in along with the quantity, and the 'discount rate' or 'price rate' as it is in the accounts database is factored as well.
At the bottom the tax is calculated, which I put in at 6%, which is Florida's rate, but you can easily modify this by adjusting the Tax field property, and a total is given.
I hope this is a useful starting point for you. If you need more products to be purchased, you can either take away some of the other extraneous fields and try to squeeze one or two more in, or redesign the database as follows:
Make each record be part of an order. You can use the new 'prev record' calculated fields to keep a running sum. Then you can use the Filters to limit the view to the current customer's current order only, and have a good subtotal!
Price:
FREE
Version:
HanDBase v.3.0x or greater
File:
orders.zipDownloads: This Month 510 / Total* 21151
Note:
MAC Users will need to enter the filename orders.zip when saving this file.
I work as a massage therapist, and created the Pay Period database to keep track of commissions earned when working for other establishments where they are the ones responsible for collecting money from clients. It has proved invaluable in making sure I'm getting paid correctly. There are two variations. One is based strictly on time, where the commission is based strictly on the length of time worked. The other is for multiple services that have their own rate of pay. The second variation can also be used to keep track of commissioned sales for a few regular items. The first variation can be easily modified to keep track of commissioned sales of regularly varying amounts.
The database actually consists of multiple linked databases. The Time based variation links two databases, while the Service based variation links three. The Pay Period database keeps track of the pay periods as a whole, with each record an individual pay period. The Commissions database, accessed through the link field in Pay Period, keeps track of the actual sessions performed. Since it is a linked database, it will bring up only the sessions associated with the source link, i.e., they get grouped by pay period. This makes determining your pay check a matter of running a report at the end of the pay period. Within the records in the Service variation, service information is selected from entries in the DBPopup database, Services. Includes sample data and a ReadMe.
Has Data:
No
Has Forms:
No
Filters:
Filter out pay periods you've received full payments for via checkboxes.
Reports:
Report in commissions database, when accessed via link, tells you how much your paycheck should be.
DO NOT DOWN LOAD THIS. FOR SOME REASON THE FORMS ARE NOT UPLOADING AND IT ISN'T WORTH IT WITHOUT THE FORMS. I HAVE EMAILED SUPPORT FOR ASSISTANCE. A simple message pad for taking phone messages or voice mail messages down. Pop-up fields and one tab for additional information. Designed to look like a common office message pad.
Has Data:
Yes
Has Forms:
Yes
Sorting:
Sort by returned or not, date, person, etc.
Comments:
Fields such as caller and company can be changed to drop down as well. If you can print from your palm using one of the palm applications you might print them out in "traditional" pink.
Sales Monitoring And Risk Tracking system : database to collect and manage information on prospect, project environment, competition, strategy and actions for the sales of IT projest or Management software. A MS-Access companion is also provided for convenience, additional processing of data's and example of the flexibility of the handbase system.
Has Data:
Yes
Has Forms:
No
Filters:
See doc (Word 2000 format)
Sorting:
See doc (Word 200 format)
Reports:
Desktop companion provided as example of futher processing of HandBase data's
Thanks for taking a look at the SmartAssets Sales Application. This is an application that I built after looking at a ton of Contact Managers. As a Sales Guy I have learned to use technology to help me in being as successful as possible.
My idea of a good Contact Manager is one that will do what you need it to, with lot's of flexibility but most importantly is quick and intuitive. I think that the HandBase application is a fantastic way to build and customize business applications very inexpensively and quickly. While the interface may not be the most stunning (sorry DDH) it is certainly quick and straight forward.
With the SmartAssets Sales App you will be able to track contacts, record history, track opportunitues, and input completed orders. You will be able to see what opportunities you have for the month and/or for any particular company. You will be able to input info quickly and work the way that suits you best.
Hope you find this application useful.
Has Data:
Yes
Has Forms:
No
Filters:
You can use the filter in the activities for items that are past due or for today and can filter by priority. Use filter to look up only prospects, clients, etc.
Full details are in the included doc.
Sorting:
Use to your hearts desire. ;)
Reports:
I have left this wide open as each person will have their preferences.
This database includes tables to track Accounts, Activities, Inventory, Samples, Orders, Notes, and Catalogue.
Route sales requirements vary greatly from organization to organization and I have tried to make this application as comprehensive as possible. Obviously you will want to customize to fit your requirements but this should give you a decent launching point.
Accounts
This is the main table you will work with. From here you will be able to access all relevant account info such as Contacts, Orders, Samples, On-Hand Inventory, Activities, and Notes.
I have included a field called Route ID# which you can use to group accounts to create your route. Once you have inputted these you can filter on this field to see only the accounts you are visiting today.
Orders
This table is used for creating new orders for your client. You tap on this field (from the Account table) to create/edit a record. Fill in the order#, PO#, ship date, etc. Tap on details to add/review items. You will be seeing the linked table �saRte_OrdDetails�. From here you can add items by tapping the item field, which will open the Catalogue table. Select the item you want and the item, price, product#, SCU, and description fields will automatically be populated with the correct information. You can then add the quantity and discounts applicable and the calculations will be done automatically.
Has Data:
Yes
Has Forms:
No
Filters:
Filter by RouteID, Sales for the month, activities for the day, catalogue category, etc, etc.
Sorting:
Tons of options...
Reports:
You can create your own reports to orders, activities, accounts visited, etc.
Comments:
I hope this application is useful to you. I am always please to get feedback, so let me know if I should change anything.