Design a database using Microsoft Access as DBMS

Assignment Help Basic Computer Science

Reference no: EM133141949

Assignment - Need to solve this in Microsoft access follow by instructions, below are some of the steps Table= create - table - save Query= Create - query design - choose the table you need - double click - then choose the field - then "run" on top left- save relationship= database tools - choose the table- drag the same field - save.

ACCESS PROJECT -

Project's Goal - to design a database using Microsoft Access as DBMS (Database Management System).

Main Component of Database -

2 tables -> (Student, Profs)

Queries -> (Create a query that display all the customer who are . . . . )

Forms

Reports

Notes: To connect 2 tables there must be something in common.

You must have a primary key/unique key such as ID Number, Mobile Number (to differ)

Queries and Reports are very similar

Table 1 of Databese

1. Choose 10 Fields/Columns (Student Name, Student ID, Mobile No, Nationality, Address, Emirates ID, Gender, Email Address, University, Occupations, Martial Status, DOB, area city)

2. Make 20 Records/Rows of each fields (Total of Students)

Table 2 of Databese

1. 5 Profs, Choose S Fields (Name, ID, Faculty, Email Address, University)

Reference no: EM133141949

Questions Cloud

Representation offered to indigent defendants : Discuss the three types of representation offered to indigent defendants discussed in your text.

CLWM4000 Business and Corporations Law Assignment : CLWM4000 Business and Corporations Law Assignment Help and Solution - Kaplan Business School - Assessment Writing Service

CGRM4000 Corporate Governance, Sustainability and Ethics : CGRM4000 Corporate Governance, Sustainability and Ethics Assignment Help and Solution - Kaplan Business School - Assessment Writing Service

MECH365 Design and implementation of PID controllers : MECH365 Laboratory: Design and implementation of PID controllers Assignment - Plot the root locus of the uncompensated system using the rlocus command

Design a database using Microsoft Access as DBMS : Project's Goal - to design a database using Microsoft Access as DBMS (Database Management System). Make 20 Records/Rows of each fields

BUS5AP - Business Application of Analytics Assignment : BUS5AP - Business Application of Analytics Assignment Help and Solution - La Trobe University - Assessment Writing Service - 'Kanban This' - Personas

Determine guilt and innocence : What are the advantages and disadvantages of a trial both the prosecution and the defense? Is there a better method to determine guilt and innocence?

Sociological factors play in explaining substance abuse : Evaluate the role psychological and sociological factors play in explaining substance abuse.

Victim impact statements : Victim Impact Statements (hereinafter referred to as "VISs") are statements read by, or on behalf of, crime victims at the sentencing phase of criminal trials.

User Account

All Pages