Skip Navigation
 

INFO261 - Relational Databases with MS Access: Advanced

Course Details

Course Code: INFO261 Course ID: 2627 Credit Hours: 3 Level: Undergraduate

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.





Course Schedule

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

Current Syllabi

The successful student will fulfill the following learning objectives: 1. Appraise the principles for enhancing the man-machine interface. 2. Evaluate the role of human factors in form design. 3. Assess the concept of Domain Aggregation and its impact on application quality. 4. Assess the functionality and benefits of queries. 5. Examine the impact of queries on the efficiency of the man-machine interface. 6. Describe the impact of table relationships on data integrity. 7. Demonstrate the process of creating a switchboard like application. 8. Examine the rudiments of the Visual Basic for Applications (VBA) language. 9. Create Visual Basic for Applications code to perform database actions. 10. Appraise the correlation between security and data integrity in the context of relational databases.

Access Assignments

You will complete the assignments as directed in the classroom. 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.

I monitor the forum for participation so there is no reason for you to submit your comments and peer reviews as separate assignments.

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 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 Textbook Assignments and Project Documents

Please include your name, course number (ex. INFO261), Student ID, assignment name and due date at the top of your submissions. Upload assignment.

Weekly learning objective details:

Week 1: A database is the computer equivalent of an organized list of information. Tables are the core database objects. Access data is organized in tables made up of columns and rows, called fields and records. In a relational database, tables can be related based on common fields, enabling the retrieval of information from more than one table at the same time. The purpose of the other database objects—forms, reports, queries, macros, and modules—is to interact with one or more tables. Every Access object has two or more views. For example, you view data in a table in Datasheet view and define how the data is structured in Design view. If you want to print a database object, be sure the information you need is visible on the screen before you print

Week 2: Access 2013 includes templates to help you create databases and application parts to help you add related tables and other database objects. Rather than storing all information in one table, you can create different tables for each type of information, such as customers, orders, and suppliers. You can create a simple table structure by entering data and naming fields in Datasheet view. You can also set the data type and certain properties. You can manipulate or hide columns and rows without affecting the data. In Design view, you can modify any table, whether you created it manually or as part of a template. Data types and properties determine what data can be entered in a field, and how the data will look on the screen. Caution: changing some properties might affect the data. You can create a relationship between the primary key field of one table and the foreign key field of another so that you can combine information from both tables

Week 3: The quickest way to create a form that includes all the fields from one table is by using the Form tool. You can then use the form to view and enter records. A form that is based on a table is bound to that form. The table is called the record source. By default, the form displays one text box control and its associated label control for each field in the table each text box control is bound to its field, which is called the control source. Each control has several properties that you can change in Layout view or Design view to improve the look and layout of the form.

Week 4: You can sort a table in either ascending or descending order, based on the values in any field (or combination of fields). You can filter a table so that information containing a combination of characters is displayed (or excluded from the display). You can apply another filter to the results of the previous one to further refine your search. The Filter by Form command filters a table or form based on the information in several fields. You can use the Advanced Filter/Sort command to search a single table for records that meet multiple criteria

Week 5: You can create a report that displays only some of the fields in a table by using the Report wizard. The report can be sorted and grouped to summarize the data in a table in a meaningful way. You can refine a report in Layout view by manipulating its controls and setting its properties. You can also format the controls to structure and highlight data. In Print Preview, you can see how the report will look when printed and make adjustments before you print.

Week 6: The Data Type setting restricts the data that can be entered into an Access database to a specific type. The Field Size property for the Text, Number, and AutoNumber data types restricts the number of characters allowed in a Text field or the number of digits allowed in a Number or AutoNumber field. The Input Mask property controls the format in which data can be entered. You can use a validation rule to precisely define acceptable data. Access tests entries against the rule and rejects any that don't comply.

Week 7: Forms have three main sections: Form Header, Detail, and Form Footer. You can size them to suit the needs of the form. You can customize any section of your form's layout by adding and deleting labels, moving labels and text box controls, and adding graphics. After you define a relationship between tables, you can add subforms to your forms. You can create forms to send in Outlook e-mail and automatically update an Access database with the responses.

Week 8: You can create a query by using a wizard or by using the Query Designer. Queries can use aggregate functions such as SUM and AVG to summarize data. You can design queries that perform calculations on matched data. An update query performs an updating action on its results, such as replacing the contents of a field. A delete query deletes records that meet specific criteria. Use caution with this type of query; the effects can be far reaching, and you can't recover deleted records.

NameGrade %
Forum 16.00 %
Week 1 4.00 %
Week 3 4.00 %
Week 5 4.00 %
Week 7 4.00 %
Assignment 1 4.00 %
Week 1 Assignment 4.00 %
Assignments 2-7 30.00 %
Week 2 Assignment 5.00 %
Week 3 Assignment 5.00 %
Week 4 Assignment 5.00 %
Week 5 Assignment 5.00 %
Week 6 Assignment 5.00 %
Week 7 Assignment 5.00 %
Activites 8 20.00 %
Week 8 Project/Reflection 20.00 %
Essay 10.00 %
Week 6 Essay 10.00 %
Exams 20.00 %
Midterm 10.00 %
Final 10.00 %

Software Requirements

  • Microsoft Access 2013
  • Microsoft Word 2003 or later or any word processor with the ability to export a *.txt file.
Book Title:Microsoft Access 2013 Step By Step - eBook available via the APUS Online Library.
ISBN:9780735669086
Publication Info:Microsoft Press
Author:Cox, Joyce
Unit Cost:$21.83
Book Title:To find the library e-book(s) req'd for your course, please visit http://apus.libguides.com/er.php to locate the eReserve by course #. You must be logged in to eCampus first to access the links.
Author: No Author Specified
Book Title:Students must have access to the required software. APUS does not supply this software. The listing can be found at https://apus.libguides.com/c.php?g=241438&p=3514444
Author: No Author Specified

Previous Syllabi

Not current for future courses.