Building Your First Access Database with Microsoft- Part-1

Building Your First Database with Microsoft Access 3If you possess a version of Microsoft Office that incorporates Access (Office Professional 2016 is the latest version), yet you have never used it, you are neglecting an effective tool for organizing and analysing business data.

Working with simple lists does not require you to use Access database— you can do it with Excel. Microsoft Excel is a spreadsheet which offers fundamental tools for such tasks as sorting, filtering, and computing values. If you are working with complex data, Microsoft access database is the software to use. Even though you could store complex data in list form in Excel, doing so normally brings about a considerable measure of data duplication and the danger of data-entry errors. Furthermore, storing data in list form requires you to have special Excel tools like pivot tables, so you can analyse and view the data in a useful approach. That is not the situation with Access.use Pivot TablesContinue reading “Building Your First Access Database with Microsoft- Part-1”

Working with ms access tables

create a table in microsoft access

Like in other database application tables are the building block of any ms access database. These tips will be on how to create ms access tables and enter data in the database that is stored in your tables. Tables are the only place you can store data in ms access databases.

What is a table in ms access?

The table is set of columns and rows. Columns in ms access tables are called fields. When working with a table, every field should be giving a specific name and two fields cannot have the same name. Every single value in the field represents a single category of data. Also, note that every row in ms access table are called rows Continue reading “Working with ms access tables”

4 Reasons Why It Is Good For Your Business- Microsoft Access Database

4 Reasons Why It Is Good For Your Business.

Here’s an article recently published about Microsoft Access databases called 4 Reasons Why MS Access Is Good For Your Business which highlights the key reasons well.

The four bullet point reasons from the article are:

  • You Probably Already Have A Copy Of It
  • It’s Fully Integrated With Other Office Apps 
  • It’s Highly Versatile & Constantly Improving
  • It’s Scalable For Future Expansion

microsoft-access-database-4-reasons-why-it-is-good-for-your-business

Also take a look at an older article of mine expanding on the benefits of Microsoft access making it a perfect match for SME’s and individuals.

Ready for more help? Take a look at Microsoft Access 2016 Database eBook and see how easy it is to build MS Access Databases. 🙂

Microsoft Access News: Updating the Access Services in SharePoint Roadmap

Microsoft Access News: Updating the Access Services in SharePoint Road map

If you have been using Microsoft Access Services (in SharePoint), be aware of the latest news last week of this being dropped.

microsoft-access-news-updating-the-access-services-in-sharepoint-roadmap

Not to surprised! Microsoft Access is a desktop power application tool which works very well with VBA (Visual Basic for Applications).

A web version always had its limitations and it seems now perhaps there was never a large enough take up of developers when Continue reading “Microsoft Access News: Updating the Access Services in SharePoint Roadmap”

Using Table and Query Naming Conventions : Microsoft Access Database

MS Access Database: Using Table and Query Naming Conventions.

As part of the good working practices and disciplines when designing your Microsoft Access database, using good naming conventions will be essential as not all parts of the Microsoft Access application is consistent.

Take a look at this quick video tutorial (about two and half minutes)…

As clearly explained, not all aspects of the MS Access application provides a way to easily see what type of object you Continue reading “Using Table and Query Naming Conventions : Microsoft Access Database”

Microsoft Access Database Working On A Mac O/S

Microsoft Access Database Working On A Mac O/S

Don’t shoot the messenger but you can use Microsoft Access database on a Mac O/S – well with some software intervention that is!

The say things happen in three! Over the holiday period and starting the new year, I had to deal with my website hosting and domain provider shutting down forcing a change of all services (hence my new look and feel website), my broadband behaving even more erratically forcing me to upgrade to a super-fast alternative and finally my Windows 7 Pro laptop collapsing having spent all of last weekend trying to rebuild it.

Well, I had a choice – update and purchase a new laptop or consider working solely with my ever faithful Mac Book Pro (Sorry, Microsoft but I’m a Mac man now!).

microsoft access database vmware on a mac

Having decided on the latter, I needed a simple and Continue reading “Microsoft Access Database Working On A Mac O/S”

Building Access Databases -Using Data Analysis Tools

Building Access Databases- Using Data Analysis Tools

Here’s a quick one minute video demonstration on the main Microsoft Access database tools available for your reference.

This video tutorial is based on Access 2013 but it applies to all versions (albeit maybe found in other parts of the application).

As you can see, these tools look a little tired and old style Windows which Continue reading “Building Access Databases -Using Data Analysis Tools”

What Are The New Features In Microsoft Access 2016

What Are The New Features In Microsoft Access 2016

Here’s a quick less than three minute video on what’s new with Microsoft Access 2016 to quickly discover if it’s actually worth the upgrade!

As the video informs us, there seems to be little difference between the previous version (2013) and not convincing us it’s worth the effort or even an additional Continue reading “What Are The New Features In Microsoft Access 2016”

Microsoft Access Database Blog – Six Years On

Microsoft Access Database Blog – Six Years On

Wow! It’s been nearly six years of providing you with MS Access database blogs and I wanted to say a big thank you to all you, the subscribers and of course those who entrusted me by purchasing one of my e-products and e-books.

If this is your first visit to my blog then welcome 🙂 Take a look at this blog site and browse the history by selecting the Archive ‘drop-down’ box by month.

microsoft-access-database-blog-site

There are over 300 posts and several ways to navigate through the archives by clicking a category, selecting a month or using the recent posts feature.

MS Access Database Blog – Six Years On

Remember, to sign up for your free weekly tips and e-book. 

If you want to know more detail or like some of my e-product utilities, why not take a chance and purchase them? In fact, there’s no risk at all as I provide a full money back guarantee plus a 30-day email support to help you through the learning curve (which is not really too steep!).

Once again, a big thank you to all for visiting my MS Access database blog 🙂

Should We Be Using Calculated Table Fields-Microsoft Access Database

Microsoft Access Database: Should We Be Using Calculated Table Fields

With the introduction of Microsoft Access 2010, a new data type field appeared in your table design view which provided a basic way to take fields in the same table and create new expressions as a new dedicated field sitting at the ‘top of hierarchy’ database!

However, should we really be using this new data type and practice at all?

microsoft-access-database-should-we-be-using-calculated-table-fields

Purists will frown upon this technique and say you should stick with Excel to store real values and expressions together. By doing so, you are breaking the rules of database normalisation and also cause a maintenance headache once your database has been deployed.

There are some considerations to think about that may Continue reading “Should We Be Using Calculated Table Fields-Microsoft Access Database”