Laserfiche WebLink
110 <br />CIT203: Database Students will learn the basic skills necessary to begin creating and working with databases. <br />Applications I This structured course will enable students to create tables, queries, forms, reports and <br />databases. A database is a tool for collecting and organizing information. For example, as a <br />database, a phone book organizes a large amount of data —names, addresses, and phone <br />numbers —so you can access it by name in alphabetic order. Even a grocery list is a simple <br />type of database. A computerized database management system (DBMS), such as Microsoft <br />Office Access, enables you to easily collect large volumes of data organized into categories <br />of related information. This type of database allows you to store, organize, and manage <br />your data, no matter how complex it is, and then retrieve and present it in various formats <br />and reports. Organizing data by using a DBMS gives you the power to manipulate, view and <br />report the data in ways that other applications like spreadsheets and word processing <br />documents cannot. For example, a spreadsheet application like Microsoft Excel has its own <br />unique purpose to store, analyze and report data using tools unique to it; however, Access <br />is the better choice to perform various management functions on data such as asking it <br />complex questions and creating structures to input and report it using standardized <br />business structures which you'll learn throughout this course. Topics include: <br />• Explain database concepts and terminology <br />• Create and design data tables <br />• Demonstrate how to modify data tables <br />• Create calculated fields <br />• Describe how to view data from more than one field <br />Prerequisite: None <br />Last Revision Date on <br />