Save @ AMU
$0
Application Fee
$0
Transfer Credit Evaluation
$0
Textbooks & eBooks
72%Have Graduated with No APUS-incurred Student Loan Debt1
About This Program
Study how to develop effective entity relationship diagrams, database models, databases, table structures, and graphical user interfaces (GUIs) with the Microsoft Access database applications undergraduate certificate from American Military University (AMU).
The Microsoft Access courses in this online program will help you:
- Learn database development theories and data integrity concepts and principles
- Use Structured Query Language (SQL) to interact with databases, according to American National Standards Institute (ANSI) standards
Microsoft Access database application classes taught in this program are a useful way to increase your knowledge without committing to a full degree.
What You Will Do
- Study hierarchical, network, relational, and object-relational database models
- Learn how to develop entity diagrams, design databases, create database applications, manage databases, implement data integrity, ensure information security, and implement transaction processing
- Comprehend the impact and issues related to relational databases, entity diagrams, and PL/SQL on IT management, enterprise applications, and global ecommerce
- Become familiar with the need, objective, and principles of normalization for creating databases
- Enhance your knowledge of the concepts and principles of data integrity (including referential integrity and transactional integrity) for relational database design
Program at a Glance
Number of Credits
18
Cost Per Credit
$285 | $250*
Courses Start Monthly
Online
Program Requirements Printable Catalog Version
Must take all courses for this section.
Course ID: 2618
|
This course focuses on the role, function, and operations of relational databases in the management of information. The course will be taught from a mixture of analytical and practical methods. This course introduces the student to the concepts of relational databases and to the principles of relational database design in the context of the Microsoft Access Relational Database Management System (RDBMS). Students will apply their knowledge of the principles of data design and database engineering to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation. They will examine the rudiments of referential integrity and normalization, and apply this knowledge to design the database tables that implement validation rules to ensure application integrity. They will also examine and develop advanced queries such as: top values, list of values, cross tab, find duplicates, and find unmatched. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. The book meets the topical requirements for the Microsoft Office Specialist (MOS). Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.
| Registration Dates | Course Dates | Session | Weeks |
|---|---|---|---|
| 05/21/21 - 10/29/21 | 11/01/21 - 12/26/21 | Fall 2021 Session I | 8 Week session |
| 07/27/21 - 12/31/21 | 01/03/22 - 02/27/22 | Winter 2022 Session B | 8 Week session |
| 09/28/21 - 03/04/22 | 03/07/22 - 05/01/22 | Winter 2022 Session D | 8 Week session |
Course ID: 2622
|
This course is an introduction to the concepts, management issues, and advantages of relational database management systems. Topics include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. This course examines database design, normalization for OLTP systems, Codd’s rules for OLTP systems, data integrity, database system functions (journaling, forward recovery, backward recovery), database security (authentication and authorization), and database administration. This course also explores distributed databases, Online Analytic Processing (OLAP) systems, data warehouses, and object-oriented databases. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.
| Registration Dates | Course Dates | Session | Weeks |
|---|---|---|---|
| 05/21/21 - 10/29/21 | 11/01/21 - 12/26/21 | Fall 2021 Session I | 8 Week session |
| 07/27/21 - 12/31/21 | 01/03/22 - 02/27/22 | Winter 2022 Session B | 8 Week session |
| 09/28/21 - 03/04/22 | 03/07/22 - 05/01/22 | Winter 2022 Session D | 8 Week session |
Course ID: 2627
|
This course focuses on developing Microsoft Access Switchboard applications; it includes: designing and building form and report interfaces, interfacing the Access database to a web page, building dynamic web pages, integrating Access with other Office applications such as Excel, building pivot tables and charts, categorizing the various types of join operations, examining the rudiments of the Visual Basic for Applications (VBA) code, debugging VBA code, creating macros and functions, and designing Access applications. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.
Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.
| Registration Dates | Course Dates | Session | Weeks |
|---|---|---|---|
| 05/21/21 - 10/29/21 | 11/01/21 - 12/26/21 | Fall 2021 Session I | 8 Week session |
| 07/27/21 - 12/31/21 | 01/03/22 - 02/27/22 | Winter 2022 Session B | 8 Week session |
| 09/28/21 - 03/04/22 | 03/07/22 - 05/01/22 | Winter 2022 Session D | 8 Week session |
Course ID: 2628
|
This course is a study and application of the MS Access VBA Programming; it takes you from using Access to programming with Access. This course translates ERD diagrams into database designs, examines the VBA programming model, converts macros to VBA code, delves into the rudiments of the Visual Basic for Application (VBA) language system, uses the VBA editor, uses VBA to connect to Access, utilizes VBA to perform DDL actions in Access, creates sub procedures, implements functions, handles errors, performs debugging, and utilizes the built-in functions. This course also includes implementing database access in Windows-based and Web-based solutions. This course also includes an examination of the Security Model in the context of Access and VBA. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.
Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.
| Registration Dates | Course Dates | Session | Weeks |
|---|---|---|---|
| 05/21/21 - 10/29/21 | 11/01/21 - 12/26/21 | Fall 2021 Session I | 8 Week session |
| 07/27/21 - 12/31/21 | 01/03/22 - 02/27/22 | Winter 2022 Session B | 8 Week session |
| 09/28/21 - 03/04/22 | 03/07/22 - 05/01/22 | Winter 2022 Session D | 8 Week session |
Course ID: 3288
|
This course provides a technical and organizational foundation for understanding the use and importance of information systems and information technology in today's management environment. This course covers the hardware, software, and infrastructure that support management information systems. Information and decision support systems, knowledge management and specialized information systems, database management systems, telecommunications, the Internet, Intranets, Extranets, and wireless networks will be examined. This course also covers systems development, e-commerce, and the ethical and societal impact of management information systems.
| Registration Dates | Course Dates | Session | Weeks |
|---|---|---|---|
| 05/21/21 - 10/29/21 | 11/01/21 - 12/26/21 | Fall 2021 Session I | 8 Week session |
| 06/28/21 - 12/03/21 | 12/06/21 - 01/30/22 | Fall 2021 Session D | 8 Week session |
| 07/27/21 - 12/31/21 | 01/03/22 - 02/27/22 | Winter 2022 Session B | 8 Week session |
| 08/31/21 - 02/04/22 | 02/07/22 - 04/03/22 | Winter 2022 Session I | 8 Week session |
| 09/28/21 - 03/04/22 | 03/07/22 - 05/01/22 | Winter 2022 Session D | 8 Week session |
| 10/26/21 - 04/01/22 | 04/04/22 - 05/29/22 | Spring 2022 Session B | 8 Week session |
Course ID: 2617
|
This course introduces students to Web site development through a combination of readings and hands-on development exercises. This course covers Markup Language and Site Development Essentials, HTML5 Coding, Cascading Style Sheets (CSS) and Graphical Elements, Hyperlinks, HTML Tables, Web Forms, Video, Audio and Image Techniques, Web Site Development for Business, and Web Site Publishing and Maintenance. Fundamentals of JavaScript programming are also introduced in this course. Students will need access to Microsoft Internet Explorer and Firefox. This software is not provided by the course material grant and must be purchased/provided by the student. To succeed in this course, students will also need basic computer knowledge such as creating files and folders, downloading and uploading files, creating zipped files, and working with text editor such as Notepad++.
| Registration Dates | Course Dates | Session | Weeks |
|---|---|---|---|
| 05/21/21 - 10/29/21 | 11/01/21 - 12/26/21 | Fall 2021 Session I | 8 Week session |
| 06/28/21 - 12/03/21 | 12/06/21 - 01/30/22 | Fall 2021 Session D | 8 Week session |
| 07/27/21 - 12/31/21 | 01/03/22 - 02/27/22 | Winter 2022 Session B | 8 Week session |
| 08/31/21 - 02/04/22 | 02/07/22 - 04/03/22 | Winter 2022 Session I | 8 Week session |
| 09/28/21 - 03/04/22 | 03/07/22 - 05/01/22 | Winter 2022 Session D | 8 Week session |
| 10/26/21 - 04/01/22 | 04/04/22 - 05/29/22 | Spring 2022 Session B | 8 Week session |
Admission Requirements
- All AMU undergraduate programs require a minimum of a high school diploma or equivalent (i.e., GED).
- Please read all undergraduate admission requirements before applying to this program and be prepared to submit the required documentation.
- There is no fee to complete the AMU admission application. View steps to apply.
Materials Cost
Technology fee: $65 per course | $0 for active-duty military, National Guard members, and Reservists.
Need Help?
Selecting the right program to meet your educational goals is a key step in ensuring a successful outcome. If you are unsure of which program to choose, or need more information, please contact an AMU admissions representative at 877-755-2787 or info@apus.edu.
Quality Education Should Be Affordable
So you can focus on the opportunities ahead, without the financial burden of more expensive schools who are not as invested in your success. Learn more about paying for school.
Consumer Information
Department of Education and State Disclosures
For information on costs, median debt, state licensure requirements and more, view the gainful employment disclosures and the program disclosures for Maryland residents.
1Alumni Graduated with No APUS-incurred Student Loan Debt As of December 31, 2020
Includes alumni who graduated with an associate, bachelor's, or master's degree from APUS. Student loan debt is defined as student loans and private education loans used for tuition, fees, living expenses, and book costs associated with courses taken at APUS. Many APUS students receive military tuition assistance and veterans education benefits, which are not student loan debt.
*Cost Per Credit Hour
To minimize out-of-pocket costs, U.S. active-duty servicemembers, their spouse/dependents, National Guard members, and Reservists receive a tuition grant that caps undergraduate, master's degree, and graduate certificate tuition at $250/credit hour. In addition, a university book grant provides no-cost textbooks and ebooks for all undergraduates and military-tuition-grant-eligible master’s-level students.
See all military student benefits.
