Data Files samples / School or training centre

Lantern Learning Centre

Students, families, classes, registers, test results and termly fees for a tuition or training centre.

Download 200 KB19 tables, 13 queries, 9 reports, 6 print templates and 13,441 invented records, dated back from 2026-10-22.

How the tables are related

A line runs from a field that points at another table's record to that table. Data Files keeps a record from pointing at one that is not there, and a query with both tables joins them by it.

Students.Family points at Families
Classes.Course points at Courses
Classes.Teacher points at Teachers
Classes.Term points at Terms
Enrolments.Student points at Students
Enrolments.Class points at Classes
Enrolments.Invoice points at Fee Invoices
Lessons.Class points at Classes
Lessons.Teacher points at Teachers
Lessons.Pay Statement points at Pay Statements
Attendance.Lesson points at Lessons
Attendance.Student points at Students
Assessments.Class points at Classes
Results.Assessment points at Assessments
Results.Student points at Students
Fee Invoices.Family points at Families
Fee Invoices.Term points at Terms
Payments.Invoice points at Fee Invoices
Term Reports.Student points at Students
Term Reports.Term points at Terms
Report Lines.Report points at Term Reports
Report Lines.Class points at Classes
Certificates.Enrolment points at Enrolments
Pay Statements.Teacher points at Teachers

Start Here

