Designing A Multi-Table Query – Part 3

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

Creating A Multi-Table Query

Since we have planned our question, we are prepared to design and run it. If you have made written plans for your query, make certain to reference them frequently all through the ms access query design process.

These are the steps in creating a multi-table query:

1. Choose the Query Design from the Create tab on the Ribbon.image12. In the Show Table dialog box that shows, choose each table you want to include in your query, then click Add. After adding the tables, click Close. In our example, we needed information from the Customers and Orders table, so we’ll add them. Continue reading “Designing A Multi-Table Query – Part 3”

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”

Building Access Forms – Thе Design Concept

create_a_form_in_Microsoft_access access database tutorialUѕіng MS Access forms tо display records іn а fаr easier layout аnd format wіll give user’s thе confidence аnd thе protection of controlling data processing tasks.

MS Access forms аllоwѕ thе uѕе оf data tо bе presented, managed аnd controlled іn а user-friendly environment making Access mоrе intuitive tо use.

Designing forms іѕ critical fоr оthеr users whо wіll bе responsible fоr thе day-to-day running оf а database аnd hаvе vеrу lіttlе knowledge оf thе structure оf аn Access database оr іtѕ background processes. Continue reading “Building Access Forms – Thе Design Concept”

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”

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”

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.

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 2016 Database – New eBook Arriving Soon

Microsoft Access 2016 Database – New eBook Arriving Soon

Since the release of Microsoft Access 2016 Database eBook late last year, everyone has been busy re-writing and documenting the changes to MS Access and in essence, there’s little difference when comparing it to the previous version (2013).

However, to help freshen up and bring any newer features into the fold, I too have been busy re-writing my current eBooks which were originally written and supported for most versions ranging as far back as version 2000 (through to 2010).

microsoft-access-2016-database-new-ebook-arriving-soon

As usual, you can expect all the key and Continue reading “Microsoft Access 2016 Database – New eBook Arriving Soon”

Microsoft Access 2016 Macros: Show All Macro Commands

Microsoft Access 2016 Macros: Show All Macro Commands

The great debate of whether to use Microsoft Access macros or the higher level of VBA code will linger on until the end of time (or realistically, Access is discontinued)!

In the meantime, most Access developers will continue to lean towards Access VBA but the majority of power users, self-taught Access designers will still embrace the ease of g using macros to automate their databases.

Microsoft Access 2016 Macros Show All Macro Commands

With the later versions of MS Access (post 2010), macros have become more powerful and flexible and with the added introduction of better web integration and the fact VBA Continue reading “Microsoft Access 2016 Macros: Show All Macro Commands”