Online Class: Microsoft Access 2013

Transform your data management skills with Microsoft Access 2013, designed for seamless data storage, reporting, and analysis. Our course unpacks Access's complexities, guiding you from foundational concepts to advanced functionality with clear instructions and supportive multimedia resources.
COURSE CLOSED
We're sorry, this course is no longer open for enrollment.
 
  • 21
    Lessons
  • 23
    Exams &
    Assignments
  • 10
    Hours
    average time
  • 1.0
    CEUs
 
 
 

Course Description

Microsoft Access 2013 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data. It can be the back-end of a business, keeping your records for you.

It is this course's purpose to teach you the important features of Access 2013 and how to use them. This course is designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it like a pro. Once we cover the basics, we'll move on to advanced features. If you've used Access before, perhaps previous versions, the first few lessons will be a refresher and introduce you to some of the updates you'll encounter in the newest version of Microsoft Access.

You'll learn:

· All about databases and how they work

· An understanding of how Access works to make even its complex inner workings seem simple

· How to navigate Access

· How to create tables, forms, reports, and queries

· How to enter criteria into your data

· How to form expressions and create functions

· How to customize the appearance of forms and reports

· How to use Access for home-record keeping or for a business

And much, much more.

If you're not familiar with Access 2013, it can be overwhelming. The program is large and navigating it without any help or experience can seem impossible. This course takes its time and shows you around Access. We'll break everything down into small chunks so that Access 2013 is just as easy for the beginner to use as it is someone who's been using it for years. With step-by-step written directions, screenshots of every procedure, and HD Video tutorials, you'll have no problems learning this program! And if you've used Access before, don't worry. We have plenty of updates to show you – and a few more things to teach you as well. So join us today!

Courses Frequently Bought Together:
  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 
 

Course Lessons

Lesson 1. The Essential Guide to Access 2013

Advanced features like reports, macros, and modules in Access 2013 allow users to translate raw data into actionable insights and automate routine tasks. Incorporating sophisticated VBA-driven modules enables custom database functionalities, enhancing operational efficiency and strategic decision-making. 7 Total Points
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete Assignment: Motives for Taking this Course
  • Assessment: Lesson 1 Exam

Lesson 2. Step-by-Step Guide to Access 2013 Installation

To utilize Microsoft Access 2013 proficiently, users must ensure their systems meet specific criteria like having Windows XP with SP3 and at least 2GB of disk space. The guide also highlights the significance of understanding Access's expansive database and object handling features, vital for tackling complex data-driven projects. 5 Total Points
  • Lesson 2 Video
  • Assessment: Lesson 2 Exam

Lesson 3. Unlocking the Power of Databases

Databases create structured digital environments where data is organized into interconnected tables, allowing for seamless information management akin to a well-designed spreadsheet. Understanding concepts like primary and foreign keys, along with normalization, ensures that your data remains accurate, accessible, and scalable. 5 Total Points
  • Lesson 3 Video
  • Assessment: Lesson 3 Exam

Lesson 4. Exploring the Core of Access 2013 Database Tools

Macros in Access 2013 automate repetitive processes, enabling users to focus on strategic tasks. By unlocking enhanced efficiency through automation, macros boost productivity, allowing seamless integration of data operations. 5 Total Points
  • Lesson 4 Video
  • Assessment: Lesson 4 Exam

Lesson 5. Navigating Your Data World with MS Access

Exploring the Access interface is akin to uncovering a treasure trove of tools essential for data organization and retrieval. From creating sophisticated tables and queries to importing data seamlessly, each tab within the Ribbon offers robust capabilities that elevate your data management skills. 5 Total Points
  • Lesson 5 Video
  • Assessment: Lesson 5 Exam

Lesson 6. Designing Efficient Databases: From Creation to Innovation

Craft databases with Microsoft Access that turn raw information into meaningful insights, driving productivity and innovation. By mastering table creation and relationship building, you unlock the full potential of data in business intelligence. 6 Total Points
  • Lesson 6 Video
  • Assessment: Lesson 6 Exam

Lesson 7. Mastering Views in Access

In Microsoft Access, object views provide distinct interfaces for interacting with and managing database structures and data. Understanding and mastering these views empower users to customize their database usage for tasks such as data entry, querying, and reporting. 5 Total Points
  • Lesson 7 Video
  • Assessment: Lesson 7 Exam

Lesson 8. Form Fundamentals: Navigating Microsoft Access

Creating forms in Microsoft Access involves a strategic blend of function, design, and navigation, allowing data manipulation through simple or complex interfaces. The software supports relational databases by making information clear and accessible, facilitated by features like automated subdatasheets. 5 Total Points
  • Lesson 8 Video
  • Assessment: Lesson 8 Exam

Lesson 9. Mastering the Art of Form Controls and Formatting

Modern database tools like Access provide advanced capabilities to customize and navigate form layouts, allowing users to position controls for improved user interaction. Optimization of controls through resizing and efficient layout management results in dynamic and impactful database presentations. 5 Total Points
  • Lesson 9 Video
  • Assessment: Lesson 9 Exam

Lesson 10. Delving Deep into Microsoft Access: Transformative Query Techniques