The guide to this database: the everyday tasks a step at a time, each step saying which table, form, query, report or print template to open. Open its report, Start Here, to read or print it. Delete the table when you no longer need it; nothing else uses it. (33 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Order	Whole number	The order the steps are read in.
Task	Short text, required	The everyday task the step belongs to.
Step	Whole number	The step's number within its task.
What To Do	Long text	What to open and what to do there.

Business

The business's own details, in one record. Every document it prints, an invoice, a receipt, a statement or a letter, takes its name, address and payment details from here, so they are changed in one place. (1 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Name	Short text, required	The name printed at the top of every document.
Address	Short text	The street address.
City	Short text	The town or city.
Postcode	Short text	The postcode or ZIP code.
Country	Short text	The country.
Phone	Short text	The phone number customers call.
E-mail	Short text	The address customers write to.
Website	Short text	The website, if there is one.
Tax Number	Short text	The VAT or sales tax registration number, printed on invoices. The sample has a placeholder.
Company Number	Short text	The registered company number, where the business is a company. The sample has a placeholder.
Bank Details	Short text	Where customers pay by transfer: the bank, account name and number. The sample has a placeholder.
Payment Terms	Short text	The words printed under an invoice's total, such as "Payment within 30 days".
Tax Rate	Number	The usual rate of VAT or sales tax as a fraction: 0.2 is twenty percent. Lines may carry a rate of their own.
Currency	Short text	The currency the business trades in, as its three-letter code.
Document Footer	Long text	A line or two at the foot of every document: thanks, opening hours, returns policy.

Terms

The blocks of weeks the centre teaches in: three terms a year and the school holidays between them, when holiday workshops run. Every class belongs to one, and fees are invoiced by it. Enter these first. (7 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Name	Short text, required, unique	The name families know the block by, such as Autumn 2026 or Easter holiday 2026.
Kind	Short text	Term for a teaching term, Holiday for the holiday workshops between terms.
Starts	Date, required	The first day of the block. Invoices go out three weeks before it.
Ends	Date, required	The last day of the block. A class whose term has not ended is current or coming, and the class lists and free places look only at those.

Families

One record for each household that pays: the parent or carer who is the centre's contact, and where to send letters. Brothers and sisters share one family. An adult learner is their own family, with Relationship set to Self. (186 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Name	Short text, required	The name the account goes by, such as Okafor family, or the adult learner's own name.
Contact	Short text	The person the centre talks to and sends invoices to.
Relationship	Short text	What the contact is to the students: Parent, Grandparent, Carer, or Self for an adult learner.
Phone	Short text	The contact's phone number, used when a child is unwell or a class is cancelled.
E-mail	Short text	Where invoices and reports are sent.
Second Contact	Short text	Another adult who may collect the children or be called, when there is one.
Second Phone	Short text	The second contact's phone number.
Address	Short text	House number and street, for letters.
City	Short text	The town or city.
Postcode	Short text	The postcode.
Pays By	Short text	How the family usually pays: Bank transfer, Card or Cash.
Notes	Long text	Anything the office should know, such as a bursary place or who collects the children.

Students

One record per learner, child or adult. Keep a child's record to what the centre needs; contact details are on the family. (213 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Family	Points at Families, required	The family who pays and is contacted for this student.
First Name	Short text	The student's first name, as used in class.
Last Name	Short text, required	The family name; lists are sorted by it.
Date of Birth	Date	For children, to place them in the right school year and for the birthdays list. Left empty for adults.
School Year	Short text	The school year the child is in this year, Year 3 to Year 11, or Adult. Change it each September as children move up.
Medical Note	Short text	A short note for the teacher, such as a nut allergy or an inhaler kept in the bag. Empty for most students.
Photo Consent	Yes/No	Yes when the family has agreed that photographs of the student may be taken at the centre.
Joined	Date	The day the student first enrolled.
Active	Yes/No	Yes while the student is in a class now or was in one in the last two months. Set it to No when they leave; their records stay.

Teachers

The people who teach, paid by the hour for the lessons they take. (10 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
First Name	Short text	The teacher's first name.
Last Name	Short text, required	The teacher's family name.
Subjects	Short text	What they teach, such as Maths, Science. Used to find cover when a teacher is away.
Hourly Rate	Currency	What the centre pays them for an hour of teaching.
Phone	Short text	The teacher's phone number.
E-mail	Short text	The teacher's e-mail address at the centre.
Started	Date	The day they started teaching at the centre.
Background Check	Date	The date of their latest background check for working with children. The centre renews them every three years.
Active	Yes/No	Yes while they teach at the centre.

Courses

What the centre teaches: one record for each subject at each level, with its length and price. A course runs as one or more classes each term. (25 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Code	Short text, unique	A short code, such as MA56 for maths for Years 5 and 6. Class codes start with it.
Name	Short text, required	The course name on the timetable and invoices.
Subject	Short text	Maths, English, Science, Coding, Spanish, French, Mandarin or Bookkeeping. Teachers are matched to classes by it.
Level	Short text	Who it is for: the school years, GCSE, Beginner or Improver.
For	Short text	Children or Adults.
Holiday Course	Yes/No	Yes for the workshops that run in the school holidays.
Minutes	Whole number	How long each lesson lasts.
Fee per Lesson	Currency	The price of one lesson. A term's fee is this times the lessons billed.
Capacity	Whole number	The most students a class of this course takes.
What to Bring	Short text	What a student brings to each lesson, printed on the enrolment letter.

Classes

One group of students taking a course in one term, on one weekday at one time, in one room, with one teacher. (120 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Code	Short text, required	The course code, the weekday and the start time, such as MA56 Tue 16:00.
Course	Points at Courses, required	The course this class teaches.
Teacher	Points at Teachers	The class's own teacher. A lesson taken by someone else records them on the lesson.
Term	Points at Terms, required	The term or holiday the class runs in.
Weekday	Short text	The day of the week it meets.
Start Time	Short text	When the lesson starts, as 16:00.
Room	Short text	Where it meets: Room 1, Room 2, Room 3 or the Computer Room.
Capacity	Whole number	How many students it takes, set by the course and the room.
Lessons Planned	Whole number	How many lessons it has this term, leaving out the days the centre is closed.

Enrolments

One record for each student in each class: the place booked and what is charged for it. (701 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Student	Points at Students, required	Who is enrolled.
Class	Points at Classes, required	The class they are enrolled in.
Enrolled On	Date	The day the place was booked.
Status	Short text	Enrolled for a class still running or about to start, Completed when the term has ended, Withdrawn when the student left part way through.
Lessons Billed	Whole number	How many lessons are charged for: all of them, or those left for a student who joined after the start.
Discount	Number	A share off the fee, as 0.1 for ten percent: brothers and sisters after the first get 0.1, a bursary place 0.5.
Left On	Date	The day a withdrawn student left. Fees are not refunded part way through a term.
First Lesson	Date	The first lesson the student comes to: the class's first, or a later one for a student who joined after the start. The enrolment letter gives it.
Invoice	Points at Fee Invoices	The family's fee invoice for the term that charges for this place. Each place is a line of that invoice; it is empty until the invoice is sent.

Lessons

Every lesson of every class: those taught, those planned for the rest of the term and the next, and the few cancelled. (1,483 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Class	Points at Classes, required	The class the lesson is for.
Teacher	Points at Teachers	Who took the lesson, which is the class's teacher unless someone covered. Teacher pay is worked out from it.
Lesson Date	Date, required	The day of the lesson.
Minutes	Whole number	How long it lasted, which is what the teacher is paid for.
Topic	Short text	What the lesson covered, or is planned to cover.
Status	Short text	Taught, Planned or Cancelled. Only taught lessons are paid.
Pay Statement	Points at Pay Statements	The month's pay statement the lesson was paid on, set when the month's statements are made. Empty for planned and cancelled lessons and for this month's.

Attendance

The register: one mark for each student at each lesson taught. (7,516 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Lesson	Points at Lessons, required	The lesson the mark is for.
Student	Points at Students, required	The student marked.
Mark	Short text	Present, Late or Absent.
Reason	Short text	Why the student was absent or late, when the family said.

Assessments

The tests and marked pieces of work set to a class. Children's classes have a test at half term and one at the end of term; adult courses have one at the end. (147 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Class	Points at Classes, required	The class that sat it.
Assessment Date	Date	The day it was sat or handed in.
Title	Short text	What it was, such as Half-term check or End of term test.
Out Of	Whole number	The highest mark possible.

Results

Each student's mark in each assessment they sat. A student away that day has no result. (872 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Assessment	Points at Assessments, required	The assessment the mark is for.
Student	Points at Students, required	Who sat it.
Score	Whole number	The mark, out of the assessment's Out Of.
Comment	Short text	The teacher's short comment, when there is one; it goes on the progress report.

Fee Invoices

One invoice for each family for each term or holiday they book, covering every class their students take in it. Its lines are the Enrolments that point at it. (464 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Number	Short text, unique	The invoice number, given in date order and once only, a new run each year: INV-2026-0042. Families quote it when they pay.
Family	Points at Families, required	Who the invoice is for.
Term	Points at Terms, required	The term or holiday it is for.
Invoice Date	Date	The day it was sent, three weeks before the term starts or when a late place was booked.
Due Date	Date	When it should be paid: by the first day of the term.
Amount	Currency	The total of the family's fees for the term, after discounts.
Paid So Far	Currency	What has been paid against it. Keep it equal to the total of its payments; what is left is outstanding.

Payments

Each payment received against an invoice. A family paying in instalments has several. Each one is a receipt. (600 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Number	Short text, unique	The receipt number, in date order, a new run each year: RCP-2026-0042.
Invoice	Points at Fee Invoices, required	The invoice the payment is for.
Paid On	Date	The day the money arrived.
Amount	Currency	How much was paid.
Method	Short text	Bank transfer, Card or Cash.
Balance After	Currency	What was left to pay on the invoice once this payment was in, printed on the receipt. Nought when the invoice is paid in full.

Term Reports

The progress report sent home at the end of each term: one for each student who was in a class that term. Its lines are in Report Lines. (340 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Student	Points at Students, required	Who the report is about.
Term	Points at Terms, required	The term it reports on.
School Year	Short text	The school year the student was in that term, kept as it was, since the student's own record moves up each September.
Written On	Date	The day it was written, in the week after the term ended.
Comment	Long text	The centre's comment on the term as a whole, printed under the lines.

Report Lines

One line of a term report for each class the student took that term: the register added up and the test marks, with the teacher's comment. (459 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Report	Points at Term Reports, required	The term report the line belongs to.
Class	Points at Classes, required	The class it reports on; the course and teacher come from it.
Lessons	Whole number	How many lessons the student was marked at that term.
Present	Whole number	How many of them they were present at on time.
Late	Whole number	How many they came to late.
Absent	Whole number	How many they missed.
Half-term %	Whole number	The half-term check mark as a percentage; empty for adult courses, which have no half-term check, or when the student missed it.
End of Term %	Whole number	The end of term test mark as a percentage; empty when it was missed.
Comment	Short text	The teacher's short comment for the class.

Certificates

A certificate of completion for each place in an adult course or a holiday workshop finished with at least three lessons in four attended. (141 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Number	Short text, unique	The certificate number, in the order they are issued, a new run each year: CRT-2026-0042.
Enrolment	Points at Enrolments, required	The place it is for: the student, the class, its course and term come from it.
Issued On	Date	The day it was given, a few days after the course ended.
Lessons Attended	Whole number	How many lessons the student came to, on time or late.
Hours	Number	The hours of teaching those lessons came to.

Pay Statements

A pay statement for each teacher for each month that has ended: the lessons they taught are its lines (the Lessons that point at it), with the hours and gross pay. (123 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Number	Short text, unique	The statement number, in month order, a new run each year: PAY-2026-0042.
Teacher	Points at Teachers, required	Who is paid.
Month	Short text	The month it pays for, as 2026-09.
Period Start	Date	The first day of that month.
Period End	Date	The last day of that month.
Paid On	Date	The day the pay goes out, the seventh of the month after or the next working day; empty until then.
Hourly Rate	Currency	The teacher's hourly rate for the month.
Lessons	Whole number	How many lessons they taught that month.
Hours	Number	The hours those lessons came to.
Gross	Currency	The pay before tax and National Insurance: each lesson's pay rounded to the penny, then added up, as the statement prints it.

Next: Queries, forms, reports and print templates