David Frost Reviews, Ratings and general rants and raves.

Microsoft Access has many useful objects and one of them is macro. Macro adds more functionality and control to your Access database. You can create macros to perform almost any task in your database and it is not that hard. Using macros is the next step of using building and designing your database after mastering all the basics like tables, forms, queries and reports. But it is still easier than writing VBA code for Access. You can quickly learn to use macros and automate some of your database tasks to save your time and effort. There are different macros in Access and one of them in autoexec macro.

This macro runs as you start the database. So, this macro can be assigned to perform any tasks you want at this time. For example, you may wish to open a particular form and move to creating a new record. This is easy to do with macro. You should go to the macro designer and add new task of running the form and creating a new record. Then, you should save the macro naming it AutoExec. Close the database properly and then run it again. You will see that the macro will kick into action and you will see your assigned task performed.

Autoexec macro in Access can be assigned with any actions you wish. You might also wish to backup the data, when the database opens. You can assign an action to transfer the data or even objects to another database. You can also create a make table query for making the data backup and then run this actions in Autoexec macro. If you want to run a delete query with a macro, then you have to set the warnings to be incorrect in the macro.

Usually it is better to perform simple actions with Autoexec macro in Access. If you want to avoid running Autoexec macro then you can hold the shift key when your database is opening. The macro will not start and the database will run as usual.

You can choose any form to load when the database is opening, but a good choice of a form is a login form. When your system loads, login form will be the first thing you see. At this point you can also minimize the database window.

So if you load the macro designer and improvise with different macro actions, you will be able to add more functionality and control to your database. Adding macros to your basic database functions, you will be thrilled at what your Access application can do. Using macro is not that hard and you can learn to create them after an advanced Access training and then practicing it with your database application.

Need help with access database examples – this web site with microsoft access database advice and assistance can be the one that you’ve been looking for.

And a final piece of advice – today the online technologies give you a really unique chance to choose what you want for the best price on the market. Funny, but most of the people don’t use this chance. In real practice it means that you should use all the tools of today to get the info that you need.

Search Google and other search engines. Visit social networks and have a look on the accounts that are relevant to your topic. Go to the niche forums and join the online discussion. All this will help you to create a true vision of this market. Thus, giving you a real chance to make a wise and nicely balanced decision.

And also sign up to the RSS feed on this blog, because we will do the best to keep updating this blog with new publications about microsoft access database industry.

If you want to create the best possible Microsoft Access database, then this article might be useful to you. The items described in this article have been proved to be the main causes of slow performance, user difficulties, errors and data corruption in databases. Avoiding these mistakes will help you prevent minor or major database problems. So, here are the guidelines you should follow.

In order to increase the form’s performance and the loading of the drop down list, you should use the stored queries as the source of your record, because Access has already optimized them.

It is also important to use validation rules. This will help prevent errors due to data entry, because you will be able to restrict what information can be entered in the field. Let your user know what is required by using a message box. If you use the fields tag property, it will be easy to encode the type of validation for each field. Then you can simply loop through the fields list to select the validations. In order to increase the performance speed, you can also index the fields used in queries that link to the tables and the fields used as criteria in queries.

You can also increase the processing speed and using fewer amounts of storage and memory by optimizing the data types.

In order to have control over the solving database problems, always add code error handling to your routines. MDE file can stop working without letting you know anything useful about the error. For the same reason you shouldn’t use macros which do not allow trapping errors, except for menus.

Let users access only a copy of the front end database, which has everything except data. Never allow users access the original front end file. This way you will prevent the risk of unforeseen corruption. Make sure you always split the database into front end and the back end. The back end data should be placed on the network share and it should be compacted regularly. This will let you see if any data is corrupted or if any table indexing is corrupted. It will also reduce the file size.

When you link tables to dependent tables, use auto number field. They give better indexing and are harder for users to modify.

If you want to check for a potential duplicate data, use a code instead of multi-field key, which prevents duplicate data. You should also use the same name in related tables. Avoid using record sets in a multi-user environment unless it is a snapshot. And on large updates of record set, use BeginTrans and CommitTrans operations in order to speed up the updates by storing them in memory buffer temporarily.

