Office Productivity Training – Microsoft Office 2013 Access Basic Series!

$49.00Add to cart

Description

This course provides students with the knowledge and skills create a new database, construct data tables, design forms and reports, and create queries.

Course Modules:

Module 01: Getting Started with Access

(Duration: 1h 19m )

  1. Workbook
  2. Topic A: Orientation to Microsoft Access
  3. Why Use a Database Application?
  4. Transform Data into Knowledge
  5. Using Access Instead of Excel
  6. Using Access Instead of Other Databases
  7. Demo 1-2: Launching Access and Opening a Database
  8. Access 2013 Window Components
  9. Demo 1-3: Navigating and Editing Data in Tables
  10. Forms and Views
  11. Record Navigation Bar
  12. Demo 1-4: Navigating and Editing Data in a Form
  13. The Capable Query
  14. A Query Join
  15. Demo 1-5: Using Queries
  16. Demo 1-6: Using Reports
  17. Demo 1-7: Exploring Access Ribbon Commands
  18. Topic B: Create a Simple Access Database
  19. Create a Simple Access Database
  20. Saving Options
  21. Initial Views
  22. Field Data Types
  23. Primary Key
  24. Object Names
  25. Demo 1-8: Creating a New Database
  26. Demo 1-9: Creating and Testing a Form
  27. Topic C: Get Help in Microsoft Access
  28. Access Help Window
  29. Demo 1-10: Getting Help in Access
  30. Lesson 01 Review
  31. Review Quiz (Number of attempts allowed: Unlimited)

Module 03: Querying a Database

(Duration: 1h 3 m )

  1. Workbook
  2. Topic A: Join Data from Different Tables in a Query
  3. Query Object Views
  4. Simple Query Wizard
  5. Types of Queries
  6. Demo 3-1: Creating a Query by Using the Query Wizard
  7. Using Query Design to Create a Query
  8. Types of Queries
  9. Demo 3-2: Creating a Query by Using Query Design
  10. Topic B: Sort and Filter Data in a Query
  11. Query Criteria
  12. A Comparison Operator
  13. Logical Operators
  14. Wildcards
  15. Like Operator Examples
  16. Demo 3-3: Filtering a Query Using a Comparison Operator
  17. Demo 3-4: Filtering a Query Using a Wildcard
  18. Zoom Dialog Box
  19. Demo 3-5: Filtering a Query Using a Date Range
  20. Topic C: Perform Calculations in a Query
  21. Calculations in a Query
  22. Demo 3-6: Performing Calculations
  23. Lesson 03 Review
  24. Review Quiz (Number of attempts allowed: Unlimited)

Module 05: Generating Reports

(Duration: 30 m )

  1. Workbook
  2. Topic A: Create a Report
  3. Report Creation Tools
  4. Report Object Views
  5. The Report Wizard
  6. Demo 5-1: Creating Reports
  7. Demo 5-2: Using the Report Wizard
  8. Topic B: Add Controls to a Report
  9. Sections in a Report
  10. The Completed Report
  11. Demo 5-3: Adjusting Report Control Layout
  12. Topic C: Enhance the Appearance of a Report
  13. Galleries and Themes
  14. Demo 5-4: Enhancing the Appearance of a Report
  15. Topic D: Prepare a Report for Print
  16. Page Setup Options
  17. Print Preview Tab
  18. Demo 5-5: Preparing a Report for Print
  19. Lesson 05 Review
  20. Review Quiz (Number of attempts allowed: Unlimited)

Module 02: Working with Table Data

(Duration: 1h 18m)

  1. Workbook
  2. Topic A: Modify Table Data
  3. Modify Table Data
  4. Demo 2-1: Undoing Record Modifications
  5. Quick Search
  6. Demo 2-2: Using Quick Search to Find and Modify Records
  7. Demo 2-3: Using Find and Replace to Modify Records
  8. Adding Calculations to the Totals Row
  9. Demo 2-4: Adding a Totals Row to a Datasheet
  10. Topic B: Sort and Filter Records
  11. Records in Ascending Order by Dept
  12. Filtering Records
  13. Demo 2-5: Sorting and Filtering Records
  14. Topic C: Create Lookups
  15. Table Relationship
  16. The Relationships View
  17. Foreign Keys
  18. Referential Integrity
  19. Demo 2-6: Examining the Purpose of a Primary Key
  20. The Property Sheet
  21. Demo 2-7: Configuring a Form Lookup Field
  22. Lesson 02 Review
  23. Review Quiz (Number of attempts allowed: Unlimited)

Module 04: Creating Advanced Queries

(Duration: 39 m)

  1. Workbook
  2. Topic A: Create Parameter Queries
  3. Create Parameter Queries
  4. Matching a Parameter Query
  5. Using the Ampersand Operator A Parameter Query Displays a Prompt
  6. Demo 4-1: Creating a Parameter Query
  7. Demo 4-2: Using Wildcards in a Parameter Query
  8. Demo 4-3: Creating a Query with Multiple Parameters
  9. Topic B: Create Action Queries
  10. Action Queries
  11. Action Query Update Expression
  12. Demo 4-4: Creating Action Queries
  13. Topic C: Create Unmatched and Duplicate Queries
  14. Find Unmatched and Find Duplicate Queries
  15. Demo 4-5: Creating Queries to Search for Unmatched and Duplicate Records
  16. Topic D: Summarize Data
  17. Crosstab Queries & Display Details
  18. Analyzing Country of Origin
  19. Demo 4-6: Creating a Crosstab Query
  20. Lesson 04 Review
  21. Review Quiz (Number of attempts allowed: Unlimited)

Module 06: Customizing the Access Environment

(Duration: 7 m)

  1. Workbook
  2. Topic A: The Access Options Dialog Box
  3. Access Options
  4. Demo 6-1: Setting Access Options
  5. Lesson 06 Review
  6. Course Closure
  7. Review Quiz (Number of attempts allowed: Unlimited)

This course includes

  • On-demand video
  • 6 downloadable Pdf Workbooks
  • Unlimited time access (During Membership)
  • Access on mobile and Desktop
  • Certificate of Completion

$49.00Add to cart

Course Features Include:

  • Expert Lectures
    Learn on-demand from top instructors who are industry subject matter experts. Our highly certified expert instructors possess a superior understanding of the subject matter in their fields and have the ability to convey this knowledge in an effective, engaging, and professional manner to a wide audience.

  • Certificates of Completion
    Upon completion of a series of courses you can earn a certificate of completion from Career Academy. Certificates of Completion will display your full name, course completed, as well as the date of completion. Students have the ability to print this out or save it digitally to showcase your accomplishment.

  • PowerPoint Visuals:
    Many of the in-depth theories and processes discussed in our courses can be learned most efficiently through the detailed PowerPoint slides presented. These visuals are accompanied by an instructor voice-over to provide our students with a clear, efficient, and complete presentation of concepts.

  • Professional Development Activities
    Students are provided access to professional development activity files which allow for an individual to test out course theories and apply the knowledge they earned from the course.

  • Review Quizzes
    Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.

  • Mobile Access
    With our universal course player, you can learn from your computer, tablet as well as mobile devices. Keep up with your training on the go!

Trusted by Aspiring IT Professionals, Corporations and
Government agencies
for more than a Decade

Get unlimited online access learn anywhere, anytime using your computer or mobile device!