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

Dreamweaver

Well-known member
Local time
Today, 10:04
Joined
Nov 28, 2005
Messages
2,466
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

Well-known member
Local time
Today, 10:04
Joined
Nov 28, 2005
Messages
2,466
Just finalised the version 1 ERD


This is as simple as possible but will be a good Foundation
 
Last edited:

Dreamweaver

Well-known member
Local time
Today, 10:04
Joined
Nov 28, 2005
Messages
2,466
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

Well-known member
Local time
Today, 10:04
Joined
Nov 28, 2005
Messages
2,466
Last edited:

Dreamweaver

Well-known member
Local time
Today, 10:04
Joined
Nov 28, 2005
Messages
2,466
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
 

Users who are viewing this thread

Top Bottom