Explore Access on Experts Exchange

Expert Solutions for Your Tech Problems

AccessMicrosoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications,...

Read more
  • 226K Content
  • 16K Contributors

Expert Spotlight
Jim Dettman (EE MVE)
Volunteer

Independent consultant specializing in the writing of custom packages for businesses.

Article

Working with Recordset Clones in Microsoft Access

byRichard Rost (Microsoft MVP)
A Recordset Clone in Access is a second pointer to the data behind a form. It lets you search, count, loop, and update records silently without moving the form's cursor. Faster, cleaner, and more reliable than UI-driven methods like GoToControl or FindRecord.
Article

Comparing Service Accounts in MS Entra ID

byGeorge Grammatikos
Identity management is vital for organizations, and Microsoft Entra ID (formerly Azure Active Directory) is key for managing access to services and resources. Service Accounts, used by applications for authentication, enable automated tasks without manual intervention.
Article
AzFunction-VNetIntegration<wbr />

Securing Azure Functions with VNet Integration

byGeorge Grammatikos
This post explores the importance of an Azure function VNet integration to secure the function and provides a quick step-by-step guide to making a function secure using this approach.
Article

5 Ways to Log In and Manage Azure

byArnav Sharma
Depending on your demand, Azure, Microsoft's cloud platform, provides several ways to log in and handle resources.
Article

The important of cyber security.

byNwizi Odinaka Stanley
1
Cybersecurity protects networks and data from unauthorized access and threats like malware, phishing, and ransomware. Key concepts include the CIA triad (confidentiality, integrity, availability) and risk assessment. Best practices involve employee training, strong password policies, software update
Article

Creating a custom Welcome form in Excel

byThomas Zucker-Scharff
Not too long ago I wrote this article on doing the same thing in MS Access (https://www.experts-exchange.com/articles/38421/Making-your-Database-More-User-Friendly.html). I found that a similar "Welcome" screen makes Excel worksheets "friendlier" as well.
Article

Making your Database More User Friendly

byThomas Zucker-Scharff
I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use. Here is how I added one to a Microsoft Access database. Please see the important note at the bottom of this article regarding compatibility on operating systems other than Window
Article

The Power Query Editor

byThomas Zucker-Scharff
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html). I have realized that my coworkers primarily use Excel and So have changed the article to include excel. The result is below and is
Article

Change The Specific Printer of Access Reports Via VBA

byDale Fye
If you want to save changes made programmatically to a reports Printer property do not use this syntax: docmd.close acReport, Reportname, acSaveYes
Article

Some database design ideas

byThomas Zucker-Scharff
I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user. I would like to think this is a "lessons-learned" synopsis.
Article

Encryption in VBA using the Microsoft NG Cryptography (CNG) API

byGustav Brock
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Encryption.
Article

Hashing in VBA using the Microsoft NG Cryptography (CNG) API

byGustav Brock
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Hashing.
Article

Storing encrypted data in Microsoft Access

byGustav Brock
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Storing hashed or encrypted data.
Article

Storing passwords in VBA using the Microsoft NG Cryptography (CNG) API

byGustav Brock
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Handling passwords.
Article

Utilise Microsoft's Next Generation Cryptography (CNG) API in VBA

byGustav Brock
2
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Compatible with other environments.
Article

Creating a customized Access ribbon and Network Database

byThomas Zucker-Scharff
I wrote this article because I was unable to find an article on this here on EE. Read on for step-by-step instructions on how to create a custom command ribbon in your office applications that not only make them look more professional but also protects against the ID10T error.
Article

Callback functions in Microsoft Access VBA. Part 3

byGustav Brock
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to share one callback function between multiple controls.
Article

Callback functions in Microsoft Access VBA. Part 2

byGustav Brock
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to reconfigure a callback function.
Article

Callback functions in Microsoft Access VBA. Part 1

byGustav Brock
1
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.
Article

Revitalise colours in the VB editor

byGustav Brock
The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more