Club Management

System

Name: Srihari Renjith

Class: X-B
Roll no: 35

1|Page
 Table of contents

1)Main Page
2)Bonafige Certificate
3) Heading-[ Page 1]
4)Bibliography-[Page 3]
5)Key Features-[Page 4]
6)Design View of The Tables-[Page 6]
7)Database View of The Tables-[Page 8]
8)Relationship Among The Tables-[Page
10]
9)Screenshot of The Queries-[Page 11]
10)Screenshot of The Forms-[Page 13]
11)Screenshot of The Reports-[Page 15]

2|Page
 BIBLIOGRAPH
o A Club Management System is a software tool designed to streamline the
administration and operation of clubs or organizations by automating key
tasks such as member registration, event planning, communication, and
financial management. It helps clubs keep track of their members, manage
events, handle payments, and communicate effectively, all from a
centralized platform.

o A Club Management System improves efficiency by automating tasks like

member registration and event scheduling, saving time and reducing errors.
It enhances member engagement with easy access to services, simplifies
financial management by handling payments and reports, and centralizes
data for better organization. Additionally, it strengthens communication
within the club, leading to a more cohesive and smoothly run organization.

o Club Management Systems originated with the development of computer-

based management tools in the late 20th century. Initially, these systems
were simple databases or spreadsheets used to track members and events. As
technology advanced, especially with the rise of the internet in the 1990s
and early 2000s, more sophisticated web-based platforms were developed to
meet the growing needs of clubs and organizations. These systems evolved
to include features like online member registration, event management, and
integrated financial tools, becoming the comprehensive Club Management
Systems we know today.
3|Page
 Key Features
 Member Management: This feature allows for the efficient handling of
member information, including registration, profile updates, membership
renewals, and tracking of membership types. It provides a centralized database
where all member details are stored, making it easy for administrators to access
and manage.

 Event Management: The system enables clubs to create, schedule, and

manage events such as meetings, training sessions, or social gatherings. It
handles event registrations, tracks attendance, and can manage waiting lists.
Additionally, it can send automated reminders and notifications to members
about upcoming events.

 Communication Tools: Effective communication is crucial for any club, and

the system typically includes tools for sending emails, notifications, and
messages directly to members. This ensures that members are always informed
about important updates, events, and announcements. Some systems may also
integrate with social media platforms to extend communication reach.

 Financial Management: A robust financial management feature allows clubs

to handle payments for memberships, event fees, and other transactions. It can
generate invoices, track payment statuses, and integrate with accounting software
for seamless financial reporting. This feature is essential for maintaining accurate
and transparent financial records.

 Reporting: The system offers reporting tools that provide valuable insights
into various aspects of the club's operations. Administrators can generate reports
on membership demographics, event participation, financial performance.

4|Page
 Table Structure
Table Name : Customers
Customer-ID
Varchar(100)
Customer Name
Varchar(100)
Date of Join Date
Age
Numeric(12)
Phone no.
Numeric(12)

Tablename : Fee’s
Customer-ID
Numeric(12)
Customer Namer
Varchar(100)
Date of Join Date

5|Page
Fee Paid
Numeric (12)
Fee to Pay
Numeric (12)

Design View of The Tables

Table 1: Customers

6|Page
 Steps To Create A Table

Table 1:Customers

1) Open LibreOffice Base:

 Launch LibreOffice and choose "Base" to open the
database management interface.

2) Create a new database:

 Click on "Create a new database" and choose "Save" to
define
a name and location for your database file.

3) Design the Guest Table:

 In the database window, select "Tables" under your new
database.
 Right-click and choose "Create Table in Design View."

4) Define Table Structure:

7|Page
  Customer-ID (Numeric) – Unique identifier for the
customer.
 Name (Varchar) – Name of the customer.
 DOJ (Date) – Date of Join of the customer.
 Age (Numeric) – Age of the customer.
 Phone NO. (Numeric) – Phone number of the employee.
