Study Guides (248,645)
Canada (121,656)
Dr.Hurst (16)
Final

Computer Science - Final Exam.docx

4 Pages
119 Views

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

This preview shows page 1. Sign up to view the full 4 pages of the document.
Description
Final Exam Monday, December 10, 2012 9:00-11:00 Pre-Exam Review Excel  10% of exam deals with excel  More about concepts and terminology  Not about key strokes and key presses  Some of it involves syntax (IFs, VLOOKUP, etc.)  Hardest part of excels is pivot tables  If contain three parts: the condition, what to do if its true and what to do if its false  Nested IF: one structure inside another structure  Test nested ifs separately (build in steps) Access  Know terms and understand concepts  What is a key  How do we establish relationships between entities  What’s the difference between a foreign key and a primary key  What are the simple names for tuples and records  Want to populate primary table with data first then the foreign table  When deleting do it the opposite way (foreign table then primary table)  Do not need to know where the buttons are just understand what it means to perform that action  What is the navigation pane for: collects and lets you see the various objects you have in your database  Use wizard to do reports and forms (know what they are for – one for input one for output)  Use wizard to do the job then fix it to your specific needs  When making a query you make it first and do not use the wizard (can use QBE)  Importing from text files  Difference between ordinary text files from csv text files  Enforce integrity constraints: referential integrity (foreign key value cannot be used unless the primary key value exists in another table), cascade update and cascade delete (why do not always tick off because do not necessarily want to lose records in the primary table)  Constraint on primary key: uniqueness  Relational operators are comparison operators (less than, greater than, equal to)  Logical operators (and, or)  Aggregate functions (have to click on total button to get total line get things like group by, max, min)  Calculated field: making use of at least one existing field and manipulating them some how (usually in a mathematical expression)  Can see what would happen if a certain thing happened/changed  Calculated field makes use of data in the table as well as data not used in the table (such as a constant or something)  When building the calculation, access helps you by having the “expression builder”  Main thing to remember is calculated fields are not saved in the database (temporary) Information Presentation  How to created depth  How to give presentation a specific look  How to manipulate the eye  How to keep someone intrigued, how to make them stop and look  Dynamic thirds, control eye motion with diagonals, place graphics, stingers and grabbers to try and grab attention  Different colour schemes: analogous, direct, complementary  Always have one colour dominate and other in the background
More Less
Unlock Document

Only page 1 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