Queries in Microsoft Access are versatile tools that simplify data management by allowing users to filter, calculate, summarize, and automate data operations efficiently. This lesson explores various query types, empowering users to draw deep insights and maintain optimal data integrity. 8 Total Points
  • Lesson 10 Video
  • Assessment: Lesson 10 Exam

Lesson 11. Mastering Criteria and Wildcards for Data Insights

Operators in Microsoft Access include mathematical, comparison, logical, text, and special types, helping perform complex computations and comparisons on data. Mastery of operators empowers users to effectively manage data, carry out effective data excavations, and refine datasets. 5 Total Points
  • Lesson 11 Video
  • Assessment: Lesson 11 Exam

Lesson 12. Parameter Queries: Unleashing the Power of Flexible Data Searches

Creating a parameter query in Access involves selecting a query, moving to Design View, defining criteria through user prompts, and adjusting variables as needed to tailor data retrieval. Utilizing these steps allows for a seamless, dynamic query process, empowering users to manage and analyze data efficiently. 3 Total Points
  • Lesson 12 Video
  • Assessment: Lesson 12 Exam

Lesson 13. Mastering Database Relationships in Microsoft Access: A Comprehensive Guide

Understanding relationships in Microsoft Access is key to unleashing the potential of organized data, allowing for seamless connections between tables. Complex queries and informed decisions become achievable through mastering one-to-many, many-to-many, and one-to-one relationships and utilizing joins. 5 Total Points
  • Lesson 13 Video
  • Assessment: Lesson 13 Exam

Lesson 14. Unlocking Data Efficiency through Normalization

Normalization serves as a foundational framework for structuring databases to avoid redundancy and promote data integrity. It involves adhering to multiple normal forms to improve data management efficiency and enable performance enhancements through strategic denormalization. 5 Total Points
  • Lesson 14 Video
  • Assessment: Lesson 14 Exam

Lesson 15. Mastering Calculated Expressions for Data Insight

Calculated expressions in Access 2013 offer a transformative approach to database management, allowing for the execution of dynamic calculations, data validation, and automation that elevate user control and precision. These tools integrate effortlessly with existing data structures, facilitating advanced query criteria, default value settings, and real-time updates. 5 Total Points
  • Lesson 15 Video
  • Assessment: Lesson 15 Exam

Lesson 16. Unlocking the Power: A Comprehensive Guide to Aggregate Queries

Aggregate queries in data analysis allow efficient extraction of insights by summarizing data, vital in fields like finance and healthcare. Using tools like Microsoft Access, users can design queries to derive statistics and improve decision-making. 3 Total Points
  • Lesson 16 Video
  • Assessment: Lesson 16 Exam

Lesson 17. Access 2013 Report Mastery

Access 2013's report creation transforms raw data into compelling stories using the Report Tool for quick visualizations and the Report Wizard for detailed customization. By mastering these tools, users can produce professional reports that enhance decision-making and stimulate growth. 4 Total Points
  • Lesson 17 Video
  • Assessment: Lesson 17 Exam

Lesson 18. The Art of Crafting Compelling Reports

Incorporate colors, readable fonts, and visuals to set moods, emphasize insights, and simplify complex data. Embrace whitespace to declutter, creating a seamless reading experience that captivates and informs. 5 Total Points
  • Lesson 18 Video
  • Assessment: Lesson 18 Exam

Lesson 19. Clarity Through Grouping and Sorting

Conditional formatting utilizes visual cues to prioritize critical data, like highlighting high prices in red to signify urgency. This method draws immediate attention to trends and outliers, turning a simple report into a dynamic tool for targeted analysis and prompt actions. 3 Total Points
  • Lesson 19 Video
  • Assessment: Lesson 19 Exam

Lesson 20. Practical Tips for Printing and Exporting in Access 2013

Access 2013 reporting functionalities embrace customization through diverse export options, from Excel to PDFs, preserving design integrity. The lesson demystifies print orientations and margins, enabling aesthetically pleasing and fully accessible reports. 6 Total Points
  • Lesson 20 Video
  • Assessment: Lesson 20 Exam

Lesson 21. Importing and Exporting Data

In this lesson, we're going to learn the multiple ways that you can import and export data to and from Access. 79 Total Points
  • Lesson 21 Video
  • Lesson discussions: What do you think about this course?; Program Evaluation Follow-up Survey (End of Course); Course Comments
  • Assessment: Lesson 21 Exam
  • Assessment: Final Exam
179
Total Course Points
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe databases and design.
  • Identify database objects.
  • Demonstrate navigating, creating a database, and adding tables in Access 2013.
  • Describe object views.
  • Demonstrate creating simple forms.
  • Demonstrate using controls and formatting forms.
  • Demonstrate creating queries and using criteria, operators and wildcards in Access 2013
  • Demonstrate creating and using parameter queries.
  • Describe relationships.
  • Describe normalization.
  • Demonstrate creating calculated expressions.
  • Demonstrate summarizing data and creating reports.
  • Demonstrate printing and exporting reports.
  • Summarize importing and exporting data in Access 2013.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 

Student Testimonials

  • "What was most helpful was setting up tables and linking them in Queries and reports." -- Tony W.
  • "What was most helpful was the part on creating reports and forms. As a beginner, it was quite easy to follow along with the steps." -- Dionne K.

Related Courses