| If you need a smart, reliable way to manage your | | | | - Suppliers |
| inventory supply without spending loads of cash on | | | | 5. Take a moment to highlight each of the 8 table |
| specialized software, this Quick Microsoft Access | | | | names on the left and browse through the different |
| Course will show you how to accomplish this with the | | | | fields in each category on the right. In this Quick |
| software you already have on your computer. Though | | | | Microsoft Access Course, we will be creating an |
| you may need a more in-depth Microsoft Access | | | | inventory control database that includes all of these |
| Course to really get efficient with your inventory | | | | tables and fields. Click "next" to continue. |
| control databases, this quick course will show you how | | | | 6. Now you will be able to customize the look of your |
| to have a highly functional inventory control database | | | | database interface. Click through the various display |
| up and running in minutes. | | | | options on the left, choose your favourite, and click |
| The foundation of any profitable business is smart, | | | | "next." |
| thorough information management. After taking this | | | | 7. One of the most exciting aspects of Access is the |
| Quick Microsoft Access Course, you'll be able to use | | | | ability to quickly create custom reports from your |
| the Access wizard to create a variety of smart | | | | stored data. In this fourth frame of the wizard, you'll be |
| databases to manage the various aspects of your | | | | able to choose the look of your reports. Click through |
| business. | | | | the options, choose your favourite, and click "finish." |
| Let's get started! | | | | 8. A dialogue box will appear asking you to enter your |
| 1. Open Microsoft Access and click the "new | | | | company's name and contact information. Fill out the |
| document" icon in the upper left hand corner of the | | | | information and click the red "x" in the upper right-hand |
| toolbar. | | | | corner of the dialogue box. |
| 2. On the left toolbar under "templates" click "on my | | | | You've just created a highly functional inventory control |
| computer" and select the "inventory control" template. | | | | database with an 8 step course! If this is your first time |
| 3. After clicking the "contact management" template, a | | | | using Access, you'll be surprised at how easy it is to |
| File New Database dialogue box will appear, allowing | | | | enter information as opposed to programs like Excel. |
| you to name and file your new database. Choose | | | | Many people think Access must be a confusing |
| your folder, name your file, and click "create." | | | | program to use, but it is actually quite simple and |
| 4. Click "next" on the first frame of the wizard that | | | | intuitive with a little training. It's possible to become fluent |
| appears. The second screen shows the eight tables | | | | in this amazing database application after just a few |
| that will be included in your contacts database. | | | | days of Microsoft Access course training sessions. |
| - My company information | | | | Until then, you've learned enough information in this |
| - Product information | | | | quick course to get your inventory control |
| - Information about buying and selling inventory | | | | management system up and running, ready to collect |
| - Purchase order information | | | | information and produce reports with the touch of a |
| - Categories | | | | button - and all without spending a dime on custom |
| - Information about employees | | | | inventory control software. |
| - Shipping methods | | | | |