Microsoft Access Proficiency Certificate
Microsoft Access is a popular stand-alone database management system. It offers tremendous capability to users who want to store large amounts of business data and need the capability to organize, update, and extract data, as well as create timely reports. Access offers one of the best reporting features of any database management system on the market. Extensive knowledge of this software program will increase your chances for a career with better pay and increased job security.
The Center for Continuing Education at Georgia Highlands College now offers a proficiency certificate in Microsoft Access for those adults who wish to become skilled in this application program. This certificate program is 36 hours in length, consisting of six 6-hour courses that must be completed within six months (6) of start. All courses must be completed before the certificate is awarded. The certificate requires that the following six (6) courses be taken: Access Level I, Access Level II, Access Level III, Access Level IV, and Access Visual Basic Application Level I and II. Details of the material covered in each course are on the following page.
In this certificate program, you will work with real-world examples and learn how this software program is used in the workplace. Each course is designed to improve your Access skills while meeting the standards in technology proficiency required by many companies. The prerequisite for this program is a working knowledge of the computer and of the Windows Operating System.
The courses for the certificate in 2014 are:
Access Required Courses (6)
- Level I
- Level II
- Level III
- Level IV
- VBA Level I
- VBA Level II
Access I – Beginning
For many novices, trying to create a database can be a challenge. In this course you will learn how to create and maintain a database using the database management system Access. Using Access wizards and design tools, you will create tables, forms, queries, and reports. You will learn how each of these objects can be utilized to efficiently manage your valuable information. Access is a great program for maintaining inventory records.
Prerequisite: Basic computer knowledge
Access II - Intermediate
You’ll learn the concepts of a relational database and use those concepts to build relationships between multiple tables in a single database. Creating relationships between the tables in your database will give you enormous functionality. You will also learn the advanced features of forms, queries, and reports which will provide you with additional ways to manage and analyze the data in your relational database. And you will learn to compact your database to insure that a minimal file size is marinated.
Prerequisite: Access I or equivalent knowledge
Access III - Advanced
In this course you will learn to work with the properties of the table object to control how data is entered into your tables. You will create a customized form view by moving and resizing control objects and modifying properties. You will use advanced query features to calculate statistical information. Advanced report features will be used to embed a sub-report in a main report and perform arithmetic calculations. You will utilize Macros to perform automated commands and create a simplified user interface, and also learn how to turn the Navigation Pane into a user interface.
Prerequisite: Access I & II or equivalent knowledge
Access Level IV – Advanced Queries using Microsoft SQL
In earlier Access classes, students learned to create a broad range of queries using Access’s graphical user interface, the Query Design View. This course will extend the student’s knowledge of query creation through the use of SQL, also known as Structured Query Language.
SQL is a computer language that uses ordinary English words such as SELECT, FROM, WHERE, and HAVING as keywords in its syntax. This course will utilize the specific syntax for querying within Microsoft Access. This syntax may differ in many instances from that used in Microsoft SQL Server, as well as that used in other vendor’s databases.
The ability to retrieve data in SQL is accomplished through the SELECT statement. The fundamentals of creating SELECT statements will be covered in detail, familiarizing the student with statement clauses, keywords, and special terms required to build a specific query. Each clause will be reviewed to understand its syntax and its order of placement within the overall statement. A variety of queries will be created to gain an understanding of options such as: sorting; grouping; combining query results; joining related data, creating calculated fields; using functions; and specifying criteria. The student will learn how to create Subqueries and Data-Definition Queries, both of which can only be created by using SQL. This course is a great lead-in to Visual Basic Application.
Prerequisite: Access I, II, and III
Access VBA I
Take your knowledge of Access to a higher level. Learn how Visual Basic Application (VBA) can be used to enhance the objects you already know how to build in Access; i.e., tables, forms, queries, reports, etc. VBA is a sub-set of the Visual Basic programming language that comes with Access. It lets you customize your objects to perform additional tasks other than those already built into Access. This course will introduce the student to the basic
fundamentals of VBA programming and cover the use of the VBA toolkit—the Visual Basic Editor, the Object Browser, and the Object Library. Students should have an advanced knowledge of creating objects within Access.
Prerequisite: Access I, II, and III or equivalent knowledge.
Access VBA II
In this course, the participants will learn how to use VBA programming to customize an Access form, create customized dialog boxes, drop-down menus, list and combo boxes, and create custom
functions in addition to those already in Access. How to test and debug VBA code will also be covered, as well as how to use VBA to integrate data from Access with Microsoft Word documents and
Microsoft Excel spreadsheets.
Prerequisite: Access VBA I or equivalent knowledge.