Create a simple database using microsoft access

Assignment Help Basic Computer Science

Reference no: EM133579574

Introduction to Information Technology

Learning Outcome 1: Produce well-looking presentations to illustrate information utilizing textual, graphical, and animation effects.
Learning Outcome 2: Understand the file structures and create a database using DBMS.

Project Description

In this group project, students will work in teams to create a simple database using Microsoft Access. The students will learn and apply basic concepts of database design, data entry, querying, and form creation using Access. Additionally, each group will create a presentation using Microsoft PowerPoint to showcase their project.

Project Components and Grading in MS Access file:

Database Design and Setup
Define the purpose and scope of the database.
Create an appropriate table structure with relevant fields and data types.
Establish relationships between tables using primary and foreign keys.

Data Entry and Form Creation
Populate the database with sample data, ensuring accuracy and relevance.
Create forms for efficient data entry and display.
Design the form so that it is attractive to the users.

Querying and Reporting
Create at least two meaningful queries using various criteria and expressions.
Generate a report summarizing the data from the database.
Apply formatting to the report to enhance readability.

Presentation Guidelines in MS PowerPoint:

Introduction
Introduce the project and its objectives.
Provide a brief overview of Microsoft Access and its importance in managing data.

Database Design and Structure
Present the designed database structure, explaining the tables, fields, and relationships.
Highlight the purpose and functionality of each table in the database.

Data Entry and Form Creation
Showcase the process of entering data into the database using forms.
Explain how forms enhance data entry efficiency and user experience.

Querying and Reporting
Demonstrate the queries created and their purposes.
Showcase the generated report and explain its relevance.

Conclusion and Q&A
Summarize the project, emphasizing the key learning outcomes.
Open the floor for questions and answers from the audience.

Reference no: EM133579574

Questions Cloud

Describe the target market of bounce fitness : BSBMKG545 Conduct marketing audits - List at least two recommendations according to the outcomes of the marketing audit Recommendations can be related to change

Describe the purpose of the protection warfighting function : Identify the six warfighting functions and describe the purpose of the Protection warfighting function and the Sustainment warfighting function.

Identify a minimum of three mandatory employee benefits : Identify a minimum of three mandatory employee benefits. Provide the legal justification crucial to understanding the mandatory benefits offered.

Determine a strategy to resolve the ethical problem : Discuss the importance of following ethical guidelines in human service practice. Determine a strategy to resolve the ethical problem.

Create a simple database using microsoft access : CIT100 Introduction to Information Technology, Community College of Allegheny County - Understand the file structures and create a database using DBMS

What you come up with for what is costs to attend one class : HCD 310- Practicing Critical thinking Education by the hour. Assuming you did math correctly, what did you come up with for what is costs to attend one class?

How you view the role of technology in teaching and learning : Think Reflect on your experience building the web site and describe how that experience aligns with how you view the role of technology in teaching and learning

How the affects at least two communities of color : And how this affects at least two Communities of Color (African Americans, Asian Americans, Native Americans, and/or Latinx/Chicanx groups).

How would you describe the tone of each : How would you describe the tone of each? How would you describe the bias of each? Who is the intended audience? How do you know?

User Account

All Pages