Tools In Ms Access Databases: Avoid Microsoft Access Corruptions

Tools In Ms Access Databases: Avoid Microsoft Access Corruptions

One of the most popular desktop relational database applications of today, sometimes Microsoft Access can get a little ‘confused‘ causing corruption of which there are tools in MS Access to help manage and keep a handle of your database.

As a result of some corrupted database files, you are either unable to gain access or see data in the consistent format as expected or worse still, keeps crashing when view a particular record.

tools in ms accessThe reasons why Microsoft Access Continue reading “Tools In Ms Access Databases: Avoid Microsoft Access Corruptions”

Microsoft Access Database Normalization Versus DeNormalization

Microsoft Access Database Normalization Versus De-Normalization

To normalize or to de-normalize that is the question!

Database normalization is widely misunderstood. Any new database system should adopt some level of database normalization (a minimum of ‘Third Normal Form (3NF)’) but what does this really mean?

The idea behind database normalization is to protect and maintain the data integrity keeping your data complete and consistent when storing data (input) to handling effective reporting (output). Keeping records in one place which can be related and impact data values in other places is the trick and this is why normalization is normally the methodology used here when designing an Access database.

Having smaller and re-usable manageable units of information maintains Continue reading “Microsoft Access Database Normalization Versus DeNormalization”

Microsoft Access Macros – Access 2010 Makes It Even Easier To Use

Microsoft Access Macros – Access 2010 Makes It Even Easier To Use

Using Microsoft Access macros adds just a little more professionalism and polished look and feel users expect with any user-friendly application.

This quick demonstration gives you an overview of the newer macro designer tool in Access 2010 which makes it really user intuitive to use.

httpv://youtu.be/6zvbK9x8rGw

Microsoft Access Macros – Access 2010 Makes It Even Easier To Use

Learning the actions, their arguments mastering the syntax is your next step to taking Microsoft Access macros to the automating your Access database. The narrator also drop a little tip for you too; saving a macro as ‘AutoExec’ will automatically run this macro when you open your Access database.

To learn more about Microsoft Access macros, techniques, and principles and apply good methodologies, take a look at me latest eBook on Understanding & Using Microsoft Access Macros (covering all versions).

Microsoft Access Macros – New eBook Is Here!!

Microsoft Access Macros – New eBook Is Here!!

STOP THE PRESS!! My new eBook is now available!

access macros ebook coverTake a look at the following link: Understanding & Using Microsoft Access Macros. It’s the first dedicated reference to just Access macros and no talking about VBA (Visual Basic for Applications) which most books couple together.

It covers versions from 2000 through to 2010 which has some very interesting and new powerful features. Beginner or not, there is something for everyone and Microsoft now encourages developers to use Access macros as the first choice option to automate your database.

Microsoft Access Macros – New eBook Is Here!!

It comes with a 100% money back guarantee – no questions asked and I think this is great value too! How much would a two day training course cost you to attend?

The beauty of considering this eBook is that I’m at the end of a website (here) to contact me if you need further advice, clarification or ask a question.

Microsoft Access macros is now very powerful and easy to learn with my new eBook; Understanding & Using Microsoft Access Macros.

Microsoft Access 2010 Table: USysApplication Log Table New To Microsoft Access

Microsoft Access 2010 Table: USysApplication Log Table New To Microsoft Access

The USysApplication (log) table is a new feature of the Microsoft Access 2010 table object collection and is utilised with the new feature also introduced to this version called Access data macros.

There are five event driven macros that is bound to an Access table that can trigger a macro automatically. However, if there is an error, the system populates a record to the USysApplication table which is a system table keeping Continue reading “Microsoft Access 2010 Table: USysApplication Log Table New To Microsoft Access”

Microsoft Access To Excel VBA – Automating Between MS Office Applications

Microsoft Access To Excel VBA – Automating Between MS Office Applications

The power of Microsoft Access to Excel VBA is revealed here in this quick two and half minute video demonstration of how popular Microsoft Office applications are & can communicate when using Access VBA (Visual Basic for Application code)

httpv://www.youtube.com/watch?v=pHqssAZr3eI&feature=related

Microsoft Access To Excel VBA – Automating Between MS Office Applications

Now you’ve seen it done – how does it work? Using Access to Excel VBA requires some foundation VBA code knowledge and may say they are not programmers – well that’s good news!access to excel vbaBeing a programmer can hinder your approach and taking simple principles that I teach you will give you the tools and knowledge to build and automate not only Access databases but send data to and from other Office applications (i.e. MS Excel).

To start with, review some of the basics and then talk to me and see if we can work on structured coaching programme for you and focus on the real specifics that you only want to know. Give a me a call.

Microsoft Access Database: Data Types In Access – Currency Versus Number

Microsoft Access Database: Data Types In Access – Currency Versus Number

Building an Access database normally starts with tables and getting the right data types in Access early on will save a lot of headaches later when calculation and referring to numeric values elsewhere.

Currency and Number data types are different to each other and the flexibility, scope and application use will help you to make to right choice. Here’s a quick checklist: Continue reading “Microsoft Access Database: Data Types In Access – Currency Versus Number”