Using MS Access/Expert Profile

Mark Kaphle

On Vacation
returns 12/31/2016

I can answer most questions on database design using Access. I can help with VBA too. I can integrate engineering and business needs in the database design.

Experience in the area

I have more than 15 years of MS Access database design experience.


College degree in engineering. Graduate degrees in engineering and management. Current PHD student - concentration Industrial Engineering.

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
Stuart07/21/14101010Thank you for your expedient and concise .....
Charles07/06/13101010Very prompt in answer to a simple .....
Thiruthuva Rajan02/23/13101010Thanks alot mark. Though you do not .....
Thiruthuva Rajan02/15/13101010Thanks alot mark

Recent Answers from Mark Kaphle

2016-01-11 Access Reports:

Hi,  The best practice is to create a form with dropdown boxes where you can select the report and click a button to print the selected report.    You can create a table with the names of the reports,

2014-07-16 Reorder points and email notifications:

Hi Stuart,    Sorry for getting back late. Well, it can be done and this is how usually it is done:    1. Create a table (tblMinInvLvl) with minimum inventory levels for the items. Fields: Item, MinInvLvl

2014-07-15 microsoft access hyperlink:

Open the table in Datasheet view.  You will see the new field for the hyperlink. They should have been blank initially.   If you have anything, you will need to delete them. I guess you have the same website

2014-07-14 microsoft access hyperlink:

Hi Megan,    Open the table in design view.  Add a field.  Select "Hyperlink" for Data Type.  Save the table.  Close the table in Datasheet view.   Enter website addresses in the new hyperlink field.

2013-07-05 Access VBA:

Hi Charles,    You can create a query to do get the earliest date first. Save this query as "qryEarliestDate"  and use it as the RecordSource for the form. On the form use design view and VBA icon to get


Ask A Question

Using MS Access

All Answers

Answers by Expert:

Ask Experts


©2016 All rights reserved.