LEARNET ACADEMY, INC. (2) - Laserfiche WebLink

Home Browse Search

111 CIT204: Database Students will learn the skills necessary to effectively begin creating and working with Applications II databases. This structured course will enable students to create tables, queries, forms, reports and databases. A database is a tool for collecting and organizing information, For example, as a database, a phone bookorganizes a large amountofdata—names, addresses, and phone numbers —so you can access it by name in alphabetic order. Even a grocery list is a simple type of database. A computerized database management system (DBMS), such as Microsoft Office Access, enables you to easily collect large volumes of data organized into categories of related information. This type of database allows you to store, organize, and manage your data, no matter how complex it is, and then retrieve and present it in various formats and reports. Organizing data by using a DBMS gives you the power to manipulate, view and report the data in ways that other applications like spreadsheets and word processing documents cannot. For example, a spreadsheet application like Microsoft Excel has its own unique purpose to store, analyze and report data using tools unique to it; however, Access is the better choice to perform various management functions on data such as asking it complex questions and creating structures to input and report it using standardized business structures which you'll learn throughout this course. Upon completion, students will be able to: • Display Information with Reports • Effectively use Access queries, generate data forms and summarize group information • Perform database maintenance procedures including copying from one database to another and compacting a database. • Find Information in a Database • Report Layout Types • Create a Report with the Report Wizard • Add a Calculated Field to a Report Prerequisite: CIT203 must be taken before CIT204 Date on April 4, 2023