Scribd Logo
Upload

Welcome to Scribd!

  • 555 views

    Database Individual Assignment

    Uploaded by

    Najihah Zulkifli
    This document outlines the requirements for an individual Microsoft Access database assignment. Students are asked to design a database for an Ultimate Gym containing a table of member information, a form to enter data, and three queries and reports. The table should include fields like name, address, contact details, and training information. Students must create a form to add at least 20 records (10 male, 10 female), define the table structure, and provide screenshots of the form, queries, and reports. The assignment is worth 10% and will be submitted through Google Classroom. A rubric is provided to evaluate the database objects.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Database Individual Assignment

    Uploaded by

    Najihah Zulkifli
    555 views2 pages
    This document outlines the requirements for an individual Microsoft Access database assignment. Students are asked to design a database for an Ultimate Gym containing a table of member information, a form to enter data, and three queries and reports. The table should include fields like name, address, contact details, and training information. Students must create a form to add at least 20 records (10 male, 10 female), define the table structure, and provide screenshots of the form, queries, and reports. The assignment is worth 10% and will be submitted through Google Classroom. A rubric is provided to evaluate the database objects.

    Original Title

    Database Individual Assignment (4)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the requirements for an individual Microsoft Access database assignment. Students are asked to design a database for an Ultimate Gym containing a table of member information, a form to enter data, and three queries and reports. The table should include fields like name, address, contact details, and training information. Students must create a form to add at least 20 records (10 male, 10 female), define the table structure, and provide screenshots of the form, queries, and reports. The assignment is worth 10% and will be submitted through Google Classroom. A rubric is provided to evaluate the database objects.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    555 views2 pages

    Database Individual Assignment

    Uploaded by

    Najihah Zulkifli
    This document outlines the requirements for an individual Microsoft Access database assignment. Students are asked to design a database for an Ultimate Gym containing a table of member information, a form to enter data, and three queries and reports. The table should include fields like name, address, contact details, and training information. Students must create a form to add at least 20 records (10 male, 10 female), define the table structure, and provide screenshots of the form, queries, and reports. The assignment is worth 10% and will be submitted through Google Classroom. A rubric is provided to evaluate the database objects.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    OBM255 Individual Database Assignment

    Mar – Aug 2021


    1

    Microsoft Access Database Assignment


    Individual Assignment (10%)

    Requirements

    As a management trainee in Ultimate Gym and Fitness Center, you have been asked to
    develop a simple database to store information of the members. You need to design a
    database which consists of a table, a form, three queries and three related reports.

    The Task

    The owner would need a customer list (containing all the necessary contact details and
    other personal information such as member’s number, last name, first name, address,
    contact number, gender, date of birth, blood type, types of training, name of instructor,
    monthly member’s charges, and occupation). Assign one field to be a primary key for the
    table. Enter at least 20 customer records (10 female customer and 10 male customer)
    using the form that have been created specifically for this database.

    TYPES OF TRAINING NAME OF INSTRUCTOR MONTHLY


    CHARGERS
    Weightlifting Training Kevin Zahri RM500
    Strength Training Kimberly Yap RM200
    Zumba Irene Ng RM50
    Yoga Karen Siah RM50
    Continuous Training Syed Hadid RM100
    Interval Training Fizz Fairuz RM300

    Define the structure of the table by specifying the field name, data type and description.
    Make sure you identify the primary key. Print screen the database structure in design
    view.

    Form

    1. Print screen all the form in form view.

    Queries
    Create queries to generate information below:

    1. A list of customers sorted by name and showing just their name, address and
    occupation. (Save as Query1).
    2. A data of FEMALE customer by showing just name, gender and contact number.
    (Save as Query2).
    3. A list of types of training, name of customer and instructor – sort in ascending order
    based on name of instructor. (Save as Query3).
    OBM255 Individual Database Assignment
    Mar – Aug 2021
    2

    Reports

    Create three reports based on the queries that have been produced and display it properly.

    SUBMISSION DATE:
    All required database objects should be submitted through Google Classroom. Folder for
    assignment submission will be provided in Google Classroom.

    RUBRIC

    OBM255

    MICROSOFT ACCESS ASSIGNMENT (10%)

    NAME : ……………………………………………………………………………………….

    CLASS: ……………………………………………………………………………………….

    No Items Marks Marks Earned


    Creation of database. Identify customers’
    1 5
    records and field.

    2 Identify Primary Key 1

    3 Identify field names, types, and description 6

    4 Print screen forms 6

    5 Print screen 3 queries 6

    6 Print screen 3 reports 6

    TOTAL 30

    You might also like