Pages on This Website

HOME

DATABASES

• Asset Management
• Contact Management
• Customer Complaints Management
• Customer Sales and Orders
• Document Numbering and Tracking
• Enquiry Management
• Estimating
• Financial Market Intelligence
• Human Resources
• Insurance Premiums and Claims
• Marketing Management
• Office Integration
• Product Returns Tracking
• Sales and Product Production Forecasting
• Sales Leads and Tenders
• Supply Chain Management
• Time Logging/Time Sheet Tracking
• Work in Progress

SPREADSHEETS

TEMPLATES

CONSULTANCY

ABOUT DMW

access Q&A

• Coping with null values in query expression fields
• Attaching labels to control objects on a form
• Access 2002 form loses subform
• List all database objects
• Excel-like rounding of numbers
• Compacting database and database speed
• AutoNumber field error
• Form or report control displays #Error

excel Q&A

• Changing a time into a decimal value
• Summing time values
• Suppressing the #DIV/0! error
• Showing a formula result in a chart legend
• The last day of next month
• The totaling percentages problem
• Criteria for DSUM formulae
• Error 1004
• Excel SUMPRODUCT function
• Rounding to the nearest 5
• Change data/time into military date/time
• Macros and VBA Programming in Excel
• Error Trapping and Handling in Excel Macros
• Random Cell Background (Fill) Colours Macro

technical notes

• Rounding numbers
• Floating point numbers and scaling
• Customer Relationship Management (CRM)