These are some of the important points you should use, if you want to create an efficient and functional Access database and reduce the risk of corruption.

Need help with access database examples – this web site with microsoft access database advice and assistance can be the one that you’ve been looking for.

And some general tips – today the online technologies give you a really unique chance to choose exactly what you require for the best price on the market. Strange, but most of the people don’t use this opportunity. In real practice it means that you must use all the tools of today to get the information that you need.

Search Google and other search engines. Visit social networks and have a look on the accounts that are relevant to your topic. Go to the niche forums and join the discussion. All this will help you to create a true vision of this market. Thus, giving you a real chance to make a wise and nicely balanced decision.

P.S. And also sign up to the RSS feed on this blog, because we will everything possible to keep this blog tuned up to the day with new publications about microsoft access database industry.

Many Access database users consider creating a form quite easy. But, unfortunately, not every user is aware that each form also has property settings, which we can changed to control form’s look and behavior. In this article you will find out how to manage form’s properties from a property sheet. You will also learn some of the common property settings in Access form.

Form properties are rules, which control everything about a form like its look and functions. All MS Access objects have their own properties. Then, all form controls like text box, label etc also have their own set of properties. You can access these properties through the property sheet. To open a property sheet, click on the button at the form’s top left corner. You will see different categories the properties are grouped in such as format category, data properties, event properties, other properties and the all category.

The format category has the properties, which control the look of the form. You can apply these properties, if you want to define the look of the form and what items you want in the form. You can set up scroll bars and navigation buttons in the form.

Property sheet has a lot of different properties, so it will be hard to remember all of them. But if you need to learn about a particular property, you can simply select it and press F1. On a help page, you will get a short explanation and examples of how to use the property.

The data properties allow you to control things like the source of the data, whether you should allow other users to edit, delete or enter data and what kind of things users can do with the data.

Event properties are used to determine actions taken upon an occurring event like opening of the form or data update, etc. You can assign an action for each property to perform by clicking on the builder button. This will open the Choose Builder dialogue box letting you determine the action.

Other properties category has miscellaneous items, which can be very useful for designing your form. There are different properties like Pop Up and Modal. So you can make your form appear like a pop up window. Or if you use Modal property, the form will have the exclusive focus and you will have to close the form first, if you want to move the focus somewhere else.

And, logically, the all category contains all properties together. A long list of different properties is available for you to use, change your form and define different form functions. Each of them can help you optimize your form as you wish and give you more control over your form.

Need help with access database examples – this web site with microsoft access database advice and assistance can be the one that you’ve been looking for.

And some general tips – today the web technologies give you a truly unique chance to choose what you require at the best terms which are available on the market. Funny, but most of the people don’t use this opportunity. In real life it means that you must use all the tools of today to get the info that you need.

Search Google and other search engines. Visit social networks and have a look on the accounts that are relevant to your topic. Go to the niche forums and join the discussion. All this will help you to create a true vision of this market. Thus, giving you a real opportunity to make a smart and nicely balanced decision.

P.S. And also sign up to the RSS on this blog, because we will do the best to keep this blog tuned up to the day with new publications about microsoft access database industry.

Microsoft Access database has lots of useful features and one of them is combo boxes. Using combo boxes will improve the look and feel of your Access forms. In order to understand the work of combo boxes, let’s consider the example of countries.

Access forms may require different information like name, address or country. And as we know some countries’ names can be recorded in few ways, for example the United Kingdom is also known as the UK, England, Britain, and Great Britain. And if you have entered a different name of the country every time you wanted to record the United Kingdom, it might cause some problems. If you want to run a query and search for all customers in the UK, you will get a wrong result. The query will show you all the customers registered under “the UK”, but will not show other records you might have entered as “Britain” or “England”, for example. You will also have the same problem with the United States.

Another problem, which may arise, is an incorrect spelling of the name of the country. One time you might record country as Brazil, and the next time you might spell it as Brasil. And again you will get wrong results in your search.

The solution to this problem is using a dropdown box or MS Access combo box. Using combo boxes will also speed up the process of data entry, because you will not have to type the data in, but select it from the list.

