UNIVERSITY OF FUJAIRAH
COLLEGE OF ARTS AND HUMANITIES
General Education Department
ASSIGNMENT 1
ICT113 INTRODUCTION TO INFORMATION TECHNOLOGY
Section 01
SUMMER SEMESTER, AY 2024-2025
June 20, 2025
MR. ABDELRAHMAN BUSATI
CLO Type of No. of Weighted
CLO Description Points Score
# Examinations Items mark(s)
Apply IT principles in integrating
1 hardware, software, and networking
components effectively.
Utilize Microsoft Access, Excel, and
Python to create functional databases A computer 4x2
2 6 10
and applications that meet specified practical work 2x1
user needs. 10
Explore the usage of Artificial
3 Intelligence and Machine Learning in
real-world applications.
Review social and ethical issues in
4 computing to understand their
implications in IT practices.
Integrate HTML and CSS tools for
5
creating well-designed web pages.
The maximum mark is 10
TOTAL 10 10
This Assignment is 10%
10
Instructions:
Fill in the cover page and write your name, ID and sign the page.
Submission must be via Moodle. No email submissions to the instructor.
NO GROUPWORK ALLOWED.
This is a computer practical work Assignment
Student’s ID:
Signature:
Student’s Name:
1
1. Create New Database
I. Open Microsoft Access
II. Create a new blank database named "CustomerOrderDB"
III. Save it in your designated folder
2. Using the External Data tab:
Import the [Link] file,
Name the table "Customers" (following naming conventions)
Ensure CustomerNo becomes the primary key
Verify that all customer names are imported correctly
Import [Link] file
Name the table "Orders" (following naming conventions), Set ID field as primary key (rename
to OrderRecordID)
Check that all 40+ records imported successfully
3. Review Field Data Types:
Ensure date fields are Date/Time type
Set appropriate field sizes for text fields
Make PricePerUnit and Total currency fields
4. Add Data Validation:
Set required fields appropriately
Add input masks where beneficial
5. Create Table Relationships
Using the Database Tools tab → Relationships (refer to pages 4 and 6 of handout):
6. Basic Select Queries
Create the following queries (refer to pages 7-8 of handout):
I. All Customer Orders:
Show CustomerName, OrderDate, Product, Quantity, Total
Sort by CustomerName, then by OrderDate
Save the query
II. HighValueOrders:
Display orders with Total > $50
Include all relevant order details
Use criteria to filter results
2
III. Order Summary:
Create a calculated field for Total + ShippingCharge
Name it "GrandTotal"
Include CustomerName, Product, Total, ShippingCharge, GrandTotal
Use proper calculation syntax: GrandTotal: [Total] + [ShippingCharge]
7. Customer Entry Form
I. Create Customers:
Use the Form tool on the Create tab
Base it on tblCustomers
Format professionally in Layout View
Test data entry functionality
II. Create Orders:
Base on tblOrders
Include a combo box for customer selection
Format for easy data entry
Test with sample data
III. Create Customer List:
Show all customers in alphabetical order
Format professionally
Add report header with title and date
IV. Create Order Summary:
Group orders by customer
Show customer totals
Include grand total for all orders
Add page numbers and professional formatting
8. Deliverables and Submission Requirements
Submit the following:
1. Complete Access Database File (.accdb)
All tables with imported data
Established relationships
All required queries, forms, and reports
3
Grading Rubric
Component Points Criteria
Database Planning 2 Clear analysis, proper naming conventions
Table Creation & Import 2 Successful import, proper field types, primary keys
Correct relationship established with referential
Relationships 2
integrity
Queries 2 All queries work correctly, proper syntax
Forms 1 Professional appearance, functional
Reports 1 Well-formatted, informative
Total 10