MS Access - Macros or OR Function

VBA Set Column Width or Row Height

MS Access - Macros or OR Function

Microsoft Accesss

Microsoft Access, on the other hand, is made to store and manage vast quantities of data in a form that makes it easy to retrieve and use in different applications. While Excel user’s type directly into their spreadsheets, Access databases are manipulated with pre-made forms and queries. Most businesses also connect Access to other applications, so when those other apps generate data, it is automatically ported over to Access.

How Microsoft Access is used

Tables: Access stores its data in tables. You can build a single database that includes all the data for the entire project — this is often called a "flat" database.

elational databases: It's almost always easier, though, to create many tables, each containing elements of the data that needs to be tracked for a project (for example, a business might maintain separate tables for product data, orders, clients, and shipping information). Each of the tables can be interrelated and connected to one another — this is called a relational database, which allows developers to create many relatively simple databases and relate them to each other.

Queries: Queries are another common element in Access databases. The program supports sophisticated queries to find information in the database, which can be important when the database may contain thousands of entries.

Forms: Database developers often create forms that allow users to enter information into the database without using a spreadsheet. By avoiding the need to enter data in a spreadsheet-like table, there's much less chance for data entry error.

Reports: Access allows users to create custom reports quickly and easily. A Report Wizard makes it easy to sort, group, and label data for easy printing and sharing.

A Macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls.

-Macros in Access work a bit different from Macros in Word or Excel, where you essentially record a series of keystrokes and play them back later.

-Access Macros are built from a set of predefined actions, allowing you to automate common tasks, and add functionality to controls or objects.

-Macros can be standalone objects viewable from the Navigation pane, or embedded directly into a Form or Report. Once you have created database objects like tables, forms and reports, Macros can provide a quick and easy way to tie all those objects together to create a simple database application that anyone can use or even modify, with relatively little training

-Macros provide a way to run commands without the need to write or even know VBA code, and there is a lot that you could achieve just with Macros.

Creating a Macro

Let us start be creating a very simple Macro that opens a Table when a command button is clicked.
For this, we need to open your Access and Table Staff.
Then Click Menu Table -> Choose -> Before Change then

In this Macro, we can add a button allowing Staff on Condition.

we Choose

IF [Position]=”IT Manager” or [Position]=”IT Staff” then
SelField
Name Bounu
Value 40
Else IF [Position]=”Seller” then
SelField
Name Bounu
Value 10
Else SelField
Name Bounu
Value 10
End IF

This MS Access tutorial explains how to use the Access Or function with syntax
Description
The Microsoft Access OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.
Syntax The syntax for the or function in MS Access is:
=> Please watching My Watching My is Below