Data is of extremely limited value unless it can be quickly and easily sorted, searched, and linked to other data-tasks at which database management systems excel. This program takes viewers through the fundamentals of making and maintaining a database: creating a basic table structure, setting up relationships, creating a data capture form, formulating queries, setting up reports, and creating and running macros. Featured DBMSs include Oracle, DB2, Access, MySQL, 4D, and FileMaker Pro.
Data is of extremely limited value unless it can be quickly and easily sorted, searched, and linked to other data-tasks at which database management systems excel. This program takes viewers through the fundamentals of making and maintaining a database: creating a basic table structure, setting up relationships, creating a data capture form, formulating queries, setting up reports, and creating and running macros. Featured DBMSs include Oracle, DB2, Access, MySQL, 4D, and FileMaker Pro.
General Note
Encoded with permission for digital streaming by Infobase on June 03, 2009.
Learn360 is distributed by Infobase for Films for the Humanities & Sciences, Cambridge Educational, Meridian Education, and Shopware.
Content Note
Databases: Introduction (2:15) -- Database Demonstration: Building Tables (4:29) -- Database Relationships (5:16) -- Friendly Interface Forms and Reports (2:58) -- Database Tools: Queries, Switchboards, and Macros (4:35) -- Application of Database Management (5:10).