Hi everybody I have stumbled accross this forum searching for help with Access2016 I work for an automotive company who uses Access to keep tract of the repair parts on hand. I will admit I knew nothing about Access went I first started in this role. Through trial and many errors I am here but I am having a real problem with Acess I would love to understand it more I do know I am at the limit of storage space but my company will not by a new program so I need to deal with it like it is. I have thought about splitting the database but I do not know what I'm doing. I love working in Access but like I said I have compiled tons of information but do not know how to store it correctly. I do no that the program is not the same as when I first started. I cannot run queries and the tables do not really work like they should. I take 100% responibility in this. I do have the main table working as it should, but the relationships are all messed up I need some serious help. I would like to learn start to finish. How should I proceed? I have the learning manuals but I am just not understanding how to layout these tables.
Newbie with older Access (1 Viewer)
- Thread starter TAMMYCOUL
- Start date
- Local time
- Today, 18:42
- Joined
- Sep 28, 1999
- Messages
- 7,900
Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.
We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.
To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:
https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/
We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!
We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.
To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:
https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/
We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!
- Local time
- Today, 12:42
- Joined
- Feb 28, 2001
- Messages
- 28,853
First: Hello, Tammy, and welcome to the forums.
Second: In either the General or Database Design sections, post a specific question or two. This is the introductory section so we ask for technical posts to be elsewhere.
In the meantime, as a starting point, I suggest you prepare to do some reading. Database storage efficiency is best if you normalize the tables. Therefore a good search topic would be Normalization (for this forum) or Database Normalization (for the general Internet/web). You need to qualify the search for the web because Normalization by itself is a significant term in chemistry, math, diplomacy, psychology, ... lots of disciplines.
When you do that search, you will probably get only about a gazillion hits. Start with web sites from the .EDU domain because they are more likely to have tutorials. However, once you start to feel more comfortable, the .COM sites are good, too. They are just more likely to want to sell you something while they have your attention.
For database questions, this forum DOES have a Search function (upper right). The hardest part about the Search function is knowing what to ask. Once you ask a question in an open forum, you can also look at the bottom of the page for "similar threads" to see if any of them look relevant.
Second: In either the General or Database Design sections, post a specific question or two. This is the introductory section so we ask for technical posts to be elsewhere.
In the meantime, as a starting point, I suggest you prepare to do some reading. Database storage efficiency is best if you normalize the tables. Therefore a good search topic would be Normalization (for this forum) or Database Normalization (for the general Internet/web). You need to qualify the search for the web because Normalization by itself is a significant term in chemistry, math, diplomacy, psychology, ... lots of disciplines.
When you do that search, you will probably get only about a gazillion hits. Start with web sites from the .EDU domain because they are more likely to have tutorials. However, once you start to feel more comfortable, the .COM sites are good, too. They are just more likely to want to sell you something while they have your attention.
For database questions, this forum DOES have a Search function (upper right). The hardest part about the Search function is knowing what to ask. Once you ask a question in an open forum, you can also look at the bottom of the page for "similar threads" to see if any of them look relevant.
Thank you so much. I will take a good hand slap for posting in the wrong spot. I needed to get my feet wet so I could get direction.
- Local time
- Today, 12:42
- Joined
- Feb 28, 2001
- Messages
- 28,853
No hand slaps here unless someone is playing music and I'm keeping time with it.
Trust me, we've seen newbies post all over the place. You'll figure it out. We'll help.
Trust me, we've seen newbies post all over the place. You'll figure it out. We'll help.
AngelSpeaks
Active member
- Local time
- Today, 12:42
- Joined
- Oct 21, 2021
- Messages
- 587
Hi Tammy and welcome!
miaalexandra
New member
- Local time
- Tomorrow, 00:12
- Joined
- Nov 7, 2024
- Messages
- 1
Hi everybody I have stumbled accross this forum searching for help with Access2016 I work for an automotive company who uses Access to keep ...
I am looking for an older version of Access to revive them because I don't need to spend a lot to use them. Is there an inexpensive version that will work with ... Access Beginner Level 1 is the perfect starting place for anyone who needs to learn the basics of building databases with Microsoft Access. In this step-by-step tutorial, learn how to use Microsoft Access. We walk what Access is for, why you should use it over a spreadsheet, how to create tables, ...
I am looking for an older version of Access to revive them because I don't need to spend a lot to use them. Is there an inexpensive version that will work with ... Access Beginner Level 1 is the perfect starting place for anyone who needs to learn the basics of building databases with Microsoft Access. In this step-by-step tutorial, learn how to use Microsoft Access. We walk what Access is for, why you should use it over a spreadsheet, how to create tables, ...
