You may have an existing database or wish to create a new one.  Either way, we can help.

maintenance

  • Archive older data and place in "linked" tables to keep the database at an optimal size
  • Identify and clean out "garbage" records (incomplete or inaccurate records)
  • Identify and fix inconsistent entries. For example, if a field was set-up to allow the user to type in a name, you will most likely end up with any of the following for "Dave." -> Dave, Dvae, David, Dave_, _Dave (where _ denotes a space).  None of these are equal and will result in an incomplete dataset when you query for "Dave".  The next step would be to change this field so that the user selected the name from a dropdown list. 

Database Structure

  • Split a database into a front-end and back-end.  This allows for multiple users
  • Add tables, create new relationships
    • Incorporate new data sources
  • Add functionality
  • Add menus to guide the user
  • Maintain historical data, log changes in text files
  • Add security log-ins, passwords

Queries

  • Add or modify existing queries

Reporting

  • Modify existing reports
  • Generate new reports
    • using Access' report generation feature
    • using Word, Excel or PowerPoint

More...

  • Combine and convert Excel spreadsheets that have outgrown their original intent into a database
  • Use the features of Access as a pass through to normalize data and it's format.  Sometimes things are easier to do in Access than Excel.  It's very easy to import/export data to and from Excel.
  • Add VBA code to extend functionality even further.