There are many Excel and Access forms and macro templates online for business purposes such as payroll and sales data. I could have copied and embellished them to highlight my abilities with these programs. Instead, I've taken a database from an area of personal interest to me in creating userforms for data entry, macros for analyzing data and report output.
Playing hockey (street, ice and inline) since a pre-teen and being from Pittsburgh; I'm a huge Pittsburgh Penguins fan. I used this interest as a basis for my dataset. I obtained online seasonal game statistics from their current and previous years. I've developed user input forms to enter stats for each game and also procedures to import stats directly from a hockey website (Hockey-Reference.com) into worksheets and tables. I then developed game reports in various formats and inter-interactive dashboards highlighting various statistical analyses for individual teams and players.
Data for the 2017_18 and 2018_19 seasons are included. I'll include the present 2019_20 season when it is more advanced.
Currently, I have a couple SQL queries that follow along with my Pittsburgh Penguins theme developed with my Excel and Access routines. These provide opposing teams scoring and penalty totals for the 2018-19 season. More routines are on the way.