The power of MS access query

MS access queryThe real power of a relational access database is its ability to swiftly retrieve and analyse any data by running it as a query.

Queries have the ability to pull information from tables based on a set of search conditions that is being defined. Queries are ways of searching and compiling data from tables. MS access queries are more powerful than simple searches or filters used to find data in a table. When you build a MS access query in an access database, it means you are defining specific search conditions to find exactly the data you need.

Continue reading “The power of MS access query”

What is the function of primary key when creating a database in access

create_a_database MS accessWhen building an access database, the primary key is important and an important thing to note when creating a database in access. Before continuing you should know what primary keys mean.

What is a primary key

Primary keys are fields or fields with values that are unique throughout a table when building an access database. Primary keys can be used to refer to entire records, each record has a different value for the key. A table can only contain just one primary key. Ms Access will either automatically create a primary key field for you when Continue reading “What is the function of primary key when creating a database in access”

Creating a good looking Ms access forms with Microsoft access

MS Access FormsThere are several factors you need to consider when creating a ms access forms, knowing that designing a form is an important component of the user interface when working with ms access forms.

Since it is the way human beings interact with a computer.Also, note that while designing a form in Microsoft access  might seems easy to create, the concept of the user interface design should not be left out when creating forms in access . User interface design is a science that design compile various factors, that enable ease of use and understand ability all into one package easy to use look and feel which is the design. Continue reading “Creating a good looking Ms access forms with Microsoft access”

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”