Microsoft Office Access 2003, Pasewark and Pasewark, Sandra Cable ISBN: 0-619-18355-1 © 2005 Publish date: September 3, 2004 472 pages and at least two 3 ½ “ floppy disks, I recommend a jump/flash drive or USB drive.1. Lectures/Demonstrations: The first half of each class is used to highlight the important material within each unit using interactive discussions, group work, handouts, and computer demos.2. Labs: The last half of each class is dedicated to hands-on learning, facilitated by the instructor. You will work at your own pace during this portion of the class to solidify the lesson material or to begin work on the weekly projects.3. Projects: I anticipate that each project and activity from the end of the unit discussed during that week will be assigned.4. Quizzes: Unannounced quizzes, if missed without being excused, are not available for make up.MiSU-BOTTINEAUCourse OutlineName of instructor: Russ GagnonCourse Title and Number: BOTE 257—DATABASE MANAGEMENTCredits: 3 Prerequisite: NoneCourse Description: Acquaints students with database design including data entry, storage and retrieval.Required Text: Microsoft Office Access 2003, Pasewark and Pasewark, Sandra Cable ISBN:0-619-18355-1 © 2005 Publish date: September 3, 2004 472 pages and at least two 3 ½ “ floppy disks, I recommend a jump/flash drive or USB drive.Course Objectives: MSU-B General Ed goals 1,2,3,4, and 9 apply throughout these objectives, at the end of the course, the student will be able to: create and manage information using computer technology.demonstrate the ability to organize, distribute and store information using database software. demonstrate the ability to apply concepts learned to independent challenge problems.demonstrate the ability to interpret and synthesize information resulting in problem solutions.demonstrate a working knowledge of database software. integrate database records with other business documents correctly and accurately.Course Content: This course is a complete overview of Microsoft Access 2003. In these seventeen units, you will learn how to plan and create databases which includes using and designing tables, queries, forms, and reports. You’ll also work with data import and export features as well as data access pages, Web pages that can be used to enter or report dynamic information from an Access database. You'll be introduced to relational database concepts, and you'll build and modify table relationships. In the second half of the class you'll work with relational databases and the first five Access object types (tables, queries, forms, reports, and pages) at a deeper level. You'll also be introduced to macros which are used to automate repetitive actions, and modules which are used to store VBA (Visual Basic for Applications) programming code. The course concludes with a unit on database management activities that affect database security and performance.Course Requirements and Evaluation: GRADING: Assignments, quizzes, and tests are computed for total points.90-100= A 80-89=B 75-79=C 65-74=D below 65=FMSU – BOTTINEAUCOURSE SYLLABUSBOTE 257—DATABASE MANAGEMENTInstructor: Mr. Russ GagnonOffice: Administration Building Room 152Office Hours: By appointment pleasePhone: Office 858-4340, Home: 852-3463 before 9 p.m.E-mail: [email protected] Description: This course is a complete overview of Microsoft Access 2003. In these seventeen units, you will learn how to plan and create databases which includes using and designing tables, queries, forms, and reports. You’ll also work with data import and export features as well as data access pages, Web pages that can be used to enter or report dynamic information from an Access database. You'll be introduced to relational database concepts, and you'll build and modify table relationships. In the second half of the class you'll work with relational databases and the first five Access object types (tables, queries, forms, reports, and pages) at a deeper level. You'll also be introduced to macros which are used to automate repetitive actions, and modules which are used to store VBA (Visual Basic for Applications) programming code. The course concludes with a unit on database management activities that affect database security and performance.Text/Materials:Microsoft Office Access 2003, Pasewark and Pasewark, Sandra Cable ISBN: 0-619-18355-1 © 2005 Publish date: September 3, 2004 472 pages and at least two 3 ½ “ floppy disks, I recommend a jump/flash drive or USB drive.Teaching Methods:1. Lectures/Demonstrations: The first half of each class is used to highlight the important materialwithin each unit using interactive discussions, group work, handouts, and computer demos. 2. Labs: The last half of each class is dedicated to hands-on learning, facilitated by the instructor. You will work at your own pace during this portion of the class to solidify the lesson material or to begin work on the weekly projects.3. Projects: I anticipate that each project and activity from the end of the unit discussed during that week will be assigned.4. Quizzes: Unannounced quizzes, if missed without being excused, are not available for make up.Course Policies:Missed Classes: Attendance is expected. Unannounced quizzes and class projects can be made-up only when students are excused by the instructor prior to class. You are responsible for the activities of each class period. If you know of a conflict ahead of time, you are welcome to submit projects early.Assignments: All assignments are due at the beginning of class on the date due unless specifiedprior. Late assignments receive one-half credit minus errors and must be turned in before the final. Make sure your name, and exercise number appear in the upper-right corner. If an exercise has multiple sheets, then staple them together. Disorganized assignments (pages out oforder, mislabeled, unreadable, etc.) will be penalized. If there are multiple sheets to be handed in, sequence them according to the order you were told to print them in the exercise instructions.Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and/or expulsion from the university. For more information, refer to the "Academic Dishonesty" policy in the university catalog.Need for Assistance: If you have any condition, such as a physical or learning disability, for which you need