New Year Resolution #1: Learn Microsoft Access
What is Access?
Access is a database tool for gathering and understanding all your information—your phone numbers, inventory, guest lists, whatever you’re tracking—and providing a convenient way to enter, navigate, and report your data.
When do I need Access?
- When you need to be able to collect information accurately from large groups.
- When you want a database that is easy for coworkers to explore your information using menu items and icons.
- When you need to run the same formatted report daily, weekly, or monthly.
- When you want to know who your most valuable customers are so you can target your marketing.
- When you want to keep track of not only who’s on your guest list, but where they’re staying, and any special needs.
Access Templates for your business
- Out-of-the box templates and reusable components make Access 2010 a fast and simple database solution.
- New built-in templates you can start using without customization, or select templates from Office.com and customize them to meet your needs.
- Build your databases with new modular components using new Application Parts and add prebuilt Access components for common tasks to your database in a few simple clicks.
Below is a list of available templates:
|
Templates |
Best used for: |
| Assets template > | Tracking the condition or status of assets or inventory. |
| Contacts template > | Keeping track of your customers’ key information, buying habits, and more. |
| Issues and tasks template > | Tracking the progress of team activities. |
| Non-profit template > | Managing events, donors, members, and donations. |
| Projects template > | Keeping track of projects, tasks, and people assigned to them. |
| Services template > | Managing quotes, create invoices, and run your business. |
| Goods template > | Tracking inventory, create invoices, and run your business. |
| Price Compare template > | Establishing your price and keeping track of your competition |
Create Access forms and reports with visual impact
Access 2010 brings you the innovative tools to create professional, informative forms and reports. These forms and reports are saved and executed via a menu or icon.
- Conditional formatting now supports data bars and you can now manage your conditional formatting rules from a single intuitive view.
Import existing data from external sources such as Excel
- Import and link data from a broad range of other external sources such as Microsoft Excel, Microsoft SQL Server, Microsoft Outlook, and more.
Whether you’re a large corporation, small-business owner, nonprofit organization, or if you’re just looking for more efficient ways to manage your personal information, Access 2010 makes it easier to get what you need done more quickly, with more flexibility, and with better results.
Computer Learning Institute has been offering software instruction since 1991. During this time we have served a variety of clients in our classroom and at their business location. Courses are instructor led and tailored to an audience of up to 15 participants. These customized workshops enable the instructor to deliver individual attention to each attendee.