Make Microsoft Access Open Up Excel with VBA – Video Tutorial

This is for the more advanced Access user/developer but hey! new users who have some understanding or experience with VBA in other applications (and I’m really suggesting Excel VBA) then this may be of interest to you too.

This is why this video tutorial talks about Access and Excel with VBA which is a common code requirement and is clearly explained here not leaving anything to the imagination trying to guess what happened next.

Just remember the author demonstrates by running and stepping line by line through the code using the F8 function key which allows you to observe at your own speed what each line of code actually excutes.

If you are serious about VBA, you will need some reference guide and/or book. Maybe a training session? Let me know – Contact Me

3 Useful Things You’ll Learn in Microsoft Access Training Courses

Most people say that they feel intimidated by MS Access. Training courses designed for rapid learning however, can get you feeling confident in just a matter of days. There are any number of reasons why you or your employees could benefit from taking enter site Access training; from improving efficiency, to seeing data in new ways, to building better relationships with your customers through superior tracking of customer inquiries and orders.

Most people know that Access is a database program, but since many people haven’t explored it in detail, they aren’t sure what they might learn in MS Access training. Here are 3 interesting and useful things you’ll learn after just two or three days of Access courses that could drastically change the way your business operates. Continue reading “3 Useful Things You’ll Learn in Microsoft Access Training Courses”

Microsoft Office Access 2007 & Microsoft Office Excel 2007 – Which one to use?

A quick and useful video demonstration highlighting the pros and cons between the popular Microsoft Office applications.

As newer versions are released (the latest being Microsoft Office 2010), so the functionality becomes richer and the closer applications become making it even harder to decide which one to choose. Luckily, Microsoft Office (Professional) has both Excel and Access, the only problem now is to understand the key differences.

It’s natural to lean towards Microsoft Excel – why? Well, everyone starts here before migrating to the more powerful Microsoft Access database application but many more simply stay put – in the comfort zone!

This video demo is a good start to help differentiate the two – well worth two and half minutes of your time!

Converting a Microsoft Access Database File to a MDE File or ACCDE File

Microsoft Access database applications are normally planned, designed and built using the standard single file format in either .MDB or the newer .ACCDB (Access 2007/2010) and then distributed with all the objects (Tables, Queries, Forms, Reports, Macros and Modules -VBA code) fully accessible with the standard default settings applied.

To help lock down and prevent certain objects especially Forms, Reports and any code being modified (via the design mode), you can convert your database file into an ‘executable‘ file format where the .MDB becomes a copy as an .MDE and the .ACCDB to a .ACCDE.

This will protect and seal the database file which is better than deploying just the open file format into either an Access runtime or the full version of Access still allowing users to be able to utilise, store and process data as well as run the other objects as normal.

Continue reading “Converting a Microsoft Access Database File to a MDE File or ACCDE File”

Using Microsoft Access To Organise Your Life

A useful introduction video showing the ‘back-end’ tools namely Tables and Queries being designed and used. It’s only the start though and you will need to do some more research.

I like this video because it’s not been scripted or rehearsed showing how we all think when creating a table and a query with the author making decisions on the go applying changes during his presentation – great!

If you want help, please contact me for advice and how you and I can work together getting you up to speed quickly.

When to Use Microsoft Access database, When to Use Microsoft Excel

Building Your First Database with Microsoft Access 3Tea or coffee? Shoes or trainers? Access or Excel? Life is full of different options but most of the time the decision comes down to practical requirements. If you need a shot of energy to get you through the day then you’ll be better off with a big mug of coffee. Likewise if you have an important business meeting scheduled it is probably best to stick to more formal footwear.

But say that you have a volume of information that needs assimilating and analysing within a functional, logical framework. Both Excel and Microsoft access database can fulfill the role superficially but there are crucial differences between a spreadsheet and a database that can radically affect the processing of data.

Microsoft Excel’s spreadsheets are non-relational, which means that the data that is formulated in them can only relate to itself. For example, a list that groups together employees with their particular salaries can be manipulated into various formats (alphabetical order, highest earning to lowest etc.) but it can only do that based on the data that is present in the list. As such its purpose is useful but limited.

Continue reading “When to Use Microsoft Access database, When to Use Microsoft Excel”

Sharepoint 2010 and Access 2010 Tutorial

A very quick overview of how to share an Access databases (2010) over the internet using SharePoint 2010 services, the new way to publish Access database files on the web.

It really is that simple as the steps shown in this video tutorial and you will soon learn the do’s and don’ts when the system always analyses the objects from your Access databases file.

Make sure you do some more research first and know what your options are before you just start sending objects for publishing onto the internet.

Click on this link to find out more about Access database on the web

Practice Microsoft Access Database Decorum to Reap the Rewards

microsoft-access-database-4-reasons-why-it-is-good-for-your-businessBefore you enthusiastically enter all your information into a Microsoft Access database it is wise to apply some organisation to the process.

As you open the application you will see that the programme can hold vast amounts of data that can boost the efficiency of your business. The software is commonly found in offices and businesses which are seeking to keep on top of paperwork and many other tasks that require analysis and storing of data. Unlike MS Excel, you have great freedom with Microsoft Access database as there is much more that you can do with the program.

For instance, it allows you to create databases that can be linked to each other, which are more complex than Excel spreadsheets. Within these databases are different ‘objects’ that you can utilise if you wish. The types of objects you choose to apply often depend on your knowledge of the program, meaning you are free to avoid using them until you feel ready and have attended training courses if necessary.

Continue reading “Practice Microsoft Access Database Decorum to Reap the Rewards”

Access database 2007 Reports Tutorial

It always amazes me when users and developers design an Access database they pay a lot of attention to the designing and planning of the database structures – and of course this is very important.

The next step is usually building the objects starting with the Tables then Queries followed by the Forms and finally the Reports.

By the time they are onto the Reports, it seems a bit of an after thought and the designs are very basic because of the the time consuming element reports can take. It is important to spend time in the design view of an access database report which is as I say is overlooked a lot of the time.

This video tutorial is a good introduction as it covers the report wizard tool which everyone starts with (and a lot of the time that’s it!) followed by the switching between the different views showing you how to add groups, calculate and change the various key properties for a report. It even explains the footer calculation for pages and concatenation (look the word up!).

At the end of the day, if you are going to present the results to your customers or executives, you need good looking Access database reports and the report wizard tool will simply not do!

Learn About the Benefits of a Split Access Database

accessdatabasetutorial.comMicrosoft Access database is a wonderfully simple application and can scale easily from just a few users for a small business to many users for a large organization. One can enhance the flexibility and scalability of Microsoft Access by splitting the database so that it performs better and provides better security to data.

What makes an Microsoft Access database so easy to handle and use is the fact that it uses just one MDB file to store both the data and the interface objects. However, this could also lead to some problems, particularly if you are planning on having a shared database. When you are sharing the MDB file containing both data and interface objects with multiple users, there is a greater chance of the file getting corrupted. This means that even if all the users are typically using the interface objects, there could be damage to the data and in some cases, this could result in loss of data. Instead of having to constantly repair MDB files that have become damaged due to these reasons, it is much better to work with a split database. Most experts will tell you that not only is a split Microsoft Access database with two MDB files much easier to protect, but performs faster and is also easier to maintain.

Continue reading “Learn About the Benefits of a Split Access Database”