Automating Your Database

Saves Time And Money While Improving Performance

Macro Coding . . . Built In Automation

A macro is a group actions that you can create to automate everyday database activities or tasks. Macros can even be grouped so you can perform several activities at one time. A macro is a composed or one, or more, actions. In database terminology, these actions are sometimes referred to as commands. The macro is nothing more than a single unit of instructions to the database. A single macro can automate a particular action, like printing your report or the opening of a specific form. Macros are often the "code" that executes when you click a button on a form. For example, when you click a button (aka command button), that says "Print", the program will then print your report.

When To Use MS Access Automation?

Here's a list of just some of the database tasks that you can automate:

• Repetitive actions, like keyboard typing
• Data manipulations; adding, editing, merging, or deleting records
• Importing and exporting data from other databases or spreadsheets
• Data analysis via extraction and comparison procedures
• Document editing and formatting procedures
• Printing reports, letters, and graphing
• Advanced data calculations
• Data tracking for individuals, projects, sales orders, product inventory, work in progress

Improving Accuracy And Saving Time Also Saves You Money

The most tedious tasks of database work are frequently the cause of the most mistakes. Excessive button clicks, searching for the right form, repetitive printing; all these eventually lead to costly expense in time and and money. Your administrative personnel could be wasting a great deal of their time performing actions, like repeating typing activities, that could be automated. Using automation within your program will complete even the most complex work in a few seconds. The benefits of automation will result in significant time saving, fewer errors, lower personnel costs, and higher quality work.

Microsoft Access and the complete Microsoft Office suite, including Excel and Word, come with automation capabilities. Call us at 503-309-6691 so we can get started helping you automate your database project.