Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-14-2018, 10:37 PM   #1
DataDoggy
Newly Registered User
 
Join Date: May 2018
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
DataDoggy is on a distinguished road
MMORPG Inventory/Sales Tracking Tool

Hello everyone! A few friends of mine and I have been working on an inventory and sales management tool for a game we play. We're having some difficulty due to our inexperience with Microsoft Access and the unique tracking and inventory distribution we're trying to implement and manage.

To clarify what we're doing: We're playing an MMORPG that has groups consisting of multiple players to attend an event to generate items that can be sold for gold. We'd like to track the group attendance and the items sold for gold, and associate the gold earned with each player as unique player accounts, as well as a total guild bank account. We want to be able to associate the item sales with each event/player in order to track their accumulated donations as well as what they are owed. We're trying to create an accountable and transparent foundation for our guild and its members.

Here is the process in which we'd like to track:

1: Log the players that attends an event.
2: Log the item(s)generated from that event.
3. Log player decision to donate their share to guild bank or keep for themselves (split).
4: Log the sales for guild bank items.

Ideally, we'd like this all to be automated, where the only manually entries would be the steps listed above: Event/Participants, Items, Donate/Split (per player), Sales.

Any support is greatly appreciated! Thank you so much for any consideration!
Attached Files
File Type: zip game_inventory_tracker.zip (87.3 KB, 41 views)

DataDoggy is offline   Reply With Quote
Old 05-15-2018, 03:43 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 2,995
Thanks: 0
Thanked 657 Times in 642 Posts
Ranman256 will become famous soon enough
Re: MMORPG Inventory/Sales Tracking Tool

the zip file does not open....invalid.
Ranman256 is offline   Reply With Quote
Old 05-15-2018, 06:31 AM   #3
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 11,982
Thanks: 56
Thanked 1,091 Times in 997 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: MMORPG Inventory/Sales Tracking Tool

In general, Access has a steep learning curve after which things can start to fall in place. I am going to make some oblique suggestions to show you WHERE to look for information that will help you. I will suggest some reading topics.

This forum's SEARCH feature is quite decent. Look on the thin ribbon near the top of the page just under the box where it shows your login name. That is like a menu bar. Third from the right, you will see the Search item.

1. From the forum's Search, look for "Normalization" but for a general web search, look for "Database Normalization"

2. From the forum's Search, look for "Inventory" and "Invoicing" or "Invoices"

3. From the forum's Search, look for "Junction Table" and "JOIN Query"

4. From the forum's Search, look for "modeling" or "business model"

The idea is that you need to design a database to hold what you want to track. I will also give you two "guideline" type of rules, which I call the "Old Programmer's Rules."

Rule #1 - If you can't do it on paper, you can't do it in Access. Meaning, if you don't have a good feel for data flow, perhaps with a little diagram showing relationships and data flow for the process, you aren't ready to build anything in Access. It takes some up-front design work to get ready and without that up-front work, you won't go very far.

Think of Access as a power tool like a drill or a power saw. You use these tools to build furniture, but the tools won't do it by themselves. YOU do the building. The tools just bring it together faster. BUT it means you have to know what you want to build because Access won't do it for you.

Rule #2 - Access won't tell you anything you didn't tell it first. Meaning, if you want XYZ as one of your outputs, either XYZ must be an input, or you must have X, Y, and Z as inputs and give Access the formula to compute XYZ from its components. This sometimes means you must work backwards by knowing what you want OUT of Access and then verifying that Access has a way to know that.

Both of these rules probably make you think that it will take a while for the up-front design work. To which my comment is "Yes."

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 05-15-2018, 09:53 AM   #4
DataDoggy
Newly Registered User
 
Join Date: May 2018
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
DataDoggy is on a distinguished road
Re: MMORPG Inventory/Sales Tracking Tool

Quote:
Originally Posted by Ranman256 View Post
the zip file does not open....invalid.
Change the file extension to "RAR" and retry, please. Forum doesn't support RAR, but it supports ZIP. I had to change the RAR file format to ZIP, though it opened fine on my PC.

Quote:
Originally Posted by The_Doc_Man View Post
In general, Access has a steep learning curve after which things can start to fall in place. I am going to make some oblique suggestions to show you WHERE to look for information that will help you. I will suggest some reading topics.

