I created a file I need alot of help

[sf49ers164480]

https://1drv.ms/u/s!AnJwxxiz0Ezpg84o...fISXQ?e=NMuhdC





Thanks You
Sf49ers164480

[ranman256]

you didnt say what you needed.

[Micron]

...and post the file here (zipped) if you want to increase your chances. Some won't visit off-forum links.

[sf49ers164480]

I try attached file say to big to attached on here. Why is a link that have two files

access I create 2 table and one form. . Th second file need to unhide worksheets. I want same way. I do not sure how in access

Thanks you
SF49ers164480

[ssanfu]

Look in the header for "How to ATTACH Files".

[sf49ers164480]

I have try attach is say to big

[ssanfu]

You didn't follow the instructions and do a "Compact and Repair" before compressing the dB.



You really need to read about normalization. Right now, your table designs are like a spreadsheet. Access does not work like Excel.

In table "NFL TEAMS NAMES ALL 32 TEAMS", the names of the teams SHOULD NOT be field names.
In table "NFL SCHEDULE TABLE", you have repeating fields, spaces, punctuation and special characters in object names. These should be fixed.


Attached is a zip with
- the OP original Excel spreadsheet,
- the 2016 dB (compacted & repaired) and
- the dB converted to 2010.

There were 2 fields in table "NFL SCHEDULE TABLE" that were LONG NUMBER. The 2 fields are for team averages, so I changed them to DOUBLE.

[sf49ers164480]

I update files. I still need help with access. I not sure how get nfl schedule get to work.