Recent Discussions
New to Access
Hello! I am new to MS Access, and currently looking for some advice in working the program. In using Access, I am working with a team that has data in arts and crafts projects that fall under many different categories, which are being exported from Excel. I’ve attached an image of what this data looks like, but I’ve also explained it below. For instance, the data might be sorted into something like 5 fields, those being: project name, square inches, client name, and weight. An example would be: Project 1, 100 sq inches, Client A, 50 lbs Project 2, 200 sq inches, Client B, 100 lbs Project 3, 300 sq inches, Client C, 150 lbs Etc. Then, we’d have a second collection of data that would branch off of the first set. For instance, the data might be sorted into something like 4 fields, being: brand new design, concept design, restoration, or simple cleaning. Finally, a third set of data would branch off of this information, detailing that each of the aforementioned categories have their own data. Such as, brand new design projects use X brand of glue, Y brand of paint, and are always Z color. Whereas, simple cleaning projects might use a totally different brand of glue, paint, and color. Now, my question is, is it possible in MS Access to be presented with all of the data based on what I ask for? Such as, say, I want to view all projects that have used X brand of glue. Am I able to create a database that will pull that up? Or if I wanted to view all brands of paint used ONLY in cleaning projects? Essentially, is it possible to create a database that can show me any combination of information based on what I ask for, creating relationships with one another to search both forwards and backwards with simplicity? If so, what research should I do to approach this, or what other direction do you suggest that I go in if it is not possible? I appreciate the help :)
Chart plotting values in wrong place according to axis?
I have this chart in excel that is being produced from a table in another tab in the same workbook. It has simple date in one column and values in another. When I hover over the plots for the MailChimp line the value displays correctly (e.g. 1344 in the screengrab for 25/6/26 datapoint) but the plot is between 2500 and 3000 on the graph according to the axis. This isn't happening for any other lines on the graph for any other values, only for the Mailchimp line. Any ideas how I can rectify this or what could be going wrong?
Excel Pivot table showing only part of one row
Hello, I have an Excel pivot table that literally has one row that shows data for the 1st 3 columns and then no data for the remainder of the columns in the pivot table. All other rows in the pivot table show data for every field in the pivot table (as long as there is data in the underlying data source). The data source for the row in question is fully populated and contains no trailing spaces or other oddities that I can see. What could be causing this and how can I fix it so the data shows properly in my pivot table for this one row? (Some cell info. partially blanked out intentionally)
Recent Blogs
- SharePoint Online is introducing a new tenant-level setting that allows organizations to choose whether heading permalinks should appear on SharePoint pages.Jul 14, 2026
- 2 MIN READPowerPoint is getting easier to use with new SmartArt, fresh themes, a cleaner Design ribbon, and a more modern file open experience.Jul 13, 2026
