The problem

If you will need a smart, reliable solution to manage your inventory supply with out spending loads of money on specialized software, this Quick Microsoft Access Course will show you how you can accomplish this using the software you already have in your computer. Though you could need to have a far more in-depth Microsoft Access Course to really get efficient together with your inventory control databases, this speedy course will show you tips on how to have a highly functional inventory control database up and running in minutes.

Microsoft Access is an incredible package: effortless to use, flexible and effective (you can do pretty much something for those who know the VBA macro language properly enough). However, it has a single massive shortcoming - databases get corrupt.

If you are totally convinced a thing weird is going on, it is in all probability a sign that your database has got corrupted.

Solutions which Usually don’t Work

Most web pages will tell you to compact and repair your database (in Access 2007 and 2010 this is accomplished through the Database Tools tab of the ribbon).

Another thought is to decompile your database, which entails running a command-line program: again, we’ve located this typically has no effect.

The foundation of any profitable small business is smart, thorough info management. Following taking this Quick Microsoft Access Course, you will be ready to use the Access wizard to develop a number of smart databases to manage the numerous elements of your business.

Let’s get started!

The Catch-All Solution

1. Open Microsoft Access and click the “new document” icon within the upper left hand corner of the toolbar.

  1. Create a new database.
  2. In this new database, go to the External Data tab of the ribbon, and opt for Access.
  3. Import all objects from your old database: tables, queries, forms, reports, macros, modules - the lot.
  4. Try to see if this has solved your problem.

2. On the left toolbar under “templates” click “on my computer” and choose the “inventory control” template.

3. After clicking the “contact management” template, a File New Database dialogue box will appear, permitting 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 within your contacts database.

- Item information

If you think the paper is interesting you might also be interested in studying about Northwind Database and Sample Access Database.

Technorati Tags: , , ,