MGCR 331 Lecture Notes - Lecture 18: Open Database Connectivity, Data Type, User Friendly
Document Summary
Forms make data entry and display easier: provide a user-friendly interface to the data, control over a user"s additions and modifications to the data, the data is saved in tables, do not contain data. Reports provide information from database to users in an easy-to-understand format: display the output of tables or queries in a formatted manner. Odbc is a translator between access and another application that contains data that you might want to import. You can"t set up the relationships until you set up the tables. Data type: software assumes that first field is the primary key, ex: student id, ex: short text because you don"t add student numbers, ex: you want each id to be 9 numbers long, choose field size. Indexed: yes, no duplicate, means you can type in an )d and the )d can"t be inserted twice, ex: your laptop doesn"t let you have the same file name twice.
