IT Training
Microsoft Office Access 2010 Level 1
Description
You will create and modify new databases and their various objects. You will also improve and customize tables, queries, forms and reports, and share Access data with other applications.
Upon successful completion of this course, students will be able to:
•identify the components of the Microsoft Access 2010 environment.
•identify the components of a database.
•organize data in tables.
•view data in tables.
•query a database.
•design forms.
•generate reports
•streamline data entry and maintain data integrity.
•join tables to retrieve data from unrelated tables.
•create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
•improve forms.
•customize reports to organize the displayed information and produce specific print layouts.
•share data between Access and other applications.
Course Outline
Lesson 1: Getting Started with Access 2010•Identify the Elements of the User Interface
•Identify the Tabs and Commands on the Ribbon
•Obtain Help in Access
Lesson 2: Identifying the Components of a Database
•Define Database Concepts
•Identify the Components of a Database
•Examine the Relational Database Design Process
Lesson 3: Organizing Data in Tables
•Create a Table
•Modify Table Data and Properties
•Create a Table Relationship
Lesson 4: Viewing Data in Tables
•Sort Records
•Filter Records
•View Data from Related Tables
Lesson 5: Querying a Database
•Create a Query
•Add Criteria to a Query
•Add a Calculated Field to a Query
•Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
•Create a Form
•View Data Using an Access Form
•Modify a Form
Lesson 7: Generating Reports
•View an Access Report
•Create a Report
•Add a Calculated Field to a Report
•Format the Controls in a Report
•Apply a Theme to a Report
•Prepare a Report for Print
Lesson 8: Controlling Data Entry
•Constrain Data Entry Using Field Properties
•Establish Data Entry Formats for Entering Field Values
•Create a List of Values for a Field
Lesson 9: Joining Tables
•Create Query Joins
•Join Tables with No Common Fields
•Relate Data Within a Table
Lesson 10: Creating Flexible Queries
•Set the Select Query Properties
•Retrieve Records Based on Input Criteria
•Create Action Queries
Lesson 11: Improving Forms
•Restrict Data Entry in Forms
•Organize Information with Tab Pages
•Add a Command Button to a Form
•Create a Subform
•Display a Summary of Data in a Form
•Change the Display of Data Conditionally
Lesson 12: Customizing Reports
•Organize Report Information
•Format Reports
•Control Report Pagination
•Summarize Report Information
•Add a Subreport to an Existing Report
•Create a Mailing Label Report
Lesson 13: Sharing Data Across Applications
•Import Data into Access
•Export Data to Text File Formats
•Export Access Data to Excel
•Create a Mail Merge
Audience
This course is designed for students who wish to learn basic to intermediate-level 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. This 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 introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.This course is suited for those using Access 2010 and will be taught using Access 2010.
College Credit, CEUs, PDUs and CDUs
When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.
College Credit through The University of Findlay
Select curriculum offered by Babbage Simmel is part of the accredited University of Findlay's undergraduate and graduate course catalogs. For questions please E-Mail: info@babsim.com or call 800-288-5937.
Continuing Education Units (CEUs)
Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, call us at 800-288-5937.
Professional Development Units (PDUs)
Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Babbage Simmel's provider number with PMI® is 1737. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 610-356-4600.
Continuing Development Units (CDUs)
CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 866-512-4422.
babsimLIVE live distance learning is hands-on, instructor-led training in real-time. The training is live and interactive. Using the latest technologies, babsimLIVE is an innovative solution for distance learning that makes it possible for students to attend one of our public classes without the need to travel.
Unlike other distance learning options, babsimLive brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Marble Cliff Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.
-
2300 W. 5th Avenue
Columbus, Ohio 43215-1003 -
Phone: (614) 481-6555
(800) 288-5937
Fax: (614) 481-6979 -
