When upgrading from Excel to Access, it is imperative to clean the Excel data, Excel allows users to type whatever they like into each cell, if you have a column containing dates, then it should not contain text or numeric data, I have seen date cells where the client has entered things like “Next Tuesday” Access is strongly typed, this means that if there is an area to enter a date, it will only accept dates, this is a great advantage as it promotes clean data and accurate reporting.
Excel cleaning, I can assist in cleaning your Excel data prior to importing into your new Access Database, sometimes I can change may records with a small bit of programing code that may have taken someone some considerable time to do manually.
Stuart Arkell, Dart Systems Ltd said "We had been using manual systems before we found Dennis online and after having had a couple of conversations with him knew that he understood our problems and issues through his previous experience."
See my testimonials
As mentioned above, Access is strongly typed and I program my databases to validate data so you have a nice clean efficient database.
Access is multi-user, so you no longer have to wait for a colleague to stop using an Excel file so you can edit it, multiply users can use the database simultaneously.
Please do not hesitate to contact me
if you need advice on making the move from Excel to a professionally developed Access Database.