Password Reset
Please enter your e-mail address. You will receive a new password via e-mail.
Email:
[Microsoft Access Database Tutorial](http://accessdatabasetutorial.com/)
Master Access Databases the easy way
[Skip to content](#content)
[Home](http://accessdatabasetutorial.com/)[About](http://accessdatabasetutorial.com/about/)[Offers](http://accessdatabasetutorial.com/offer/)[£1 Offer](http://accessdatabasetutorial.com/offer/1-offer/)[Login User Form eBook & Utility Offer (£ UK)](http://accessdatabasetutorial.com/offer/offers/)[Login User Form eBook & Utility Offer ($ US)](http://accessdatabasetutorial.com/offer/offer-us-visitors/)[Search Tool Utility Offer](http://accessdatabasetutorial.com/offer/searchtoolutilityoffer/)[Task Tool Utility Offer](http://accessdatabasetutorial.com/offer/tasktooloffer/)[Access Coaching](http://accessdatabasetutorial.com/offer/microsoft-access-courses-online-offer/)[Book Reviews](http://accessdatabasetutorial.com/reviews/)[Store](http://accessdatabasetutorial.com/amazon-store/)[Access VBA](http://accessdatabasetutorial.com/microsoft-access-database-vba/)[Access VBA Programming](http://accessdatabasetutorial.com/microsoft-access-database-vba/access-vba-programming/)[Access Visual Basic Editor](http://accessdatabasetutorial.com/microsoft-access-database-vba/access-visual-basic-editor/)[Code Window In More Detail](http://accessdatabasetutorial.com/microsoft-access-database-vba/microsoft-access-database-microsoft-vba-code-window/)[Types of VBA Procedures](http://accessdatabasetutorial.com/microsoft-access-database-vba/microsoft-access-database-vba-procedures/)[Applications](http://accessdatabasetutorial.com/applications/)[Training & Consultancy](http://accessdatabasetutorial.com/microsoft-access-developer-consultant/)[Access Free Stuff](http://accessdatabasetutorial.com/access-free-stuff/)[eBooks](http://accessdatabasetutorial.com/ebooks/)[How to Build an Access Database](http://accessdatabasetutorial.com/ebooks/how-to-build-an-access-database-ebook/)[How to Build Access Database Queries](http://accessdatabasetutorial.com/ebooks/how-to-build-access-database-queries-ebook/)[More Access Database Queries](http://accessdatabasetutorial.com/ebooks/more-access-database-queries-ebook/)[Understanding Access Database Relationships](http://accessdatabasetutorial.com/ebooks/understanding-access-database-relationships-ebook/)[How to Build Access Database Forms](http://accessdatabasetutorial.com/ebooks/how-to-build-access-database-forms-ebook/)[How to Build Access Database Reports](http://accessdatabasetutorial.com/ebooks/how-to-build-access-database-reports-ebook/)[Understanding And Using Access Database Macros](http://accessdatabasetutorial.com/ebooks/understanding-and-using-microsoft-access-macros/)[Contact](http://accessdatabasetutorial.com/contact/)
[← Older posts](http://accessdatabasetutorial.com/page/2/)
[Welcome to Microsoft Access Database Tutorial](http://accessdatabasetutorial.com/2012/04/05/welcome-to-microsoft-access-database-tutorial/)
Posted on [April 5, 2012](http://accessdatabasetutorial.com/2012/04/05/welcome-to-microsoft-access-database-tutorial/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Tuesday, May 01, 2012
This website is about learning how to build an Access database using the most effective techniques and tools available with very little or no knowledge and get you up and running without the need to learn all the âgeekâ speak keeping it Jargon free that most trainers and consultants like to impress you with!
If you are new to Microsoft Access or wish to know what it is, please take a look at
[An Introduction To Microsoft Access](http://accessdatabasetutorial.com/what-are-microsoft-access-databases/).
This website contains blog posts, products and general tips to help users find out all about Microsoft Access latest news and articles I feel worth mentioning and recommendations of videos and books on the subject.
[](http://accessdatabasetutorial.com/offer/microsoft-access-courses-online-offer/)[Online Coaching?](http://accessdatabasetutorial.com/offer/microsoft-access-courses-online-offer/)
As a Thank You for Visiting[
Claim Your Free eBook NOW!](http://accessdatabasetutorial.com/free-ebook-offer/)
Posted in [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) | Comments Off
[How To Create An Access Database From Excel](http://accessdatabasetutorial.com/2012/04/29/create-an-access-database-from-excel/)
Posted on [April 29, 2012](http://accessdatabasetutorial.com/2012/04/29/create-an-access-database-from-excel/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
How To Create An Access Database From Excel
To create an Access database from an Excel spreadsheet is simple enough to setup and apply. However, there are some preparations involved as data is being migrated from a ‘flat-file’ environment (which is what data in a spreadsheet provides) to a relational database (RDBMS - which is one of Microsoft Access’s strengths).
Take a look at this video tutorial to see some of the final steps in migrating and populating data to create an Access database from an Excel spreadsheet…
How To Create An Access Database From Excel
In this video which by the way is very well explained you need to have an existing database in place which means having relationships created and other objects. In fact, you do not have to have any objects in place as part of the import routines will generate new tables.
Have a plan, sketch out the data sets that will become separate tables in your Access database. Know you primary key fields (fields that will be responsible when joining tables together). Also know the data types as in the video it mentioned the contact number being stored as a number with an input mask. In some cases, it could be a text data type instead.
Creating an Access database will take some time and good planning and getting to know other important objects like queries too. In the video tutorial, it did mention the APPEND query!
To learn more about Microsoft Access, check out my eBooks on [how to create an Access database](http://accessdatabasetutorial.com/ebooks/how-to-build-an-access-database-ebook/) and in the meantime why not sign up for your
FREE copy of [how to import data into Microsoft Access](http://accessdatabasetutorial.com/free-ebook-offer/).
Posted in [Access Tables](http://accessdatabasetutorial.com/category/access-tables/), [Access Utilities](http://accessdatabasetutorial.com/category/access-utilities/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/), [Microsoft Access Training](http://accessdatabasetutorial.com/category/microsoft-access-training-2/) | Tagged [converting data excel to ms access](http://accessdatabasetutorial.com/tag/converting-data-excel-to-ms-access/), [create an access database](http://accessdatabasetutorial.com/tag/create-an-access-database/), [how to create an access database](http://accessdatabasetutorial.com/tag/how-to-create-an-access-database/), [ms access training](http://accessdatabasetutorial.com/tag/ms-access-training/), [ms online access training](http://accessdatabasetutorial.com/tag/ms-online-access-training/) | [1 Comment](http://accessdatabasetutorial.com/2012/04/29/create-an-access-database-from-excel/#comments)
[Microsoft Access Training: Everyone Needs It! Start Training MS Access Now!](http://accessdatabasetutorial.com/2012/04/25/microsoft-access-training-everyone-needs-it-start-training-ms-access-now/)
Posted on [April 25, 2012](http://accessdatabasetutorial.com/2012/04/25/microsoft-access-training-everyone-needs-it-start-training-ms-access-now/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Microsoft Access Training: Everyone Needs It! Start Training MS Access Now!
If you have dabbled with Microsoft Access but still struggle, then Microsoft Access training is essential to avoid the pitfalls and master the design, methodologies and functionality of such a powerful application.
Training MS Access has been my privilege and vocation for nearly twenty years and whichever method you use to learn Microsoft Access, there are pros and cons in the way you master the application and the time it can take.
I found quick article below to highlight some of the methods around to consider…
Is Microsoft Access Training Necessary?
There was a time when spreadsheets were sufficient for managing the massive waves of data that information [Continue reading →](http://accessdatabasetutorial.com/2012/04/25/microsoft-access-training-everyone-needs-it-start-training-ms-access-now/#more-655)
Posted in [Database Theory](http://accessdatabasetutorial.com/category/database-theory/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/), [Microsoft Access Training](http://accessdatabasetutorial.com/category/microsoft-access-training-2/) | Tagged [be an expert in ms access](http://accessdatabasetutorial.com/tag/be-an-expert-in-ms-access/), [learn access databases](http://accessdatabasetutorial.com/tag/learn-access-databases/), [microsoft access training](http://accessdatabasetutorial.com/tag/microsoft-access-training/), [training in access](http://accessdatabasetutorial.com/tag/training-in-access/), [training ms access](http://accessdatabasetutorial.com/tag/training-ms-access/) | [Leave a comment](http://accessdatabasetutorial.com/2012/04/25/microsoft-access-training-everyone-needs-it-start-training-ms-access-now/#respond)
[Access Navigation Pane: How To Use And Customise Microsoft Access Navigation Pane View](http://accessdatabasetutorial.com/2012/04/22/access-navigation-pane-how-to-use-and-customise-microsoft-access-navigation-pane-view/)
Posted on [April 22, 2012](http://accessdatabasetutorial.com/2012/04/22/access-navigation-pane-how-to-use-and-customise-microsoft-access-navigation-pane-view/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Access Navigation Pane: How Customise Microsoft Access Navigation Pane View
With the introduction of Access 2007 (and 2010), users will have noted not only the Fluent Ribbon Bar but the new Access Navigation Pane replacing the older database window.
This utility has some nice and simple features to further enhance how you manage your Access objects and in particular, filter and search objects when sharing an Access database.
From the standard object type including tables, queries, forms and reports, users can add as many groups and collect related objects in one view which makes it a very handy tool for collaborating workgroups and roles.
Objects are not copied (duplicated) when being assigned to a group but instead have a shortcut link pointing to the natural storage of the object type.
Access Navigation Pane: How To Use And Customise Microsoft Access Navigation Pane View
The following [Continue reading →](http://accessdatabasetutorial.com/2012/04/22/access-navigation-pane-how-to-use-and-customise-microsoft-access-navigation-pane-view/#more-648)
Posted in [Access Utilities](http://accessdatabasetutorial.com/category/access-utilities/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) | Tagged [access 2007 database](http://accessdatabasetutorial.com/tag/access-2007-database/), [access 2010 database](http://accessdatabasetutorial.com/tag/access-2010-database/), [access database objects](http://accessdatabasetutorial.com/tag/access-database-objects/), [access navigation pane](http://accessdatabasetutorial.com/tag/access-navigation-pane/), [how to use the navigation pane](http://accessdatabasetutorial.com/tag/how-to-use-the-navigation-pane/) | [1 Comment](http://accessdatabasetutorial.com/2012/04/22/access-navigation-pane-how-to-use-and-customise-microsoft-access-navigation-pane-view/#comments)
[Access Where Clause: The Difference Between Group By and Where in Microsoft Access Queries](http://accessdatabasetutorial.com/2012/04/19/access-where-clause-the-difference-between-group-by-and-where-in-microsoft-access-queries/)
Posted on [April 19, 2012](http://accessdatabasetutorial.com/2012/04/19/access-where-clause-the-difference-between-group-by-and-where-in-microsoft-access-queries/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Access Where Clause: The Difference Between Group By and the Access Where clause
Simple Access queries show detail, line by line records but summarising your data requires the Groups and Totals query. However, how you apply criteria may have an effect if you do not follow the rules. Using the Access ‘Where’ clause can be a better way to apply criteria to your query.
This video tutorial (less than 5 minutes) will explain the use for an Access Where clause query instead of using the ‘Group By’ option…
Access Where Clause: The Difference Between Group By and the Access Where clause
To clarify and confirm, the Access Where clause cannot be seen (or is visible) to the output of an Access query unlike the ‘Group By’ option which affects data distribution.
This is a useful attribute especially when handling complex criteria that sits in the background and is processed first before the output is called which is what the ‘Where’ clause means.To learn more about this type of query and other advanced Access queries, take a look at my eBook offer on [More Access Database Queries](http://accessdatabasetutorial.com/ebooks/more-access-database-queries-ebook/).
Posted in [Access Queries](http://accessdatabasetutorial.com/category/access-queries/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) | Tagged [access groups and total queries](http://accessdatabasetutorial.com/tag/access-groups-and-total-queries/), [access where clause](http://accessdatabasetutorial.com/tag/access-where-clause/), [how to use the where clause in access](http://accessdatabasetutorial.com/tag/how-to-use-the-where-clause-in-access/), [ms access query totals](http://accessdatabasetutorial.com/tag/ms-access-query-totals/), [ms access where clause](http://accessdatabasetutorial.com/tag/ms-access-where-clause/) | [1 Comment](http://accessdatabasetutorial.com/2012/04/19/access-where-clause-the-difference-between-group-by-and-where-in-microsoft-access-queries/#comments)
[Microsoft Access Color: How To Pick And Set The Exact Color In An Access Database](http://accessdatabasetutorial.com/2012/04/15/microsoft-access-color-how-to-pick-and-set-the-exact-color-in-an-access-database/)
Posted on [April 15, 2012](http://accessdatabasetutorial.com/2012/04/15/microsoft-access-color-how-to-pick-and-set-the-exact-color-in-an-access-database/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Microsoft Access Color: How To Pick And Set The Exact Color In An Access Database
First of all, I want to apologise (or apologize!). I’ve used the term Microsoft Access color in my title and not Microsoft Access colour (the correct spelling). This is because our American cousins built or at least assembled Microsoft Access together setting the captions to the local language – so please excuse the misspelt words.
Setting colour in your forms and reports is easy enough to find and apply even with looking at the ‘Custom’ tab when picking a colour by graphically picking from a colour pallete or setting the Red, Green, Blue (RGB) values. However, what if you wanted to pick an exact colour match but do not know the RGB code, then here’s a useful quick way to find the RGB value from a visual screens users wish to capture.
Microsoft Access Color: How To Pick And Set The Exact Color In An Access Database
There are several free downloadable colour utilities and one I use is via this link; [Quick HTML Color Picker tool](http://tiny.cc/fguscw).To find the exact Access colour required and apply it to your form or report you need to:
Open the downloaded utility which is a pop-up small window.
Navigate to the colour you wish to capture it’s RGB code which can be any Windows based view whether it be a web page, corporate document with branded colours or any application you wish to view.
Click the ‘Pick Color’ button from the pop-up window which changes you cursor to a picker icon and a preview window which follows you mouse movements.
Click on the desired colour and voila! The RGB code is generated back at the pop-up tool.
Now take this colour code and apply it to you designs.
Access colour is really simple and effective. There are no excuses left to developers saying colour shades applied are a near match.
If you need to know how to format forms and reports or any other control and attribute options to these objects, then my [eBook offers](http://accessdatabasetutorial.com/ebooks/) are at your disposal (for a small fee but guaranteed).
Posted in [Access Forms](http://accessdatabasetutorial.com/category/access-forms/), [Access Reports](http://accessdatabasetutorial.com/category/access-reports/), [Access Utilities](http://accessdatabasetutorial.com/category/access-utilities/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) | Tagged [access color](http://accessdatabasetutorial.com/tag/access-color/), [access colour](http://accessdatabasetutorial.com/tag/access-colour/), [how to choose the exact color in access](http://accessdatabasetutorial.com/tag/how-to-choose-the-exact-color-in-access/), [microsoft access color](http://accessdatabasetutorial.com/tag/microsoft-access-color/), [microsoft access colour formatting](http://accessdatabasetutorial.com/tag/microsoft-access-colour-formatting/) | [Leave a comment](http://accessdatabasetutorial.com/2012/04/15/microsoft-access-color-how-to-pick-and-set-the-exact-color-in-an-access-database/#respond)
[Access Macros: There Are Now 3 Types Of Microsoft Access Macros (2010)](http://accessdatabasetutorial.com/2012/04/12/access-macros-there-are-now-3-types-of-microsoft-access-macros-2010/)
Posted on [April 12, 2012](http://accessdatabasetutorial.com/2012/04/12/access-macros-there-are-now-3-types-of-microsoft-access-macros-2010/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Access Macros: There Are Now 3 Types Of Microsoft Access Macros (2010)
With the latest version of Microsoft Access (2010), there are now 3 types of Access macros developers can utilise and release the power of this application further.
The 3 types are as follows:
Macro Objects Embedded Macros Data Macros
Macro objects are avialable to all versions of Microsoft Access but version 2010 has a new interface tool plus more key commands and functionality. It is where you store the general procedures to your database.
Embedded macros were introduced from version 2007 and now is the default procedure when creating event driven procedures in forms and some reports.
Data macros which is exclusive to Access 2010 is the new and powerful to trigger procedures at the data level (via a Table) which is similar to Triggers in SQL Server.
Access Macros: There Are Now 3 Types Of Microsoft Access Macros (2010)
[](http://accessdatabasetutorial.com/files/2012/01/Understanding-Using-Microsoft-Access-Macros-Preview.pdf)To learn more about these 3 types of Access macros, why not take a sneak preview of my eBook by clicking on the link below or image. [
Understanding and Using Microsoft Access Macros – preview](http://accessdatabasetutorial.com/files/2012/01/Understanding-Using-Microsoft-Access-Macros-Preview.pdf).
Posted in [Access Macros](http://accessdatabasetutorial.com/category/access-macros/), [Access Utilities](http://accessdatabasetutorial.com/category/access-utilities/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) | Tagged [access data macros](http://accessdatabasetutorial.com/tag/access-data-macros/), [Access Macros](http://accessdatabasetutorial.com/tag/access-macros/), [embedded macros in access](http://accessdatabasetutorial.com/tag/embedded-macros-in-access/), [how to create access macros](http://accessdatabasetutorial.com/tag/how-to-create-access-macros/), [microsoft access macros](http://accessdatabasetutorial.com/tag/microsoft-access-macros/) | [Leave a comment](http://accessdatabasetutorial.com/2012/04/12/access-macros-there-are-now-3-types-of-microsoft-access-macros-2010/#respond)
[Access SQL View: An Alternative View For Your Microsoft Access Database Query](http://accessdatabasetutorial.com/2012/04/09/access-sql-view-an-alternative-view-for-your-microsoft-access-database-query/)
Posted on [April 9, 2012](http://accessdatabasetutorial.com/2012/04/09/access-sql-view-an-alternative-view-for-your-microsoft-access-database-query/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Access SQL View: An Alternative View For Your Microsoft Access Database Query
We all know that Access queries is the heart of how to drive your database and in some cases using the Access SQL view to create such queries gives you better control and a clearer understanding of the Simple Query Language (S.Q.L.).
Take a look at how to gain access to the SQL view and the visual relationship between the gird and SQL view.
Access SQL View: An Alternative View For Your Microsoft Access Database Query
Where do you need to use the Access SQL view? Well, there are a handful of more specialised queries that the QBE grid will not be available for and that means having to use this view.
For example, the UINION query is such an instance and this query can start life by using the grid interface as shown in the video tutorial and then switching to the SQL view to continue and complete the query definition. I’m not going to explain what this query is about here but you may want to consider my [More Advanced Queries eBook](http://accessdatabasetutorial.com/ebooks/more-access-database-queries-ebook/) to find out.
In the meantime, If you want to start to master the Access SQL view and write in SQL (which is pronounced ‘sequel’), You can download my [FREE SQL Reference Guide](http://accessdatabasetutorial.com/files/2011/02/SQL-Language-Reference-Basics.pdf) which will give some pointers into writing SQL in Access.
Posted in [Access Queries](http://accessdatabasetutorial.com/category/access-queries/), [Access Utilities](http://accessdatabasetutorial.com/category/access-utilities/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) | Tagged [access sql view](http://accessdatabasetutorial.com/tag/access-sql-view/), [ms access queries](http://accessdatabasetutorial.com/tag/ms-access-queries/), [sql view in access databases](http://accessdatabasetutorial.com/tag/sql-view-in-access-databases/), [using the sql view](http://accessdatabasetutorial.com/tag/using-the-sql-view/), [what is the use of view in sql](http://accessdatabasetutorial.com/tag/what-is-the-use-of-view-in-sql/) | [1 Comment](http://accessdatabasetutorial.com/2012/04/09/access-sql-view-an-alternative-view-for-your-microsoft-access-database-query/#comments)
[Microsoft Access Properties: What’s The ‘HasModule’ Property In An Access Database?](http://accessdatabasetutorial.com/2012/04/05/microsoft-access-properties-whats-the-hasmodule-property-in-an-access-database/)
Posted on [April 5, 2012](http://accessdatabasetutorial.com/2012/04/05/microsoft-access-properties-whats-the-hasmodule-property-in-an-access-database/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Microsoft Access Properties: What’s The ‘Has Module’ Property In An Access Database?
There are many Microsoft Access properties to set and control your Access database with and when combined in certain permutations, it changes the whole dynamics of your database and how they will perform and behave.
One property I want to mention here affects performance and the overall file size of your database and applies to the main form or report properties. The property is called ‘Has Module’.
Microsoft Access Properties: What’s The ‘Has Module’ Property In An Access Database?
The ‘Has Module’ property is a Boolean value (which means either a True or False option) and by default it is set as No (False). When [Continue reading →](http://accessdatabasetutorial.com/2012/04/05/microsoft-access-properties-whats-the-hasmodule-property-in-an-access-database/#more-624)
Posted in [Access Forms](http://accessdatabasetutorial.com/category/access-forms/), [Access Modules](http://accessdatabasetutorial.com/category/access-modules/), [Access Reports](http://accessdatabasetutorial.com/category/access-reports/), [Access VBA](http://accessdatabasetutorial.com/category/access-vba/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) | Tagged [has module property](http://accessdatabasetutorial.com/tag/has-module-property/), [microsoft access properties](http://accessdatabasetutorial.com/tag/microsoft-access-properties/), [ms access vba module](http://accessdatabasetutorial.com/tag/ms-access-vba-module/), [properties in ms access](http://accessdatabasetutorial.com/tag/properties-in-ms-access/), [what is the has module property](http://accessdatabasetutorial.com/tag/what-is-the-has-module-property/) | [2 Comments](http://accessdatabasetutorial.com/2012/04/05/microsoft-access-properties-whats-the-hasmodule-property-in-an-access-database/#comments)
[Compile Access? What About Decompiling Microsoft Access Databases Too?](http://accessdatabasetutorial.com/2012/04/01/compile-access-what-about-decompiling-microsoft-access-databases-too/)
Posted on [April 1, 2012](http://accessdatabasetutorial.com/2012/04/01/compile-access-what-about-decompiling-microsoft-access-databases-too/) by [Ben](http://accessdatabasetutorial.com/author/benb/)
Compile Access? What About Decompiling Microsoft Access Databases Too?
The Compile Access VBA and the need to decompile your code can significantly reduce the file size of your Access database and also resolves corruptions (if found).
Microsoft Access stores VBA code as both source and compiled code and sometimes some of the compiled VBA code can become corrupt meaning it needs to be flushed or rinsed clean.
Therefore, running Microsoft Access in a “decompile” mode causes all the compiled VBA code to be flagged as invalid which then is removed.
Once this happens and the compiled code has been removed, the database size is also significantly reduced when the database is onece again compacted.
Compile Access? What About Decompiling Microsoft Access Databases Too – How?
You will need to open your Access database using the “/decompile” switch (which is not widely documented) which will discard all the old VBA Access compile code, and leave just your Access VBA source code. You will then need to re-compile the VBA code again.
To decompile your Access database, follow these steps:
From the Windows, Start, Run command line (or Windows key + R), type: msaccess.exe /decompile where msaccess.exe includes the complete path of your installed Microsoft Access database application i.e.
“C:Program FilesMicrosoft OfficeOffice14MSACCESS.EXE” /decompile
When Microsoft Access opens, open the database you want to decompile making sure any trusted locations and securities are enabled (where applicable). Navigate to any module (use ALT + F11) and run the Access Compile command which is found via the Debug menu and then save your changes. Go back to the database application and carry out a new Compact and Repair Database action (which varies between versions).
Now the database file size should be reduced and any strange errors related to the Access VBA code has been resolved.
Posted in [Access Modules](http://accessdatabasetutorial.com/category/access-modules/), [Access VBA](http://accessdatabasetutorial.com/category/access-vba/), [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) | Tagged [access compile](http://accessdatabasetutorial.com/tag/access-compile/), [compile access](http://accessdatabasetutorial.com/tag/compile-access/), [complie access vba code](http://accessdatabasetutorial.com/tag/complie-access-vba-code/), [how to decompile ms access](http://accessdatabasetutorial.com/tag/how-to-decompile-ms-access/), [ms access tools](http://accessdatabasetutorial.com/tag/ms-access-tools/) | [Leave a comment](http://accessdatabasetutorial.com/2012/04/01/compile-access-what-about-decompiling-microsoft-access-databases-too/#respond)
[← Older posts](http://accessdatabasetutorial.com/page/2/)
* Email Firstname Surname * Required Field
------
Search
Search for:
------
[](http://accessdatabasetutorial.com/ebooks/understanding-and-using-microsoft-access-macros/)
------
[](http://accessdatabasetutorial.com/ebook-bundle-offer/)
------
My Articles...
[ ](http://EzineArticles.com/?expert=Ben_S_Beitler)
------
[ ](http://www.cimaware.com/info/info.php?lang=en&id=1651&path=accessfix.html)
------
Recents Posts
[How To Create An Access Database From Excel](http://accessdatabasetutorial.com/2012/04/29/create-an-access-database-from-excel/) [Microsoft Access Training: Everyone Needs It! Start Training MS Access Now!](http://accessdatabasetutorial.com/2012/04/25/microsoft-access-training-everyone-needs-it-start-training-ms-access-now/) [Access Navigation Pane: How To Use And Customise Microsoft Access Navigation Pane View](http://accessdatabasetutorial.com/2012/04/22/access-navigation-pane-how-to-use-and-customise-microsoft-access-navigation-pane-view/) [Access Where Clause: The Difference Between Group By and Where in Microsoft Access Queries](http://accessdatabasetutorial.com/2012/04/19/access-where-clause-the-difference-between-group-by-and-where-in-microsoft-access-queries/) [Microsoft Access Color: How To Pick And Set The Exact Color In An Access Database](http://accessdatabasetutorial.com/2012/04/15/microsoft-access-color-how-to-pick-and-set-the-exact-color-in-an-access-database/)
Archives
[April 2012](http://accessdatabasetutorial.com/2012/04/) [March 2012](http://accessdatabasetutorial.com/2012/03/) [February 2012](http://accessdatabasetutorial.com/2012/02/) [January 2012](http://accessdatabasetutorial.com/2012/01/) [December 2011](http://accessdatabasetutorial.com/2011/12/) [November 2011](http://accessdatabasetutorial.com/2011/11/) [October 2011](http://accessdatabasetutorial.com/2011/10/) [September 2011](http://accessdatabasetutorial.com/2011/09/) [August 2011](http://accessdatabasetutorial.com/2011/08/) [July 2011](http://accessdatabasetutorial.com/2011/07/) [June 2011](http://accessdatabasetutorial.com/2011/06/) [May 2011](http://accessdatabasetutorial.com/2011/05/) [April 2011](http://accessdatabasetutorial.com/2011/04/) [March 2011](http://accessdatabasetutorial.com/2011/03/) [February 2011](http://accessdatabasetutorial.com/2011/02/) [January 2011](http://accessdatabasetutorial.com/2011/01/) [December 2010](http://accessdatabasetutorial.com/2010/12/)
Categories
[Access Forms](http://accessdatabasetutorial.com/category/access-forms/) [Access Functions](http://accessdatabasetutorial.com/category/access-functions-2/) [Access Macros](http://accessdatabasetutorial.com/category/access-macros/) [Access Modules](http://accessdatabasetutorial.com/category/access-modules/) [Access Queries](http://accessdatabasetutorial.com/category/access-queries/) [Access Reports](http://accessdatabasetutorial.com/category/access-reports/) [Access Tables](http://accessdatabasetutorial.com/category/access-tables/) [Access Utilities](http://accessdatabasetutorial.com/category/access-utilities/) [Access VBA](http://accessdatabasetutorial.com/category/access-vba/) [Access Web](http://accessdatabasetutorial.com/category/access-web/) [Database Theory](http://accessdatabasetutorial.com/category/database-theory/) [Microsoft Access](http://accessdatabasetutorial.com/category/microsoft-access/) [Microsoft Access Training](http://accessdatabasetutorial.com/category/microsoft-access-training-2/)
Connect Up!
[](http://feeds.feedburner.com/AccessDatabaseTutorial) [
Subscribe in a reader
](http://feeds.feedburner.com/AccessDatabaseTutorial)
[](http://www.twitter.com/benbeitler)
[](http://www.linkedin.com/in/benbeitler)
[](http://www.youtube.com/user/bsbeitler)
[](http://benb6724.farrell21.hop.clickbank.net)
Links
[Audiences](http://www.kantarmedia-audiences.com/) [Free online user guide at About Access Databases](http://www.About-Access-Databases.com) [Great Access Database resource tool](http://www.access-database.com/) [Great Excel VBA online user guide](http://www.excel-spreadsheet.com/vba/vba.htm) [Learning SEO Optimization | Finding Keyword Phrases](http://findingkeywordphrases.com/) [SpreadsheetYogi.com – Computer Foundations & Excel](http://www.spreadsheetyogi.com) [Want an Access database built?](http://www.trainingpartnership.biz/consultant.htm)
------
Excel Hero Academy[](https://www.e-junkie.com/ecom/gb.php?cl=123304&c=ib&aff=178600)
[Click here to visit excelhero.com.](https://www.e-junkie.com/ecom/gb.php?cl=123304&c=ib&aff=178600)
------
------
[](http://www.bluehost.com/track/acceedatabasetutorial)
------
Tags
[access 2003](http://accessdatabasetutorial.com/tag/access-2003/) [Access 2007](http://accessdatabasetutorial.com/tag/access-2007/) [access 2010](http://accessdatabasetutorial.com/tag/access-2010/) [Access Database](http://accessdatabasetutorial.com/tag/access-database/) [Access database 2007](http://accessdatabasetutorial.com/tag/access-database-2007/) [access database deisgn](http://accessdatabasetutorial.com/tag/access-database-deisgn/) [access database normalisation](http://accessdatabasetutorial.com/tag/access-database-normalisation/) [access database queries](http://accessdatabasetutorial.com/tag/access-database-queries/) [access database relationships](http://accessdatabasetutorial.com/tag/access-database-relationships/) [Access database tutorial](http://accessdatabasetutorial.com/tag/access-database-tutorial/) [access database vba](http://accessdatabasetutorial.com/tag/access-database-vba/) [Access Help](http://accessdatabasetutorial.com/tag/access-help/) [Access Macros](http://accessdatabasetutorial.com/tag/access-macros/) [access on the web](http://accessdatabasetutorial.com/tag/access-on-the-web/) [access rdbms](http://accessdatabasetutorial.com/tag/access-rdbms/) [access relational database](http://accessdatabasetutorial.com/tag/access-relational-database/) [Access Relational Databases](http://accessdatabasetutorial.com/tag/access-relational-databases/) [Access to Excel VBA](http://accessdatabasetutorial.com/tag/access-to-excel-vba/) [access vba](http://accessdatabasetutorial.com/tag/access-vba-2/) [access v excel](http://accessdatabasetutorial.com/tag/access-v-excel/) [buliding an access database](http://accessdatabasetutorial.com/tag/buliding-an-access-database/) [calculate in a query](http://accessdatabasetutorial.com/tag/calculate-in-a-query/) [calculating in an access report](http://accessdatabasetutorial.com/tag/calculating-in-an-access-report/) [calculating queries](http://accessdatabasetutorial.com/tag/calculating-queries/) [database normalisation](http://accessdatabasetutorial.com/tag/database-normalisation/) [designing an access database](http://accessdatabasetutorial.com/tag/designing-an-access-database/) [Expression Builder](http://accessdatabasetutorial.com/tag/expression-builder/) [Expression Builder tool](http://accessdatabasetutorial.com/tag/expression-builder-tool/) [Formula query](http://accessdatabasetutorial.com/tag/formula-query/) [how to build an access database](http://accessdatabasetutorial.com/tag/how-to-build-an-access-database/) [how to create an access database](http://accessdatabasetutorial.com/tag/how-to-create-an-access-database/) [how to create a query](http://accessdatabasetutorial.com/tag/how-to-create-a-query/) [macro designer](http://accessdatabasetutorial.com/tag/macro-designer/) [microsoft access database](http://accessdatabasetutorial.com/tag/microsoft-access-database/) [microsoft access macros](http://accessdatabasetutorial.com/tag/microsoft-access-macros/) [ms access database](http://accessdatabasetutorial.com/tag/ms-access-database/) [ms access help](http://accessdatabasetutorial.com/tag/ms-access-help/) [ms access macros](http://accessdatabasetutorial.com/tag/ms-access-macros/) [ms access queries](http://accessdatabasetutorial.com/tag/ms-access-queries/) [Navigation Pane](http://accessdatabasetutorial.com/tag/navigation-pane/) [primary key](http://accessdatabasetutorial.com/tag/primary-key/) [Programming in Access](http://accessdatabasetutorial.com/tag/programming-in-access/) [RDBMS](http://accessdatabasetutorial.com/tag/rdbms/) [Ribbon Bars](http://accessdatabasetutorial.com/tag/ribbon-bars/) [what's new in access 2007](http://accessdatabasetutorial.com/tag/whats-new-in-access-2007/)
[Any appreciation for the content provided as a resource for Access users is always welcomed! Thanks.](https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=ben@beitlers.com¤cy_code=GBP&amount=&return=http://accessdatabasetutorial.com/thank-you-tip-jar/&item_name=)
© 2012 Access Database Tutorial
| [Terms Of Use](http://accessdatabasetutorial.com/access-database-tutorial-terms-of-use/) | [Privacy Policy](http://accessdatabasetutorial.com/access-database-tutorial-privacy-policy/)
| [Contact Us](http://accessdatabasetutorial.com/contact/) |
[ Microsoft Access Database Tutorial ](http://accessdatabasetutorial.com/)
[Proudly powered by WordPress.](http://wordpress.org/)
[Close [x]](#)
Grab the FREE 5 Day Mini Email Course on Access Database (£27 Value) and Discover the 5 BEST Steps to Designing That Access Relational Database. Enter your email in the box to the right...
Thank You!
