PALSSON

Customized Database Applications

 

Custom database applications developed to help improve your business flow through repetitive task automation. As a member of the Microsoft Office Professional suite of applications, Microsoft Access takes advantage of the integration capabiliies between Access and the other Microsoft Office applications.

 

Here is a partial list of capabilities that your customized Access application could include:

• Import Outlook Contacts into your Access application, or Export from your application into Microsoft Outlook

• Add appointments to the Outlook Calendar with reminders

• Set reminders in your Outlook Calendar to follow-up on a sales call or business task

• Remind you at the time due or at a specific time ahead of schedule

• Includes notes from the application to refresh your mind about what you need to do

• Add Tasks to the Outlook Task list with reminders

• Send automated emails from Outlook

• Designate which email account (if you have multiple) you have set up in Microsoft Outlook to send emails from your application

• Disignate a default printer for printing from within the application that is different than the default printer you have configured for your other Windows applications.

  • It would also be possible to select a different printer for one-time output to or as a default printer for a specific report.

• Automatically search your Outlook Inbox for specific emails

  • Read and import data from the body of the email to update data in the database

  •  

    Automated response to data found in emails requesting specific information

  • Generate and email reports back to the requestor through automation

    • Output in:

      • PDF Format

      • Word Document Format

      • A standard Word document, or

      • A Word document template with Bookmarks for Mail Merge

  • Save an attached file into a specific location and associate it with a particular client/customer record

• Copy the text from a Word document

  • Save the text in the database application

  • Search the text for specific keywords which would trigger some other task within the application

• Outlook reminder to perform some task or to follow-up

• Automatically Save images to an Images folder and associate them to a particular client/customer record

• Perform mail merge with Word documents containing bookmarks, save the newly merged Word document as a Word Document and/or a PDF document.

• Open and retrieve data from Excel worksheets

  • Search for information in the worksheet that could trigger an automated response

• Update information in the worksheet, save it, and send it back or forward it on to someone else

• Automate opening Excel worksheets and updating or adding new data

• Data Entry for fixed length record output