Assignment
1. Complete and submit the Assignment
You are about to create an application to manage your CDs / DVDs collections at home/work. The application to keep track of the inventory (in/out), who borrowed what and when it is due back (no money transactions please), the system should be able to produce at least 3 reports such as inventory list, items due, most active user and most borrowed item.
What are the steps you are going to take to complete the development process. You should include a detail requirements (5 pages max, can be less), suggested design and ER diagram (you can use MS Word for the diagram)
SYLLABUS
I need week one help on what is specified above. I am doing forum and responses.
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. Prerequisites: INFO261 and INFO221
Course Scope
This is the third course in the MS-Access development courses that focuses on the concepts of relational databases using the Microsoft Access database. This course focuses on the VBA programming in MS Access. Students must install Microsoft Access 2013, available through Microsoft Academic Alliance - DreamSpark, on their computer.
Course Objectives
The successful student will fulfill the following learning objectives:
1. Discuss the features, functionality, power, and advantages of MS Access VBA that have made it a viable tool for developing Windows Based and Web Based database solutions.
2. Discuss the impact of Microsoft's Access on Information Technology Management and on Global Economies as it applies to developing, deploying, and managing database applications.
3. Examine the application development process in MS Access.
4. Examine the rudiments of the Visual Basic for Applications (VBA) language.
5. Differentiate between MS Access applications without VBA and MS Access applications with VBA.
6. Examine the VBA Programming Model.
7. Examine the architecture of the VBA Editor.
8. Evaluate the role of the Project Explorer in managing modules
9. Examine the impact of the Project Explorer on Information Technology Management and on Configuration Management.
10. Explain the security features provided in Access
11. Evaluate the Jet Sandbox and Macro Security features.
12. Apply your knowledge of the three Access courses (Introduction, Advanced, and Project) to build a database application.
Course Delivery Method
This course, delivered via distance learning, will enable students to complete academic work in a flexible manner completely online. Resources and access to an online learning management system will be made available to each student. Online assignments are due by the last day of each week and include Forum (Newsgroup) questions (accomplished in groups through a threaded Forum), examinations and quizzes (graded electronically), and individual assignments (submitted for review by the Faculty Member). Assigned faculty will support the students throughout this eight-week course.
Table of Contents
Resources
Friedrichsen, L. (2014). Microsoft Access 2013 Advanced, 1st Ed - The VitalSource e-book is provided via the APUS Bookstore within VitalSource Bookshelf. Cengage Learning. ISBN-13: 9781305450509
Software:
MS Access 2013 version of the software must be installed. MS Access 2013 and additional software are available free by Microsoft DreamSpark for students and faculty. Please visit the links by clicking on the button labeled "FreeSoftware" in the Sakai classroom.