Sign In   |   View Cart   |     |   Help
 
Print Course information
E-mail to a friend
Return to Course Catalog

Course Catalog > Career Certifications > Computer Applications > - Microsoft

Microsoft Access 2013 Certification Training  

This online Microsoft Access 2013 (MOS) course will prepare you for the Microsoft Office Specialist Certification Exam 77-424.

What you will learn

  • Understand database concepts and terminology
  • Use the Access interface
  • Become familiar with table views, queries, forms, reports, and macros and modules
  • Plan a database
  • Apply database design fundamentals
  • Practice within forms and use the Form Wizard
  • Generate reports and use the Report Wizard
  • Establish database relationships and table relationships
  • Work with queries, reports, and forms at an advanced level
  • Use macros
  • Complete the desktop application with the navigation form

How you will benefit

  • Become prepared for the Microsoft Office Specialist Certification Exam 77-424
  • Gain hands-on experience using Microsoft Access, which can be discussed with future employers or included on your resume
  • Improve your efficiency and productivity at the workplace by becoming better able to manage databases
  • Develop your Microsoft Office suite skills, which are necessary at any workplace

Requirements:

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • Windows 10 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Microsoft 2013 Office Suite (not included in enrollment).
  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online. Manuals are included as downloadable PDFs throughout the course.


Microsoft Access 2013 skills are important to have in any profession or workplace. From basic data entry, preparation of spreadsheets and budgets, and management of data including sales and inventory, developing a skill set working with Access will allow you to work independently and efficiently problem solve.

This online course will teach you the skills you need to work with Access 2013 and prepare you to take the Microsoft Office Specialist Certification Exam 77-424. The material is presented in a step-by-step manner and you will learn it by completing readings and hands-on exercises, in addition to watching video presentations. The course also includes quizzes and exams so that you can assess your skills at regular intervals.


  1. Quick Overview of the Access User Interface
    1. Access Ribbon
    2. Quick Access Toolbar
    3. Object Navigation Pane
    4. Access Work Surface
    5. Access Options Dialog Box
    6. Object Overview
    7. Process Overview
  2. Fundamentals
    1. Approaches to Database Design
    2. Gather Information
    3. A Few Words about Naming Conventions
    4. Exercise: Gathering Information
    5. Normalization
    6. Table Relationships
  3. Tables and Their Views
    1. Definition and Purpose
    2. Datasheet View
    3. Design View
  4. Tables
    1. Creating an Access Database
    2. Data Types
    3. Create a Table in Design View
  5. Queries
    1. Queries
    2. Select Queries
    3. Select Queries with Criteria
    4. Logical Operations
  6. Forms
    1. Forms
    2. One-Click Forms
    3. Form Wizard
  7. Reports
    1. Reports
    2. One-Click Report
    3. Report Wizard
  8. Optional: Databases and Access Terms
    1. "Database" Defined
    2. Databases vs Spreadsheets
    3. Questions to Ask When Deciding Whether to Use a Spreadsheet or a Database
    4. Access vs Excel
    5. Discussion Questions
    6. "Relational Database" Defined
    7. Terminology
    8. Observations
    9. "Relational Database Management System" (RDBMS) Defined
    10. Access Is an RDBMS
    11. Benefits and Limitations of Access
    12. Discussion Questions
  9. Relationships
    1. Review
    2. Referential Integrity
    3. Relationships
    4. A Few Words about Naming Conventions
  10. Queries
    1. Query Design View
    2. Review of Select Queries
    3. Review of Select Queries with Criteria
    4. Logical Operations
    5. Parameter Queries
    6. Action Queries
  11. Table Functions
    1. Importing Data
    2. Exporting Data
  12. Forms
    1. Design View
    2. Formatting
    3. Tab Order
  13. Reports/Design View
    1. Report Sections
    2. Adding a Report Header/Footer
    3. Adding a Logo to the Report Header
    4. Adding a Title to the Report Header
    5. Adding Fields to a Report
    6. Arranging Fields on a Report
    7. Resizing the Detail Section
    8. Eliminating Repeating Headings
    9. Grouping and Sorting
    10. Setting Properties on a Report
    11. Adding Record Counts
    12. Special Report Fields
    13. Controls
    14. Printing a Report
  14. Macros
    1. Macro Basics
    2. Running a Macro
  15. Completing the Desktop Application
    1. The Navigation Form
    2. Running Macros from a Navigation Form
    3. Setting the Navigation Form as the Default Form
    4. Splitting the Database
    5. Distributing the Front-end Database


Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

 

Microsoft Access 2013 Certification Training
Item: 202003CTP20760  
Class Dates: 7/1/2020 - 9/30/2020                                              Fee: $595.00
This is an on-demand Career Training Program Course offered by Ed2Go.  Class begins upon registration and completion of Student Enrollment Agreement in Ed2Go. Click on Course Title for complete course description.