After you write an action plan, you may feel better just knowing it’s there. But a poorly devised plan can actually work against you.
Identify “action triggers.” List the times, situations and people who will trigger specific action, as opposed to listing general themes or vague goals. Example: Replace “Weigh marketing options” with “Use marketing survey results to decide best advertising option.”
Maintain flexibility. A plan that gets too detailed too far in advance can backfire. Specify how you’ll address your immediate to-do items, but don’t overthink your long-range plans. Leave room for unexpected developments.
Many people avoid using Access, Microsoft’s database-management application, in favor of Excel. But even Excel’s advanced features can’t handle all of your large data management tasks. Plus, entering data again and again just so you can use it for multiple purposes slows you down, and invites mistakes. Access 2007 is easier to use than any previous version. Learn Access now!Set a deadline. Allot one hour to draft your action plan. During that time, break your project into stages and create a simple, practical road map to reach your goal. Treat the plan as a means to an end, not an end in itself. Perfectionists beware: Don’t keep tweaking the plan. After an intensive hour of planning, get started! That protects you from getting so bogged down that you never act.
Get input. Show your plan to a trusted colleague and ask for feedback. You may learn that you’re making false assumptions or that the plan has easily correctable defects.
Microsoft® Certified Trainer Melissa Esquibel shows you Microsoft Access’ numerous workflow benefits. Melissa has edited the transcript of her webinar, and added screenshots and Q&A’s to more easily walk you through the steps of database creation and management.
- The Access 2007 Interface. You’ll learn tabs, ribbons, buttons, security, QAT and the navigation pane.
- What a database is. Melissa explains flat vs. relational databases, creating relationships, looking at your data objectively and database objects.
- Getting data into Access. Melissa will review typing data into records; importing vs. linking; importing and linking from Excel, Outlook and other sources; and adding fields and tips for using the table interface.
- Fast reports and forms. You’ll find how to create and modify forms and reports, use forms for more than data entry and add elements like headers, breaks and totals.
- Basic queries and how to use them. This last section answers all your questions about queries.