CARA MEMBUAT PROGRAM ABSEN SISWA DENGAN MS ACCESS 2016

Introduction

This tutorial will guide you through creating a student attendance program using Microsoft Access 2016. This program will help you efficiently manage student attendance records, making it easier for teachers and administrators to track student presence.

Step 1: Setting Up Your Database

1. Open Microsoft Access

   • Launch the application and select "Blank Database."

2. Create a Database File

   • Name your database (e.g., "Student Attendance") and choose a location to save it. Click "Create."

3. Design Your Tables

   • You will need at least two tables:
     • Students Table: To store student information.
     • Attendance Table: To record attendance data.
   • Click on "Table Design" to start creating your tables.

4. Define Table Fields

   • In the Students table, add the following fields:
     • StudentID (Primary Key, AutoNumber)
     • FirstName (Short Text)
     • LastName (Short Text)
     • Class (Short Text)
   • In the Attendance table, include fields such as:
     • AttendanceID (Primary Key, AutoNumber)
     • StudentID (Number)
     • Date (Date/Time)
     • Status (Short Text, e.g., Present, Absent)

Step 2: Establishing Relationships

1. Create Relationships Between Tables

   • Go to the "Database Tools" tab and select "Relationships."
   • Add both the Students and Attendance tables to the relationships window.
   • Drag the StudentID field from the Students table to the StudentID field in the Attendance table to establish a one-to-many relationship.

2. Enforce Referential Integrity

   • In the relationship window, check the box for "Enforce Referential Integrity" to maintain data consistency.

Step 3: Creating Forms for Data Entry

1. Create a Form for Student Information

   • Navigate to the "Create" tab and select "Form Wizard."
   • Choose the Students table and select the fields you want to include (e.g., FirstName, LastName, Class).
   • Follow the prompts to create the form and save it as "Student Form."

2. Create a Form for Attendance Entry

   • Repeat the process using the Attendance table.
   • Include fields such as StudentID, Date, and Status.
   • Save this form as "Attendance Form."

Step 4: Generating Attendance Reports

1. Create a Report

   • Go to the "Create" tab and select "Report Wizard."
   • Choose the Attendance table to generate a report based on attendance records.
   • Follow the prompts to select fields and design your report layout.

2. Customize Your Report

   • Use the "Design" view to adjust fonts, colors, and layout to make the report visually appealing.
   • Save the report to easily access it later.

Step 5: Testing the Program

1. Input Sample Data

   • Use the Student Form to enter a few student records.
   • Use the Attendance Form to mark attendance for those students on different dates.

2. Run the Attendance Report

   • Generate the attendance report to ensure that data is being captured and displayed correctly.
   • Check for any discrepancies and make necessary adjustments.

Conclusion

You have now created a basic student attendance program using Microsoft Access 2016. This program allows for effective management of student attendance, with features for data entry and reporting. Next steps could include adding more functionalities, such as user authentication or automated email notifications for absentees.