Study Guides (248,643)
Canada (121,651)
Dr.Hurst (16)
Midterm

Access Midterm Test Review

2 Pages
121 Views

Department
Computer Science
Course Code
COMPSCI 1BA3
Professor
Dr.Hurst

This preview shows 80% of the first page. Sign up to view the full 2 pages of the document.
Description
Hanson 1 Access Midterm Test Review Session 1.1: The Access Window Organizing Data  Identify each entity and it’s individual attributes o Entity- a person, object or event  Next, define each entity’s attributes as a set of fields o Fields- a single characteristic or attribute of the entity o Table- collection of fields which describes the entity  Each field as a specific data-type Databases and Relationships  Relational database- a group of related tables (simply known as “database”)  Common Field- ability to connect records in the separate tables which appears in both  Primary key (PK)- a field, or collection of fields, whose values uniquely identify each record in a table  Foreign Key (FK)- when you combine a PK from one table to form a relationship between two tables, the field is now called a FK Relational Database Manageme
More Less
Unlock Document

Only 80% of the first page are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit