Skip Navigation
 

INFO161 - Relational Databases with MS Access: Introduction

Course Details

Course Code: INFO161 Course ID: 2618 Credit Hours: 3 Level: Undergraduate

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.





Course Schedule

Registration Dates Course Dates Session Weeks
04/29/19 - 10/04/19 10/07/19 - 12/01/19 Fall 2019 Session B 8 Week session
05/27/19 - 11/01/19 11/04/19 - 12/29/19 Fall 2019 Session I 8 Week session
06/24/19 - 11/29/19 12/02/19 - 01/26/20 Fall 2019 Session D 8 Week session
07/29/19 - 01/03/20 01/06/20 - 03/01/20 Winter 2020 Session B 8 Week session
08/26/19 - 01/31/20 02/03/20 - 03/29/20 Winter 2020 Session I 8 Week session
09/30/19 - 02/28/20 03/02/20 - 04/26/20 Winter 2020 Session D 8 Week session

Current Syllabi

The successful student will fulfill the following learning objectives:

  1. Explore the history and evolution of databases.
  2. Differentiate between the hierarchical, network, and relational database models.
  3. Explain the architecture and the developing components of a relational database.
  4. Examine the process for database applications.
  5. Describe the role of database applications in Information Technology Management.
  6. Identify the principles of normalization.
  7. State the concept of cardinality of relationships between tables (relations).
  8. Analyze the concepts of primary key integrity, referential integrity, and transactional integrity.
  9. Define the rudiments of the Structured Query Language (SQL).
  10. Develop code that interacts with relational database.

Access Assignments

You will complete the assignments as directed in the textbook. The required data files are on the disk that comes with your text or on the companion website.

Participation Points

Classroom interaction is a vital part of the online experience. Valuable knowledge can be gained from understanding the experiences of other class participants. You will earn participation points for activity in the online discussion.

Forums

Each week one or more questions will be posted in the online discussion. Each student will provide at a minimum a 150-word response preferably no later than each Wednesday, to answer the online discussion questions. Additionally, you must provide a peer review of similar length in response to another student’s online discussion input. Your peer review will review/analyze an input and provides justification why you agree/disagree with the information in the student input. You must always be courteous (professional) even in disagreement. Submission of Assignments and Project Documents: Please include your name, course number (ex. INFO161), assignment name and due date at the top of your submissions. Make sure you follow a standard and consistent file naming convention, such as for example: INFO161_Assignment1_JohnSmith.docx. Then upload the assignment

Reflection Paper Assignment

  • Create a 3-5 page Word document, name it INFO161_ReflectionPaper_LastName_FirstName.docx
  • In this paper discuss the following:
    • any database experience you had before you took this course
    • what you learned in this class that you may apply in your current or future work
    • one way you could use databases for your daily activities
    • whether you liked working with databases - would you make a career as a database developer or administrator?
  • You do not need to support with citations but if you do follow APA style guidelines
  • The structure of your paper should must follow this example:
    • Page 1 - the title page - must only have the title of the paper, your name, course name and session, university name, instructor name, and the date you would be writing the paper
    • Page 2 to at least page 4 (or more up to 6) discuss the points described above
    • Page 5 (or more) - title it as "References" and include any reference you used for your citations in your discussion - following APA Style guidelines
  • Turnitin feature will be turned on in the assignment area to verify academic honesty

Weekly learning objective details from the textbook:

Week 1:

Create a new database:

1. Identify Good Database Design

2. Create a Table and Define Fields in a Blank Desktop Database

3. Change the Structure of Tables and Add a Second Table

4. Create a Query, Form, and Report

5. Close a Database and Exit Access

Week 2:

Create a database from a template

6. Use a Template to Create a Database

7. Organize Objects in the Navigation Pane

8. Create a New Table in a Database Created with a Template

9. Print a Report and a Table

Week 3:

Create a new database & create a database from a template – Applicability perspective

1. Identify Good Database Design

2. Create a Table and Define Fields in a Blank Desktop Database

3. Change the Structure of Tables and Add a Second Table

4. Create a Query, Form, and Report

5. Close a Database and Exit Access

6. Use a Template to Create a Database

7. Organize Objects in the Navigation Pane

8. Create a New Table in a Database Created with a Template

9. Print a Report and a Table

Week 4:

Sort and query a database

1. Open and Save an Existing Database

2. Create Table Relationships

3. Sort Records in a Table

4. Create a Query in Design View

5. Create a New Query from an Existing Query

6. Sort Query Results

7. Specify Criteria in a Query

Week 5:

Create complex queries.

8. Specify Numeric Criteria in a Query

9. Use Compound Criteria in a Query

10. Create a Query Based on More Than One Table

11. Use Wildcards in a Query

12. Create Calculated Fields in a Query

13. Calculate Statistics and Group Data in a Query

14. Create a Crosstab Query

15. Create a Parameter Query

Week 6:

Create forms to enter and delete records and to display data in a database.

1. Create and Use a Form to Add and Delete Records

2. Filter Records

3. Create a Form by Using the Form Wizard

4. Modify a Form in Layout View and in Design View

Week 7:

Create reports to display database information.

5. Create a Report by Using the Report Tool and Modify the Report in Layout View

6. Create a Report by Using the Report Wizard

7. Modify the Design of a Report

8. Keep Grouped Data Together in a Printed Report

Week 8:

Apply skills mastered to create forms and reports for database data entry, manipulation, and display.

1. Create and Use a Form to Add and Delete Records

2. Filter Records

3. Create a Form by Using the Form Wizard

4. Modify a Form in Layout View and in Design View

5. Create a Report by Using the Report Tool and Modify the Report in Layout View

6. Create a Report by Using the Report Wizard

7. Modify the Design of a Report

8. Keep Grouped Data Together in a Printed Report

NameGrade %
Forum 16.00 %
Week 1 Forum 2.00 %
Week 2 Forum 2.00 %
Week 3 Forum 2.00 %
Week 4 Forum 2.00 %
Week 5 Forum 2.00 %
Week 6 Forum 2.00 %
Week 7 Forum 2.00 %
Week 8 Forum 2.00 %
Assignments 80.00 %
Assignment 1 (Wk2) 16.00 %
Assignment 2 (Wk4) 16.00 %
Assignment 3 (Wk5) 16.00 %
Assignment 4 (Wk6) 16.00 %
Assignment 5 (Wk8) 16.00 %
Final Assignment 4.00 %
Reflection Paper (Wk8) 4.00 %

Software Requirements

  • Microsoft Word 2003 or later or any word processor with the ability to export a *.txt file.
Book Title:GO! with Office 2013 Volume 1 (custom) - the VitalSource e-book is provided inside the classroom
ISBN:INFO161 - NA
Publication Info:VS-Pearson
Author:Gaskin
Electronic ISBN:9781323020517
Electronic Unit Cost:$37.80
Book Title:Microsoft Access 2013 - software and lessons available inside the classroom
ISBN:132308875X
Publication Info:CLASS-Pearson
Electronic ISBN:132308875X
Electronic Unit Cost:$10.80

Previous Syllabi

Not current for future courses.