Welcome to Microsoft Access Database Tutorial

Welcome to the Access Database Tutorial website that will show you how to use Microsoft Access Database by learning and managing this powerful application using the most effective techniques and tools available for visitors with very little or no knowledge to get you up and running without the need to learn all the ‘geek’ speak keeping it Jargon free that most trainers and consultants like to impress you with!

If you are new to Access or wish to know what is MS Access, please take a look at An Introduction To Microsoft Access.

Also, this website contains a blog, products on offer and free general tips to help users find out all about  latest news and articles I feel worth mentioning along with my recommendations of videos and books.

As a Thank You for Visiting…

Claim Your Free eBook NOW!

Enjoy and thank you for visiting!

How to Creating an embedded macro

image13An embedded macro is a macro that is not displayed in the Navigation Pane under Macros; it is stored in the event properties of forms, reports, or controls. This can make your database easier to manage because you don’t need to monitor separate macro objects that contain macros for a form or a report. To create an embedded macro, follow the steps below:

  1. Open the form or report that will contain the macro in Design view or Layout view. To open a form or report, right-click it in the Navigation Pane, and then click Design View or Layout View.image7
  2. If the property sheet is not yet displayed, press F4 to display it. Continue reading “How to Creating an embedded macro”

Creating a standalone macro

Introduction to Macros – Part 2image2

A standalone macro is a macro that is displayed under the Macro in the Navigation Pane.

To create a standalone macro, take the following steps:

  1. Click the Create
  2. Click Macro in the Macros & Code
  3. You should be able to see the Macro Designer by now. To add an action, type in the macro action or click on the drop-down menu to display the list from which you choose the action that you want to use.
  4. To add more actions to the macro, move to another action row, and then repeat the previous step. Access carries out the actions in the order in which you list them.
  5. Click Save when your done.

Creating a macro group

Create a macro group for several related macros.

  1. Click the Create
  2. Click Macro in the Macros & Code
  3. Once the designer is displayed, select Group from the drop-down list. Continue reading “Creating a standalone macro”

What is the new Macro Features from the release of Access 2010

image2

In previous versions of Access, many usually used functions could not be executed without writing VBA code. With the release of Access 2010, new features and macro actions have been added to help remove the need for code. This makes it less demanding to add functionality to your database and helps make it more secure.

  • Embedded macros: You can now embed macros in any of the events given by a form, report, or control. An embedded macro is not displayed in the Navigation Pane; it becomes part of the form, report, or control in which it was created. If you make a duplicate of a form, report, or control that has embedded macros, the macros are also present in the duplicate.

Continue reading “What is the new Macro Features from the release of Access 2010”

What is a macro?

image1

In this article, you will learn all about macros — what they are and how they automate tasks for users to save time. It examines the essentials of making and using macros.

A macro is a tool that lets you automate tasks and integrate functionality into your forms, reports, and controls. For instance, if you incorporate a command button to a form, you link the button’s OnClick event to a macro. The macro will have the commands that you want the button to perform every time it is ticked.

In Access, it is useful to consider macros as a simplified programming language that you compose by building a list of actions to perform. When you create a macro, you choose every action from a drop-down list then fill in the needed information for every action. Macros allow you to add functionality to forms, reports, and controls without writing code in a Visual Basic for Applications (VBA) module. Macros give a subset of the commands that are accessible in VBA, and most people find it simpler to construct a macro than to write VBA code. Continue reading “What is a macro?”

Create a Report in Microsoft Access 2016 – Part 2

As a reminder, Please review Create a Report in Microsoft Access 2016 –Part 1

Report Design

Reports can be designed and formatted in the same way as we do with forms. When you create a report, four new tabs show up in the Ribbon particularly for working with reports.image12

Report Header and Footer

The report header and footer are shown just once in the report.

The report header is shown at the topmost part of the first page, and the report footer is shown at the lowest portion on the last page.

In the example above, the colour name will only be shown once — at the top of the first page of the report.

Page Header and Footer

The page header and footer are shown on every single page of the report. If for example, a report has 10 pages, the page header and page footer will be shown on all 10 pages. Continue reading “Create a Report in Microsoft Access 2016 – Part 2”

Create a Report in Microsoft Access 2016 – Part 1

image2Access has quite a few processes for generating reports. Any user can create a report quickly in Access, whether they’re a beginner or an expert.

With MS Access 2016, you can create a report from a table or query with the click of a button. You may also make use of the Report Wizard to guide you through the method. Similarly, more experienced users can begin with a blank report and build it exactly as they want.

Create a Report based on a Query

We will make a report in view of the query we created earlier — Women’s Tops.

This query will require user input which would tell the query the colour they would like to find from the Women’s Tops list. However, the query does not show the cloth colour in the output, so we will need to show this parameter on the report as well. If not, the reader would not know the colour of the garment. Continue reading “Create a Report in Microsoft Access 2016 – Part 1”

Microsoft Access Database Forms – Part 2

As a reminder, please review Microsoft Access Database Forms – Part 1

Formattingaccessdatabasetutorial 11

The Form Layout Tools tab contains the form customisation fields. Selecting it will display a screen like an image above. Now, feel free to play around with some of the settings to learn their role in form design and the stylish choices available to you. You may also visit the Home tab and find the View drop-down option where you can cycle through the form view options available.accessdatabasetutorial 12

Form Wizard Makes Form Creation Uncomplicated

Understanding the societal desires of people in order to constantly boost efficiency, Microsoft has incorporated a fairly helpful Form Wizard to enable the skipping of the grubby, hands-on detail Continue reading “Microsoft Access Database Forms – Part 2”

Microsoft Access Database Forms – Part 1

accessdatabasetutorial 7Access Forms can make data entry tasks handy for database users. Make an easy to understand database environment without uncovering the inner-workings of a database and give yourself peace of mind that your data is protected.

This instructional exercise will cover the MS Access Form creation, modification, design control and form properties to give you control over your database design.

In this tutorial, we will make use of the open-source US Senators Contact Information Sheet. Download the file and unzip it to a folder on your computer. Continue reading “Microsoft Access Database Forms – Part 1”

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 Query in Access 2017 – Part 1

image2The true strength of a relational database lies in its capability to instantaneously fetch and analyse your data by running a query. Queries enable you to pull data from one or multiple tables based on a set of search conditions you define.

This tutorial will teach you how to make a basic one-table query. Then you will figure out how to plan and run a slightly complex multi-table query.

What are ms access query ?

Queries are a method to search for and compile data from one or multiple tables. Running a query is like asking a detailed enquiry of your database. When you build a ms access query, you are defining particular search conditions to get exactly the data you need. Continue reading “Designing A Query in Access 2017 – Part 1”