Build a database from start to finish (Chart Tracker Database)

[Dreamweaver]

I have agreed with another music/Charts forum to Help there members build a simple charts tracking system.
This is being designed in lessons 3-4 per week using my Code Library and Project Management System
I am constructing this as simple as possible but later intend to take it further in small steps, I just thought it might be of aid to members here, Plus I would welcome input from members All the lessons can be found though The Lesson Index
All the best mick

 

[Dreamweaver]

Just finalised the version 1 ERD

This is as simple as possible but will be a good Foundation

 

[Dreamweaver]

This is the second Offering Of the Simple Charts Database Design

This video Takes you through Adding tblArtistsAndRecords, tblChartRecordings and tblFormats Plus shows related usages in my database CTE2525

One Note I made a mistake with the Points field I should have left a default value of 0 and will show how to correct errors in lesson 3

all the best mick

 

[Dreamweaver]

The third Offering Adding tblArtistsAndTypes, tblArtistTypes, tblChartNames.
Also demonstrates the usage of related items and how simple importing charts is

Related Files Download: https://www.databasedreams.co.uk/support/index.php?action=downloads;sa=view;id=57

 

[Dreamweaver]

The Final Part Of The Tables Design lesson 4
The video covers your main tblCharts Table & a related table tblLabels plus a few related forms view from CTE 2525
The Next offering will cover creating a few simple forms Plus we'll make a start on the main control.

Files Available Here https://www.databasedreams.co.uk/support/index.php?action=downloads;sa=view;id=58

 

[Dreamweaver]

With this lesson we create our UI/Front End, Update the database Settings, Link to the datafile tables
Create a template form, a main control form plus a List form and use a bit of copied code ;D

Download: This lessons files Here

 

[Dreamweaver]

In this video we create a couple more lookup lists, our artists Types Sub form, Plus use some code to Auto file The Combo Box List

Related Files: https://www.databasedreams.co.uk/support/index.php?action=downloads;sa=view;id=60