Introducing me..

[jonnyboy9]

Hi Everyone,

Access Newbie wanting to build something useful for my partner who has her own small business teaching football(soccer!) to kids.

Am interested in adapting one of the student templates that MS offers, although if anyone knows a better starting point, then please let me know.

Been an SAP SQL programmer for >20 years.

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[NauticalGent]

Welcome aboard!

 

[theDBguy]

Hi. Welcome to AWF!

 

[Uncle Gizmo]

Am interested in adapting one of the student templates that MS offers

Microsoft templates are not always constructed in accordance with best practices. It might be best if you posted the template you are going to use here and get some comments from regular contributors. Might save you a lot of hassle further down the line...

By the way welcome to AWF...

 

[The_Doc_Man]

Hello and welcome to the forum.

 

[jdraw]

Welcome to AWF, jonnyboy9.

 

[marcosrashfor]

Welcome aboard!

 

[KitaYama]

Welcome aboard!

I have a feeling the OP should welcome you. Because he's joined 12 days sooner than you.
Welcome to both of you

 

[MsAccessNL]

Hi Everyone,

Access Newbie wanting to build something useful for my partner who has her own small business teaching football(soccer!) to kids.

Am interested in adapting one of the student templates that MS offers, although if anyone knows a better starting point, then please let me know.

Been an SAP SQL programmer for >20 years.

Hello,welcome to the group. I personnaly wouldn't start with a template. They often have strange behaviour. They are also very outdated. Do you have experience with vba?

 

[GPGeorge]

Hi Everyone,

Access Newbie wanting to build something useful for my partner who has her own small business teaching football(soccer!) to kids.

Am interested in adapting one of the student templates that MS offers, although if anyone knows a better starting point, then please let me know.

Been an SAP SQL programmer for >20 years.

The Microsoft templates are actually not that bad, but they do not always employ best practices. Mainly, that consists of poor naming conventions for tables and forms. Plus they rely heavily on macros, which most Access developers don't encourage.

With regard to tables, many templates employ the dreaded Lookup Fields, MultiValue Fields, and Attachment fields. Experienced Access developers have learned to avoid those things through unpleasant experience. I think nearly every one here would strongly discourage using them even if the templates starts with them. Convert them to properly designed relational database tables and avoid that headache.