Calculated Values in Microsoft Access Forms or Reports Video Tutorial

A quick video tutorial showing how to carry out basic calculations in a form though it can be applied to a report too.

It demonstrates using the Expression Builder tool which is useful for picking and choosing functions, setting operators and locating other objects from other forms, report, queries and tables.

A new look in Microsoft Access 2010 is the Expression Builder tool and has essentially the same functionality as the old one. Also, you can now even store a calculated field into a table for the first time.

Finally, if your are going to calculate in a query, you do not start with the ‘=’ sign as demonstrated with a form (and for a report).

Learn About Subqueries in Access Courses

An understanding of queries is critical to database management. Without Access queries, you can’t get at the information and the data is useless.

Once you master queries, a subquery is a powerful tool that greatly expands your abilities to get exactly the data you need. To unleash the real power of a subquery, you need to become familiar with SQL (pronounced “sequel”), the language of database queries. This type of knowledge, usually taught in advanced level Access courses and can make your database exponentially more powerful. Continue reading “Learn About Subqueries in Access Courses”

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 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”