MS Access combo box can use table or a query as its data source. It is probably better to use a query, just because you can filter the data you need in a query. Imagine that you need only European countries in your form, so using a query you can set the needed criteria. Besides, queries work faster than tables, which will also improve your performance.

It is not that hard to create a combo box for any type of information you store in your database. And you can also use the Access Wizard for this purpose, which makes the process even easier.

When you use a combo box in Microsoft Access, you don’t have to worry about entering the wrong information in the database, which often leads to problems. Every record you have to create in Access database will always have the same items to select from, which prevents typing in the same information in different variations. You will simply select the one correct data item from a combo box and your data as well as the form will be more consistent. Learning how to create and use combo boxes in Access can prevent many database problems and save time.

Need help with access database examples – this web site with microsoft access database advice and assistance can be the one that you’ve been looking for.

And a final piece of advice – today the online technologies give you a really unique chance to choose exactly what you need at the best terms which are available on the market. Strange, but most of the people don’t use this chance. In real practice it means that you should use all the tools of today to get the info that you need.

Search Google or other search engines. Visit social networks and have a look on the accounts that are relevant to your topic. Go to the niche forums and participate in the discussion. All this will help you to build up a true vision of this market. Thus, giving you a real chance to make a smart and nicely balanced decision.

P.S. And also sign up to the RSS on this blog, because we will everything possible to keep updating this blog with new publications about microsoft access database industry.

Microsoft Access database has many tools and objects for performing different tasks. One of the main objects in Access database is a table. Access tables are used to hold data. Each table is made up of columns, which can be also called fields or attributes. Each of the fields has a particular data type defining the information it can store. So, if you need to enter numeric information like prices, you should use number or currency data type fields. If you need to enter first or last name, the best data type field would be the text one. A memo data type is an alternative to a text data type field. MS Access memo field is used to store text, but the difference with the text data type is that it can store a lot more text than the general field.

There are certain times when we should use memo data type fields. They are best used in cases when we have to enter notes or description. Sometimes we need to store a lot of data about a transaction or one of the customers and that is when we would use memo data type.

Usually, when we use form, we would make the size of the memo text box bigger and set its main property to New line in field, which will allow us to prevent the data bunching together in one long paragraph. But you should keep in mind that we cannot index or sort MS Access memo fields. These fields also have limitations when used in queries. But you would actually avoid using memo fields in queries that is why it is not a big issue.

If you use MS Access 2007, you can apply rich text formatting in the memo field both in form as well as datasheet views. In order to perform this, you should set the text format feature of the memo field for it to become Rich Text.

You always have to make sure that you use the correct data types in your database. Very often this aspect is discovered through the trial and error experience, but a proper planning can greatly improve your Access database performance. This is also one of the aspects learned during the Microsoft Access training, which is highly recommended to take for every Access user before creating a database. Proper Access database learning can give you more confidence in using the software and also let you prevent many database development mistakes, therefore, saving a lot of time for you. Microsoft Access is complex software and even though it provides a great level of flexibility, database users still have to follow rules for the application to work properly and prevent data loss.

Need help with access database samples – this web site with microsoft access database advice and assistance can be the one that you’ve been looking for.

And some general tips – today the online technologies give you a truly unique chance to choose exactly what you require at the best terms which are available on the market. Funny, but most of the people don’t use this chance. In real practice it means that you must use all the tools of today to get the information that you need.

Search Google and other search engines. Visit social networks and check the accounts that are relevant to your topic. Go to the niche forums and join the discussion. All this will help you to build up a true vision of this market. Thus, giving you a real opportunity to make a smart and nicely balanced decision.

P.S. And also sign up to the RSS feed on this blog, because we will do the best to keep updating this blog with new publications about microsoft access database industry.

There are many database systems available, but one application has been the most popular for a very long time and it is probably going to keep its popularity. This database application is Microsoft Access. If you consider taking the Microsoft Access training, you should think how it might affect you personally as well as your company. Having database development skills among others is a great addition to your resume. And if you also have the spreadsheet skills to compliment the database experience, then you will easily find a good job in out information based world.

But what are the main database skills that are most important to get? A good place to start is to have the knowledge of relational database theory, which includes the information about how one piece of data can be related to another. You will be able to relate the customer to an order or link a student to a class. You will also know if the student can belong to only one class and if the course can be available to one or many students. These examples are used to explain the basis of the theory of relational database.

