What you'll learn in this access class:You will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access 2007 relational database application.
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.Students will receive a Certificate of Completion at the end of this course and may retake the same course as many times as they want.Upon successful completion of this course, students will be able to:examine the basic database concepts and explore the Microsoft Office Access 2007 environmentdesign a simple databasebuild a new database with related tablesmanage the data in a tablequery a database using different methodsdesign formsgenerate reportsPrerequisite: Students should have a basic understanding of Windows, including how to use files and folders.The Course Curriculum for Microsoft Access 2007 Level 1:Lesson 1: Exploring the Microsoft Office Access 2007 EnvironmentTopic 1A: Examine Database ConceptsTopic 1B: Explore the User InterfaceTopic 1C: Use an Existing Access DatabaseTopic 1D: Customize the Access EnvironmentTopic 1E: Obtain HelpLesson 2: Designing a DatabaseTopic 2A: Describe the Relational Database Design ProcessTopic 2B: Define Database PurposeTopic 2C: Review Existing DataTopic 2D: Determine FieldsTopic 2E: Group Fields into TablesTopic 2F: Normalize DataTopic 2G: Designate Primary and Foreign KeysTopic 2H: Determine Table RelationshipsLesson 3: Building a DatabaseTopic 3A: Create a New DatabaseTopic 3B: Create a TableTopic 3C: Manage TablesTopic 3D: Create a Table RelationshipTopic 3E: Save a Database as a Previous VersionLesson 4: Managing Data in a TableTopic 4A: Modify Table DataTopic 4B: Sort RecordsTopic 4C: Work with SubdatasheetsLesson 5: Querying a DatabaseTopic 5A: Filter RecordsTopic 5B: Create a QueryTopic 5C: Add Criteria to a QueryTopic 5D: Add a Calculated Field to a QueryTopic 5E: Perform Calculations on a Record GroupingLesson 6: Designing FormsTopic 6A: View Data Using an Access FormTopic 6B: Create a FormTopic 6C: Modify the Design of a FormLesson 7: Generating ReportsTopic 7A: View an Access ReportTopic 7B: Create a ReportTopic 7C: Add a Custom Calculated Field to a ReportTopic 7D: Format the Controls in a ReportTopic 7E: Apply an AutoFormat Style to a ReportTopic 7F: Prepare a Report for Print