Scribd
Upload
28 views2 pages

MS Access Database Design for Dog Walking

The document outlines a practical IT task for creating a database using MS Access for a dog-walking company, Paws & Walks. It includes tasks such as designing tables for owners, dogs, and walks, establishing relationships, creating input forms with validations, and generating queries and reports. Additionally, it poses evaluation questions regarding database concepts like primary keys and referential integrity.

Uploaded by

Axad and IT Skills
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
28 views2 pages

MS Access Database Design for Dog Walking

The document outlines a practical IT task for creating a database using MS Access for a dog-walking company, Paws & Walks. It includes tasks such as designing tables for owners, dogs, and walks, establishing relationships, creating input forms with validations, and generating queries and reports. Additionally, it poses evaluation questions regarding database concepts like primary keys and referential integrity.

Uploaded by

Axad and IT Skills
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Practical IT Task Paper — Database (MS Access)

Scenario:
You are working for Paws & Walks, a dog-walking company. The company wants to
computerize its database system to manage client (owner) information, dog details, walk
bookings, and daily scheduling.

Task 1: Create and Design Tables


1.1 Create the following three tables in a new Access database file:

 - Owners
Fields: OwnerID (AutoNumber, Primary Key), FullName, PhoneNumber, Email
 - Dogs
Fields: DogID (AutoNumber, Primary Key), DogName, Breed, Age, OwnerID (Number,
Foreign Key)
 - Walks
Fields: WalkID (AutoNumber, Primary Key), DogID (Number, Foreign Key), WalkDate,
NumberOfWalksPerDay, WalkDuration

📝 Add at least 3–5 sample records in each table.

Task 2: Create Relationships


2.1 Create relationships among the tables as follows:

 - One owner can have multiple dogs.


 - One dog can have multiple walks.

Ensure referential integrity is enforced.

Task 3: Create Input Form with Validations


3.1 Create a form named frmAddWalk for entering walk bookings. It must include:

 - Dropdown (lookup) to select a dog.


 - Field to enter NumberOfWalksPerDay (1, 2, or 3).
 - Automatically calculate and display WalkDuration using this logic:
- 1 walk/day → 60 minutes
- 2 walks/day → 30 minutes each
- 3 walks/day → 20 minutes each

Use macros or expressions (no VBA) to calculate and display duration.

Task 4: Apply Validation Rules


4.1 Add validation rules in the table or form for the following:
 - FullName in Owners cannot be blank and must contain only letters.
 - PhoneNumber must be exactly 11 digits.
 - Age of the dog should be between 1 and 20.
 - If the form is left incomplete, display a message and prevent saving.

Task 5: Create Queries


 - List of all dogs with their owners’ names and contact numbers.
 - List of walks scheduled for today.
 - Count of total walks per dog.

Task 6: Create Reports


6.1 Create a report named WalkScheduleReport that includes:

 - Owner Name, Dog Name, Walk Date, and Walk Duration


 - Sorted by WalkDate, grouped by Owner Name

Task 7: Evaluation Questions


 - What is a primary key? Which fields were used as primary keys in your database?
 - What is referential integrity? Why is it important?
 - What is the benefit of using lookup fields?
 - Explain how data validation improves database quality.
 - Identify any improvements you could make to your database design.

You might also like