CPSC-2200 Lecture Notes - Lecture 1: Aggregate Function, Relational Operator, Data Element
20 Nov 2017
School
Department
Course
Professor
Document Summary
Navigation pane lists access database objects and is the main center for opening and working with the objects. Field - a basic data element describing one thing about a person, place, or thing. A field corresponds to a column in an excel table or list. Record - a set of all the fields about one person, place, or thing. A record corresponds to a row in an. Table - a collection of records containing the same fields in the same order. Fields should contain data in the smallest increment; for example, street, city, state, and zip instead of the complete address in one field. Database - one or more tables and the supporting objects used to retrieve data from the tables. When planning a database, you should first consider what will be required, the output, of the database. Object - a basic element of an access database including tables, queries, forms, reports, macros, and modules.