This forum's SEARCH feature is quite decent. Look on the thin ribbon near the top of the page just under the box where it shows your login name. That is like a menu bar. Third from the right, you will see the Search item.

1. From the forum's Search, look for "Normalization" but for a general web search, look for "Database Normalization"

2. From the forum's Search, look for "Inventory" and "Invoicing" or "Invoices"

3. From the forum's Search, look for "Junction Table" and "JOIN Query"

4. From the forum's Search, look for "modeling" or "business model"

The idea is that you need to design a database to hold what you want to track. I will also give you two "guideline" type of rules, which I call the "Old Programmer's Rules."

Rule #1 - If you can't do it on paper, you can't do it in Access. Meaning, if you don't have a good feel for data flow, perhaps with a little diagram showing relationships and data flow for the process, you aren't ready to build anything in Access. It takes some up-front design work to get ready and without that up-front work, you won't go very far.

Think of Access as a power tool like a drill or a power saw. You use these tools to build furniture, but the tools won't do it by themselves. YOU do the building. The tools just bring it together faster. BUT it means you have to know what you want to build because Access won't do it for you.

Rule #2 - Access won't tell you anything you didn't tell it first. Meaning, if you want XYZ as one of your outputs, either XYZ must be an input, or you must have X, Y, and Z as inputs and give Access the formula to compute XYZ from its components. This sometimes means you must work backwards by knowing what you want OUT of Access and then verifying that Access has a way to know that.

Both of these rules probably make you think that it will take a while for the up-front design work. To which my comment is "Yes."
Thank you, I will use those search suggestions. Would you be willing to look at the file we've been working on and hint at some flaws or confirm we're on the right track? I appreciate the support.
DataDoggy is offline   Reply With Quote
Old 05-15-2018, 11:04 AM   #5
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 11,982
Thanks: 56
Thanked 1,091 Times in 997 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: MMORPG Inventory/Sales Tracking Tool

You are welcome for the suggestions. I look at .PNG files sometimes but I almost never open someone else's database files. An old habit, hard to break, and I came by it the hard and painful way.

Besides, making my suggestions for your files doesn't generally work right in the long run. No other reason than that YOU have been working on the project; YOU know what you want out; YOU know HOW you want it out. I'm an outsider looking in. I don't have the mental image that you have (or at least should have). So my suggestions will be off the mark.

Also, my schedule is not dependable because I have grandpa duty for my youngest grandson, and when he's around, HE uses this computer to the exclusion of everyone else. So when the runt of the litter is playing, I can't easily get to anything. (Yes, we DID spoil him rotten. We're grandparents. It's in our contract.)
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 05-26-2018, 11:13 PM   #6
DataDoggy
Newly Registered User
 
Join Date: May 2018
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
DataDoggy is on a distinguished road
Re: MMORPG Inventory/Sales Tracking Tool

Does anyone have any tips or hints to help towards getting us on the right path? Any insight would be appreciated. Thank you!
DataDoggy is offline   Reply With Quote
Old 05-27-2018, 01:00 AM   #7
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,224
Thanks: 2
Thanked 1,933 Times in 1,891 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: MMORPG Inventory/Sales Tracking Tool

Quote:
Originally Posted by DataDoggy View Post
Change the file extension to "RAR" and retry, please. Forum doesn't support RAR, but it supports ZIP. I had to change the RAR file format to ZIP, though it opened fine on my PC.
Have you looked at what The_Doc_Man suggested and if yes, what do you not understand?
Maybe you should start making a real zip file.
The members here are not making the program for you, but helping you if you've a specific problem!


__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Reply

Tags
inventory sales mmorpg

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
General Design Advice for Tool Tracking Zydeceltico General 15 12-06-2017 01:12 AM
Question Sales Forecasting Tool pbowler General 5 01-24-2013 10:47 AM
Create a sales tool Bjorn_DA Forms 7 01-06-2013 06:41 AM
Question Structure/Inventory Tool dim1962 General 4 04-26-2010 05:46 AM
Database Record Tracking Tool Template chantale General 0 06-17-2004 11:55 AM




All times are GMT -8. The time now is 05:20 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World