Loading

Microsoft Access 2010 - Revised 2017

Discover the features of Microsoft Access 2010 and learn how to use your databases more efficiently and effectively.

Software Tools
Free Course
This free online Microsoft Access course will teach you how to create your very own basic database system, as well as develop user-friendly applications. Microsoft Access is an essential software program used worldwide to build and run databases. With this course, you will see how flexible, adaptable, and useful this program can be. Enrol now and gain a strong overview of this vital program in just a few short hours.
  • Duration

    4-5 Hours
  • Assessment

    Yes
  • Certification

    Yes
  • Responsive

    Yes
  • Publisher

    Microsoft

Description

Modules

Outcome

Certification

View course modules

Description

This course will first teach you how to switch from older versions of Microsoft Access to Access 2010. You will then learn how to create and design a good database, starting with planning. You will study the different keys and data types and learn how to save, add, and navigate through your data. The course will also discuss how to create relationships within your tables that bring your data together. You will also learn how to extract meaningful information from your database using queries.

You will then learn how to create forms to make your database look more polished. The course will discuss how to create reports to represent your data visually as well as how to create, edit, and publish your database to the Microsoft SharePoint Server for online use. You will study the use of web browser controls to display web pages in an Access 2010 database as well as the keyboard shortcuts that you can use in Access that will help you to gain a quicker workflow.

There are a few computing tools in the modern world that everybody should learn how to use. Microsoft Access is one of them. By taking this course and getting up to speed on this highly useful program, you will transform your database management and make your database work much simpler. These are valuable skills that will really help your professional development. So, check out the course today and find the skills you're looking for. 

Start Course Now

Modules

Module 1 Making the Switch to Microsoft Access 2010

Module 2 Design and Create New Tables for a Database

Module 3 Create Relationships and Queries for a New Database

Module 4 Create Forms and Reports for a New Database

Module 5 Build and Publish Web Databases

Module 6 Access 2010 Keyboard Shortcuts

Course assessment

Learning Outcomes

Having Completed this course you will be able to:


  • Use database templates.
  • Plan for good design.
  • Learn about keys and data types. 
  • Create tables; Save add and navigate data.
  • Create relationships between tables.
  • Set referential integrity.
  • Create queries and lookup fields.
  • Learn about and create different types of forms in different ways.
  • Learn to work in layout view.
  • Create reports for your database.
  • Build and work with online databases.
  • Create and publish web databases.
  • Save a changed database to the web.
  • Learn keyboard shortcuts and access keys.
  • Learn to work with security protocols.

Certification

All Alison courses are free to enrol, study and complete. To successfully complete this Certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Certificate course, you have the option to acquire official Certification, which is a great way to share your achievement with the world. Your Alison Certification is:

Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning

Alison offers 3 types of Certification for completed Certificate courses:

Digital Certificate - a downloadable Certificate in PDF format, immediately available to you when you complete your purchase
Certificate - a physical version of your officially branded and security-marked Certificate, posted to you with FREE shipping
Framed Certificate - a physical version of your officially branded and security-marked Certificate in a stylish frame, posted to you with FREE shipping

All Certification is available to purchase through the Alison Shop. For more information on purchasing Alison Certification, please visit our faqs. If you decide not to purchase your Alison Certification, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Certification pricing, please visit our Pricing Page.

Careers

    Notification

    You have received a new notification

    Click here to view them all