After you obtain enough knowledge about relational database theory and know how to relate data, you can start creating the databases. You will begin with creating tables for storing your data and then relate the tables together. Once you master this part, you can move on to designing the screens also known as forms, which are used for entering data. You will be able to add controls to your forms and make sure they are easy to use.

By now you have the tables for keeping the data and forms for entering data to the database. Now it is time to learn how to get the data out of the database. You will use queries for extracting data from the database. It might seem tricky for Access beginners, but after a good training course you will easily get a hang of it. Queries are extremely useful in your database, because you can get the needed data quickly without having to look for it manually, checking every table and field. You can set the needed criteria when you run the query and it will give you results very quickly. You can also then use the data from these queries to create a bar chart or a graph.

One more very useful object present in Access database is a report. You are able to present the data in a printed format by creating simple reports after running the query. Microsoft Access also gives you the possibility to link to other MS Office applications. It is a very useful option, which can greatly increase your productivity and save a lot of time.

Need help with access database examples – this web site with microsoft access database advice and assistance can be the one that you’ve been looking for.

And a final piece of advice – today the web technologies give you a really unique chance to choose exactly what you want for the best price on the market. Strange, but most of the people don’t use this chance. In real practice it means that you must use all the tools of today to get the information that you need.

Search Google and other search engines. Visit social networks and have a look on the accounts that are relevant to your topic. Go to the niche forums and participate in the discussion. All this will help you to build up a true vision of this market. Thus, giving you a real chance to make a wise and nicely balanced decision.

And also sign up to the RSS on this blog, because we will do the best to keep updating this blog with new publications about microsoft access database industry.

The smallest storage area in MS Access database is a page. All changes performed in Access database should be done by temporarily locking all the database pages. Locking the pages will help avoid corruption, because all the users might not be able to modify the data at the same time. But if the pages stay unlocked, the high risk of database corruption remains. The best method to solve any type of database corruption in Access is to use valid backup to restore all the files. But if the updated backup is not available or the backup cannot restore the necessary data, then you will have to use a third party advanced Access repair software, which can completely restore your corrupted database.

In case of database corruption you may encounter any of these error messages, when you try to open your Access database. The error message may inform you that the disk space is not enough or that there is not enough memory to undo the data modifications the query is about to make. Each time you try to access your data you see the same error message. It can severely decrease your work productivity, because all the data in your database becomes inaccessible.

There are several reasons why this may happen to your database. And the main cause is the exceeding the amount of locks per database. The above mentioned error messages pop up mostly while turning on large databases. If you want to prevent such errors from happening, you should increase the decimal value with 9500 set as default in Value Data field.

In order to resolve the above problem and get access to all database files, you will have to make some alterations in Windows Registry. But if you make the smallest mistake while adding changes to the registry can lead to serious problems. In order to prevent all these problems and gain access to the database, you will have to use powerful Access repair software. Such advanced repair utilities apply scanning algorithms, which recover all MS Access database objects. Such utilities can also completely repair and restore all Access databases you cannot get access to. These repair utilities are also built with an interactive and very user-friendly interface, what makes them easy to understand and use for everyone, even without special prior training. You can find such programs for every MS Access database versions and for most operational systems.

The power and flexibility of Access database makes it prone to have different problems and damages. Database corruption may cost you a lot of time and even lead to important data loss. So, it is crucial to have one of these advanced Access repair utilities, especially if you have a large database.

Need help with access database samples – this web site with microsoft access database advice and assistance can be the one that you’ve been looking for.

And a final piece of advice – today the Internet technologies give you a really unique chance to choose what you require at the best terms which are available on the market. Funny, but most of the people don’t use this opportunity. In real practice it means that you must use all the tools of today to get the info that you need.

Search Google and other search engines. Visit social networks and have a look on the accounts that are relevant to your topic. Go to the niche forums and participate in the discussion. All this will help you to build up a true vision of this market. Thus, giving you a real opportunity to make a smart and nicely balanced decision.

P.S. And also sign up to the RSS on this blog, because we will do the best to keep this blog tuned up to the day with new publications about microsoft access database industry.