5) Set primary key:
 Select the "Employee_ID" field and mark it as the primary
key. 6)Save the Table:
 Name the table as "Employee" and save it.

Design View of The Tables

Table 2 : Fee

8|Page
 Database View of The Tables

Table 1 : Customers

9|Page
 Steps To Create Data Entry

1) Open LibreOffice Base:

 Launch LibreOffice Base and open the database file you
created earlier.

2) Navigating to Tables:
 In the database window, select the "Tables" section to view
10 | P a g e
 the list of tables.

3) Open the "Customers" Table for Data Entry:

 Double-click on the "Customers" table to open it in
datasheet
view.

4) Entering Data into the "Customers" Table:

 Click on the first row under each column and start entering
the data.
 Press "Tab" to move to the next cell or "Enter" to move to
the next row.

5) Saving the Data:

 Data is automatically saved as you move to the next row or
cell. There is no need for an explicit save button for data
entry.

6) Repeat for the “Fee’s" Table:

 Double-click on the "Salary" table to open it in datasheet
view
 Enter data such as Employee_ID, DOJ, Salary and Bonus.
Database View of The Table

Table 2 : Fee’s

11 | P a g e
 Relationship Between
The Tables

12 | P a g e
 Steps Of Setting A Relationship
1) Open LibreOffice Base:
 Launch LibreOffice Base and open the database file you
created earlier.

2) Navigate to the Relationships View:

 In the database window, select the "Tools" menu and then
choose "Relationships."

3) Add Tables to the Relationships View:

 In the Relationships window, right-click and select "Add
Tables."
13 | P a g e
  Add the "Customers" and "Fee’s" tables by selecting each
and clicking "Add."

4) Create a Relationship:
 Click and hold the "Customer _ID" field in the "Customer"
table
and drag it to the "Customer _ID" field in the "Fee’s" table.
 This will open the "Relation" dialog box.

5) Set Relationship Properties:

 In the "Relation" dialog box, you can set the properties for
the relationship.
 Ensure the "Update options" and "Delete options" are set to
"Cascade" to maintain referential integrity.
 Click "OK" to create the relationship.

6) Save the Relationship:Save the relationship by closing the

Relationships window and confirming when prompted.
Screenshot of The Queries

Table 1 : Customer’s

14 | P a g e
 Screenshot of The Queries

Table 2 : Fees

15 | P a g e
 Screenshot of The Forms

Table 1: Customer’s

16 | P a g e
 Steps To Create A Form

Table 1: Customer

1) Open Form Wizard:

 Go to Forms in the database window.

17 | P a g e
  Click Use Wizard to Create Form

2) Select Fields:
 Select the "Customer" table.
 Move the following fields to the form: Customer_ID,
Name,
DOJ, Age and Phone NO.
 Click next.

3) Arrange Controls:
 Select Columnar layout and click Next.

4) Set Data Entry Mode:

 Allow adding, modifying, and deleting records.
 Click next.

5) Apply Styles:
 Choose a style and click Next.

6) Name the Form:

 Name it "Customer".
Click Finish.

Screenshot of The Forms

Tablename 2 : Fee’s

18 | P a g e
 Screenshot of The Reports
Tablename 1 :Costumer’s

19 | P a g e
 Steps To Create A Report
1) Navigate to Reports:
 In the main database window, click on Reports in the left
sidebar.

2) Start Report Wizard:

20 | P a g e
  Click on Use Wizard to Create Report.

3) Select Report Type:

 Choose the type of report you want to create.
 Click next.

4) Select Tables/Queries:
 Choose the table or query that contains the data for your
report.
 Move fields from the "Available Fields" list to the "Fields
in your report" list.
 Click next.

5) Layout Selection:
 Choose the layout style for your report.
 Click next.

6) Apply Styles:
 Select a predefined style for your report.
 Click next.

7) Set Title and Save:

 Enter a title for your report.
Click Finish.

Screenshot of The Reports

Tablename 2 :Fee’s

21 | P a g e
22 | P a g e