New features of MS Access


© Bert Markgraf
Articles in this Topic    Discussions in this Topic

I have to get MS Office, as well as Corel Office, because I do training and technical support on these programs. Most of my customers don't need MS Office except that most of their contacts use it so they get it for easy compatibility. All others save hundreds of dollars and get the same functionality with Corel Office.

I try to use these programs in my own business so that I have a better idea of what my customers are experiencing. As a result, when my contact database needed up-grading, I decided to try MS Access from MS Office Professional 2000. I was surprised and impressed.

My beef with Microsoft products generally has always been that they're over-programmed and lacking in flexibility. There's always too much stuff and you can't scale down. The new Access has some database structures set-up and they're actually useable. There's asset tracking, contact management, event management, expenses, inventory control, order entry, resource scheduling, service call management and others. I'm using the contact management and haven't had to make too many changes. In addition, the pre-configured structures use standard features that even a non-expert like myself can understand and modify. For example, I had no trouble getting rid of a few fields and adding others. Compare this with trying to change the MS Word templates where any change seems to completely screw up the whole template.

Look for more information on MS Access and how to use it on this part of the MS site. The only thing that is still annoying about this program is that you need a pretty powerful computer to run it well - I find it is slow at under 400 MHz processor speed and 128 MB memory although it will still run.

I still like my old database, which was the real thing - Dbase for Windows - but the new Access will let me deal more efficiently with many groups in one big database and still work with the different groups, such as my Suite101 editors, differently according to their characteristics. All my e-mail addresses will be in one place for example but the same database will still keep track of passwords for my Internet service customers, warranty information for my computer customers and delivery details for my suppliers. And I didn't have to come up with the structure myself.

Go To Page: 1


Post this Article to facebook Add this Article to del.icio.us! Digg this Article furl this Article Add this Article to Reddit Add this Article to Technorati Add this Article to Newsvine Add this Article to Windows Live Add this Article to Yahoo Add this Article to StumbleUpon Add this Article to BlinkLists Add this Article to Spurl Add this Article to Google Add this Article to Ask Add this Article to Squidoo