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
M365 Apps & Services MVP | Windows Insider MVP | MCT | Author | eJPTv2 | eCPPTv2 | CRTP | CRTE | CRTO | Security+ | CEH | Pentest+

Experienced Messaging Specialist with a demonstrated history of working in the information technology and services industry.

Troubleshooting Solution

Match part of entry in a query

bybfuchs
39

Hi Experts,

I have two files containing upc's, one file has only one upc per item and the other file

Article

"Domain Aggregate" for Concatenating Values by Group in Microsoft Access

27
by Patrick G. Matthews


A common request in the various …
Video
Post

The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Troubleshooting Solution

access database has debug issue

33

I have 2 windows 10 pro computers both loaded with Microsoft Access 2010. On the first computer my

Troubleshooting Solution

Dlookup problem

154
Based on the following print screen provided i am trying to do a Dlookup on that query (the tables …
Post

I recently passed my Microsoft 70-346 Exam.  As part of my …

4
I recently passed my Microsoft 70-346 Exam.  As part of my revision I used Flash Cards that I …
Article

Creating a custom Welcome form in Excel

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.
Troubleshooting Solution

redesign of Access Tables

byverpit
146
I have two Access tables that badly need a redesign.  I have posted the entire project and …
Post

Hello everyone out there in Experts Exchange World!  My name…

8
Hello everyone out there in Experts Exchange World!  My name is Terri and I am new to this site.  …
Post

Gmail just launched a physical Security Key access option, …

1
Gmail just launched a physical Security Key access option, dubbed as Advanced Protection, for their …
Video
Troubleshooting Solution

MS Access Product Variables Variations Multiple Product Conditions Table and Relationship Setup For Customer Orders and Inventory

133
Ok I am very lost on this part. I have Products and each product has 4 Product Conditions. These …
Troubleshooting Solution

fiscal year end calculations

133
I need to perform some calculations based on our clients fiscal year ends.  Not all of our clients …
Article

Understanding and using CommandBars, Part II (Creating your own)

38
Applies to: 2000, 2003, 2007, 2010, 2013 (desktop)

As stated in the first article,  
Troubleshooting Solution

How to create a dynamic query builder

131
I am trying to determine the best way to go about creating the code necessary to allow a user form …
Troubleshooting Solution

Access Experts: General discussion thread for Access Zone (31-Dec-2012)

118
This thread is intended for general discussion among Experts participating in the Access zones.  
Post

WebRTC Came to stay!  It took a while but it seems that …

1
WebRTC Came to stay!

It took a while but it seems that now there is no turning back.

Levou um …
Troubleshooting Solution

Quasi-Dashboard for Homemade Help Desk Program in Excel/Access

119
This question stems from a previous project that I have collaborated with one of my great friends …
Troubleshooting Solution

I'm running an Access 2016 Front End and a SQL Server 2014 back end. I'm unable to Update Access Date fields in my project.

110
I can't seem to get Access and SQL to communicate when it comes to Dates. The project I'm working on …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more