Archive | January, 2010
Access-Database-Save-As-PDF

Create a PDF file with a Microsoft Access macro

In Microsoft Access 2010 one of the new features is to save data as PDF format files. You can also do this by using Microsoft Access macros. Click on the ‘Create’ tab. Click on the macro button on the top right hand side. At the right of the screen you will see a window for the [...]

Read full storyComments Off

MS Access Macro – How To Open a Report

An MS Access macro is a great tool for automating our databases. We can use Microsoft Access macro actions for many tasks. In this demonstration I am going to open a report by using a macro. The MS Access macro designer has three main columns 1. Macro Name 2. Action 3. Comment Enter the name [...]

Read full storyComments Off

Using the MS Access macro

When we want to automate certain aspects of our database we can take two routes. The first is to learn how to program or the second to learn how to use MS Access macros Macros consists of actions which instruct Access to perform tasks. For example we may have a macro to backup our tables,forms [...]

Read full storyComments Off

Working with Microsoft Access databases

One should always use the right tool for the right job. If you want to store large volumes of data and have many users then think if Microsoft Access databases are the best way to go. Microsoft Access databases tend to be better suited to small systems with around ten or less users. For anything [...]

Read full storyComments Off

Using Microsoft Access database queries

Entering data in a database is done through tables or forms, but when we want to get our data out we should use Microsoft Access database queries. A Microsoft Access database query can produce a complete or a subset of data. You can also choose to restrict the data returned based on criteria you feed [...]

Read full storyComments Off

Microsoft Access 2007 for dummies

The world’s most popular desktop database, Microsoft Access has seen many versions. The latest is known as Office Access 2007 and is the most radical release yet. It offers a wide range of features for beginners and seasoned users alike. There are many books on the market including “Microsoft Access 2007 for dummies” which will [...]

Read full storyComments Off

Advantages of using a Microsoft Access Database

In today’s information age we are becoming less reliant on paper. When keeping records, be it household or business, it is a good idea to keep our information using some kind of computer solution. A Microsoft Access Database provides the perfect solution to our problems. There are different approaches we can take. We could look [...]

Read full storyComments Off

Discovering the Microsoft Office Access database

Microsoft Office has been around for many years and includes at its core Access, Word, Excel, PowerPoint and Outlook. Microsoft Office is the world’s most popular office suite and is used on millions of PC desktops. The application used for storing and retrieving large volumes of data is the Microsoft Office Access database. Previously it [...]

Read full storyComments Off