Textbook Notes (368,566)
Canada (161,966)
Dr.Hurst (18)
Chapter

Access S.1.docx

2 Pages
110 Views
Unlock Document

Department
Computer Science
Course
COMPSCI 1BA3
Professor
Dr.Hurst
Semester
Winter

Description
Access Session 1.1 Relational Database system provides the following functions:  Allows you to create fields, tables and table relationships  Allows you to add, delete and manipulate records  Has a built-in query language which lets you obtain answers to the questions you have about your data  Contains built-in report generator, which lets you format reports from your data in terms of professional-looking  It protects database through security, back-up etc. In other words, it gives the system strength  Common field (AKA Join Field) is when data of two tables share common records  Field/Column selector selects the entire column  Record/Row selector selects the entire row  Data entered are immediately stored into the database  Table design such as field names and characteristics of a field are not. You have to manually save it  Database are listed in a Navigation Pane  Data is ordered in ascending or descending order bas
More Less

Related notes for COMPSCI 1BA3

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