COMP1003: Microcomputer Applications – Tracking Database – Computer and Programming Assessment Answer

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

COMP1003: Microcomputer Applications Assessment Answer
Task:
Part 1 (Data entry and table creation):
Using Microsoft Access, you will be creating a student tracking database for your current semester and program.  You can use Banner, Blackboard, syllabi, and Georgian College’s website to gather all the data for the assignment.  Be sure that you reference anything you take off the Georgian website appropriately in APA format.
You will need to name all your fields appropriately and take particular care to how long the names are and their corresponding data types.  You will need to determine the best way to organize your data and decide what the Primary Key will be for each table (do this with careful consideration!!!)
Here is what you need to include in your database.  One of the three tables should be created originally in Excel and imported into Access.  Be sure to include this Excel file in your submissions.  Without it, you will lose marks.

Create three tables.

The first table should be a listing of current courses you are registered in. Here is the list of required fields you need to include and the appropriate data type (Name the table Current Courses):

CRN number (Number, no decimals)

Course Code (Short Text)

Name of the course (Short Text)

Instructor name (Short Text)

Semester number for the course (ex. Semester 1, semester 2, etc.) (Short Text)

Type of course (Ex. Mandatory, Communications, General Education, Optional) (Short Text)

Pre-Requisite required (Yes or no field) (Short Text)

*Note* You may change the names above just make sure you name things appropriately

The second table should be a listing of all assignments, tests, quizzes, and other items for marks in each of your courses. Here is a list of the fields you will need to include and the appropriate data type (Name the table Current tasks):

Name of item (Short Text)

Weight (ex. 25% of final grade) (Number, percentage format, no decimals unless required)

Course Code (Short Text)

Group activity (yes or no)

Type (Short Text) (Ex. Assignment, Test, Quiz)

Learning outcomes (Short Text)

Completed (Yes or no)

*Note* You will need to assign a Primary Key for this section

The third table should be a listing of all the courses you need to graduate from your specific program. Here is a listing of all the fields you will need to create and the appropriate data type (Name the table Program Courses):

Course Code (Short Text)

Name of the course (Short Text)

Program year (number, no decimals)

Semester number of the course (ex. Semester 1, semester 2, etc.) (Short Text)

Type of course (Ex. Mandatory, Communications, General Education, Optional) (Short Text)

Pre-Requisite required (Yes or no field) (Short Text)

*Note* You will need to assign a Primary Key for this section
Part 2 (Using the Database to get information):
Using queries, forms, and reports you will now withdraw information from the tables you created in Part 1.  Make sure that you name everything properly, nothing should be called “Query 1” or “Form 1” for example.
Queries to create (Name each Query with a name that makes sense, do not simply use Query 1, Query 2, etc.):

Create a query that will pull all the General Education courses you need to complete for your whole program. Include the course code, name of the course, and the semester number that you will take the course.

Create a parameter query that will pull different types of assignments, quizzes, and tests, that you need to complete this semester. Include the following fields: Name of the item, due date, Completed, Course code, and weight.

Create a query using fields from 2 of the tables you created. It can be any type of query.  There must be at minimum 1 field from each table you include.  Use a sort feature on one of the fields.

Create an “and” query. This can be done any way you like.

Create a query using a wildcard option. You may use the wildcard either at the beginning or the end of a letter. As shown in class.

Part 3 (Creating simple forms and reports):

Create a simple form from your Current Tasks table.

Name it appropriately

Create a simple report from your first Query results.

Name it appropriately

Make sure everything fits across the page properly, remove headings as needed and autofit data

Part 4:
Create a word document that houses your references in proper APA format. In that same document, answer the following questions, be sure to elaborate and explain yourself well:

Include all the information about your program. Include the following information:

Program name

The program code

The year you started the program

Your anticipated graduation date

What intake you are (Ex. Fall, Summer, or Winter)

Is your program Co-op?

What semester number you are currently enrolled in

Why is it important to learn how to use a database (not specifically access, but database management in general)? How can you use those skills learned in your future career?

What is the benefit of using an Excel document and importing it into Access?

How could you expand on the database you created for the remainder of your education?

Explain how you could use various queries to use this database as you continue with your education. Use at minimum two different types of queries.

This COMP1003: Microcomputer Applications Assignment has been solved by our Microcomputer Applications experts at TVAssignmentHelp. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
 

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services