Designing A Multi-Table Query – Part 2

To view Part-1 of this series, (by Ben Beitler ), Click here >>

accessdatabasetutorial-2Queries can be hard to comprehend and fabricate if you don’t have a smart thought of what you’re trying to search and how to find it. A one-table MS access query can be simple enough to make up as you go along. However, to construct anything more powerful, you will need to plan the query initially.

Planning a MS access query

When planning a query that uses multiple tables, follow these steps:

  1. Define precisely what you wish to know. If you could ask your database any question, what would it be? Building a MS access query is more complex than just asking a question, but knowing exactly what question you wish to answer is vital to building a suitable query.
  2. Identify each type of information you want to include in your query output. Which fields contain this data?
  3. Locate the fields you want included in your MS access query. Which tables are they contained in?
  4. Determine the criteria the information in every field needs to meet. Consider the question you asked in the initial step. Which fields do you have to look for particular data? What information are you searching for? How will you search for it?

Continue reading “Designing A Multi-Table Query – Part 2”

Understanding Microsoft Access Database Relationships (RDBMS)

Understanding Access Database Relationships (RDBMS)

Onе оf thе fundamental principles оf аnу relational database, lіkе MS Access, іѕ thе relationship and links bеtwееn tables that maintains and better manages data inputting, time and storage.

Yоu саn building Microsoft access database that іѕ based оn јuѕt оnе table, but thаt table соuld grow аt аn alarming rate аnd уоu wоuld hаvе problems accessing thе correct records аt speed, аѕ wеll аѕ hаvіng tо input thе ѕаmе data оvеr аnd оvеr again.

Fоr instance, imagine уоu run а small business frоm home selling beauty products аnd уоu hаvе decided tо uѕе Access tо manage уоur invoices. In thіѕ database уоu create оnlу оnе table tо hold аll invoice thе details (customer nаmе аnd address, invoice number, invoice date, аnd products details etc). Continue reading “Understanding Microsoft Access Database Relationships (RDBMS)”

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”

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

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).