Request a callback

We'll call during UK business hours

0207 987 3777

previousPrevious article   Next articlenext back to categoryAccess articles

article Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps

If you need a smart, reliable way to manage your inventory supply without spending loads of cash on specialized software, this Quick Microsoft Access Course will show you how to accomplish this with the software you already have on your computer. Though you may need a more in-depth Microsoft Access Course to really get efficient with your inventory control databases, this quick course will show you how to have a highly functional inventory control database up and running in minutes.

The foundation of any profitable business is smart, thorough information management. After taking this Quick Microsoft Access Course, you'll be able to use the Access wizard to create a variety of smart databases to manage the various aspects of your business.

Let's get started!

1. Open Microsoft Access and click the "new document" icon in the upper left hand corner of the toolbar.

2. On the left toolbar under "templates" click "on my computer" and select the "inventory control" template.

3. After clicking the "contact management" template, a File New Database dialogue box will appear, allowing you to name and file your new database. Choose your folder, name your file, and click "create."

4. Click "next" on the first frame of the wizard that appears. The second screen shows the eight tables that will be included in your contacts database.
- My company information
- Product information
- Information about buying and selling inventory
- Purchase order information
- Categories
- Information about employees
- Shipping methods
- Suppliers

5. Take a moment to highlight each of the 8 table names on the left and browse through the different fields in each category on the right. In this Quick Microsoft Access Course, we will be creating an inventory control database that includes all of these tables and fields. Click "next" to continue.

6. Now you will be able to customize the look of your database interface. Click through the various display options on the left, choose your favourite, and click "next."

7. One of the most exciting aspects of Access is the ability to quickly create custom reports from your stored data. In this fourth frame of the wizard, you'll be able to choose the look of your reports. Click through the options, choose your favourite, and click "finish."

8. A dialogue box will appear asking you to enter your company's name and contact information. Fill out the information and click the red "x" in the upper right-hand corner of the dialogue box.

You've just created a highly functional inventory control database with an 8 step Microsoft Access course! If this is your first time using Access, you'll be surprised at how easy it is to enter information as opposed to programs like Excel. Many people think Access must be a confusing program to use, but it is actually quite simple and intuitive with a little training. It's possible to become fluent in this amazing database application after just a few days of Microsoft Access course training sessions.

Until then, you've learned enough information in this quick course to get your inventory control management system up and running, ready to collect information and produce reports with the touch of a button - and all without spending a dime on custom inventory control software.

Author is a freelance copywriter. For more information on a Microsoft Access course, please visit

Original article appears here:

Back to article list

Distribution notes


  • You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
  • Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
  • Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
  • If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
  • Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
  • If you do not agree to these terms, please do not use this article.

Microsoft Office courses London
Course rating
4.6 stars - based on 1111 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom