Topic: PC Applications for Telecommunication: Access

Catalog description

In this course, the student will learn how to create and test macros that open forms and that preview reports and export reports. The student will create a menu form with command buttons as well as a menu form with an option group, which is an object that enables the student to make a selection by choosing the option button corresponding to the student choice. The student will also create and use user interface (UI) macros in forms. The student will be introduced to the database language called SQL (Structured Query Language) is a very important language for querying and updating databases. It is the closest thing to a universal database language, because the vast majority of database management systems, including Access, use it in some fashion. Although some users will be able to do all their queries through the query features of Access without ever using SQL, those in charge of administering and maintaining the database system should be familiar with this important language. The student can also use Access as an interface to other database management systems, such as SQL Server. Using or interfacing with SQL Server requires knowledge of SQL. Virtually every DBMS supports SQL.