You are here:
My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past six years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can.
I have a Microsoft Access business where I build database for small businesses. These are usually one off designs, where there is no off the shelf software avaliable to meet the business needs. I also teach Microsft Access to beginners. I am the owner of the www.simply-access.com website.
Self taught in Microsoft Access. Have done some units in normalisation and SQL, but most of what I know I have learnt from books originally and more recently the Internet.
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Yip Benson | 05/15/12 | 10 | 10 | 10 | |
| Ranadeep | 04/09/12 | 10 | 10 | 10 | Thank you for your answer which suits ..... |
| willy canales | 02/17/12 | 10 | 10 | 10 | Thanks a lo Julie. Willy |
| Wendy | 02/14/12 | 10 | 10 | 10 | Once again a straight forward answer delivered ..... |
| Wendy | 02/06/12 | 10 | 10 | 10 | Thank you Julie for your prompt and ..... |
Hi Mackenzie, Many thanks for the question. Normally I would suggest the Distinct statement, but this is the default for the Union Query. Are you able to send me the syntax you are using for the
Hi, Many thanks for the question. My response would be Yes, it does seem like time. A good article to read is: When to Migrate from Microsoft Access to Microsoft SQL Server Just put the above
Hi Jessica, Many thanks for the question. The short answer is Yes, you can do what you ask, but I just need a bit more information, to ensure I am giving you the most relevant answer. Are the rates
Hi James, Many thanks for the question. Can I ask you, why you wish to create a new table for each person, you may have a perfectly good reason to do so, but it is not the usual way to set up an
Hi Ranadeep, Many thanks for your question. Disclaimer: I am in no way an accountant, so please double check my calculations. Try the following: First of all create a form with an unbound
Answers by Expert:

©2012 About.com, a part of The New York Times Company. All rights reserved.