Tutors / Consultants?

[EricC]

This is maybe off-topic but worth a shot. Are there any tutors or consultants in the BOSTON area that would like to meet at a PUBLIC space and do some tutoring / consulting on a database project? Willing to pay for your time. Ideally I want to LEARN from the process rather than to just hand it over and get back a completed database. Doesn't have to be in Boston, I can cover most Massachusetts. Looking to do it in a public space like a library or Starbucks.

[orange]

Ideally I want to LEARN from the process rather than to just hand it over and get back a completed database.

I don't know if anyone in the Boston area will respond, but I have to ask what are some of the factors preventing you/(your group) from doing some progressive development?
Here is a link to several articles on Database Planning and Design.

[EricC]

Time is my (our) biggest enemy. I can sit with hours of youtube videos or 2500 pages of manuals but in the end either a good tutor or even a classroom environment is preferable to me. Maybe it's because I am old school or just plain old. The youtube and or self paced reading generally leaves me with more questions than answers. I am still hopeful that SOMEONE in the Boston area is willing to teach me this. I have the tables set up and have some skills but not enough to put it all together. Worst case we'll have to send it out to be done.

[GinaWhipp]

Don't know about anyone in Boston but...

https://www.goskills.com/Tutor/Crystal-Long

[orange]

Until a favorable response comes in, how about showing us
-a description of the business issue/opportunity, and
-your tables and relationships as a jpg/png?

Update: Just saw Gina's post re Crystal. Great source if available.

[EricC]

That's the problem I can't post the tables due to confidentiality issues.

I have multiple tables setup and I can get the forms to work individually with individual tables. It's when I want to have 3 tables working in ONE form that it all goes haywire. I will just hope that someone in the Boston area will reach out otherwise I will plod along for a few more weeks before I have to kick it to some 'job site' and have someone in India or Russia figure it out.

[Bob Fitz]

That's the problem I can't post the tables due to confidentiality issues.

So post with a few dummy records in each of the tables.

[orange]

I'm quite sure your data may be confidential, but I was really asking for the table structure and the business requirement.

[EricC]

I'm quite sure your data may be confidential, but I was really asking for the table structure and the business requirement.

Here are the tables. There is a table for the employee, a table for the jobs requested and a table of the teams that hold the jobs.

What I would like is ONE form where I can enter the employee name and the top section populates with that employee record. Then in the middle section I would like to be able to enter all the information for the requested job.... MAYBE if possible have the bottom section pull up the team contact from the information put into 'team2' That would be the starting point. Ideally I would love to have a popup when I enter team 2 info show me all the jobs already requested for team 2

[GinaWhipp]

Well, there are some red flags...

1. Field names like *Group* and *Week* are reserved words and will cause you problems down the road. Have a look at...

http://allenbrowne.com/AppIssueBadWord.html


http://www.utteraccess.com/forum/Acc...s-t539419.html

2. Seeing fields like *Team1*, *Team2*, *Team3* says your tables may not be properly normalized. There should perhaps be a tblTeams.
3. Job Site Contacts, well you really need a tblContacts and then a tblJobContacts (junction table or your Job Site Contacts table)
4. It's not really clear what *conf* and *conf2* do.
5. I would use Look-Up Tables for Credential Status and Credential Type
6. Fields with names like Field# mean nothing and should be properly named.

So, if it were me tutoring you... I would first get the tables properly normalized before worrying about Forms or Reports.

[EricC]

Gina I was sloppy in 'cleaning up' the actual field names. The actual database does not use group and week. If you were tutoring me I could share the actual database and clear up some of these questions. Are you in the northeast?

[GinaWhipp]

In Ohio. Did you try Crystal? I know she does this using Skype.

[EricC]

No I am in Boston. I honestly thought finding a local tutor/instructor in BOSTON would be easy. You can't swing an Atari 2600 by the power cord around here without hitting 4 IT people.

Sadly my time frame for getting this is done is closing and the people who wanted to farm this out to someone in India will win the argument.

Which only means next time it will get posted to one of the programmer job sites and I won't even get a chance to keep it in house.

[GinaWhipp]

Yeah, finding someone fluent in VBA is not as easy as it sounds. Besides the fact you will not find anyone here as cheap as India. All I can say is best of luck.

[EricC]

Yeah, finding someone fluent in VBA is not as easy as it sounds. Besides the fact you will not find anyone here as cheap as India. All I can say is best of luck.

Wasn't a matter of finding someone 'cheap'. The feeling was that if we were going to just pay to get the end product then, yes, the least expensive option that accomplished a function end product would be the route... IF on the other hand we were going to train someone to be able to do this in the future it was worth the investment and something we would be willing to pay for. It didn't happen. The process has been eyeopening for me and one that has put a bright light on why so much work goes off shore. I posted this project to one of the programming job sites and within 30 minutes had 20 replies and by the end of the day it will probably double that. I figured that some student in the area (we have 1 or 2 schools in the Boston / Cambridge area that dabble in computer sciences... might be able to use a few hundred dollars and a latte