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”

Microsoft Access VBA vs MACRO

Microsoft Access VBA vs MACROA common question often asked: Would it be a good idea for me to use Microsoft access macros or would it be advisable to use Microsoft Access VBA code instead?

You should base your choice to use either Microsoft access macros or MS access VBA code with two initial concerns:

  • Security
  • Usefulness that you require.

Macros are considered to be easier to learn than VBA and in most cases it’s probably faster  to create a macro than it is to write VBA code. Continue reading “Microsoft Access VBA vs MACRO”

Time-saving tips when MS Access database

Time-saving tips when MS Access database

Timing is very important in everything we do in life, in this post you will find out tricks to easily optimize your speed when working with MS Access database, this tips will also help you manage the time while creating access database.

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”

Microsoft Access 2016 Will Soon Support Large Number (BigInt) Data Type

Microsoft Access 2016 Will Soon Support Large Number (BigInt) Data Type.

Coming soon… Microsoft Access 2016  will gain a new data type called ‘Large Number‘ which will be an extension to the Number at a type or more commonly referred as BigInt (Big Integer).

Large Number (or BigInt) is a new supported data type that will help developers and users with added analytical capability. This extended support means that Access can finally read and write data to and from external data sources which make also makes use of BigInt.

microsoft-access-2016-will-soon-support-large-number-bigint-data-type

This has been a limitation when importing data into an Access database from larger more robust database applications and this feature will be able to switched on or off (I guess to help keep the application optimized and not slow down too much). Continue reading “Microsoft Access 2016 Will Soon Support Large Number (BigInt) Data Type”

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”

Welcome To My Rebuilt Microsoft Access Database Website

Welcome To My Rebuilt and New Look and Feel Microsoft Access Database Website

A new year and a new look and feel website for you 🙂

So, if you haven’t visited us before, we are Access database tutorial – a blog website all about Microsoft Access database.

microsoft-access-database-eproducts

Take a look, browse our blog articles since 2010 and consider some of our unique and exclusive offers and ebooks.

Very easy to follow eBooks and rebuilt eProduct tools to plug into your own Access database with 30 day email support and a money back guarantee (if not satisfied).

Microsoft Access: Office 365 Business Subscription Plans To Be included

Microsoft Access: Office 365 Business Subscription Plans To Be included

Microsoft plans to add Microsoft Access database to its Office 365 Business and Office 365 Business Premium subscription plans.

The above plans currently do not provide this all powerful Access application but from the 1st of December until the end of January 2017 will get this automatically updated to their accounts.

microsoft-access-office-365-business-subscription-plans-to-be-included

Microsoft Access: Office 365 Business Subscription Plans To Be included

Be aware, if an organisation subscribing to either of those two plans has elected to get Office 365 updates via the “deferred channel” update process, then Microsoft Access will start to arrive in June 2017. The Office 365 updates so-called “channels,” arrive every four months are called the “deferred channel.” Therefore, “first release for deferred channel” update release arrives every four months and is designed for testing purposes. Continue reading “Microsoft Access: Office 365 Business Subscription Plans To Be included”