Alison Logo

Microsoft Access 2010

certifcate icon
Microsoft Access 2010
  • Description
  • Outcome
  • Certification
  • Microsoft Access 2010 is a software program used to build and run databases. You do not need any prior experience working with Access to follow this free course, but if you are familiar with previous versions, then this course will help you quickly make the transition to this upgraded version. In this course you will learn how to design and create tables for a new database. You will learn how to construct these tables in the database and link them with primary key fields. You will be shown how to create the relationships between the tables and how to extract information from them using queries. This free MS Access course will also review keyboard shortcuts which help you work faster by relying more on the keyboard. Databases created with Access can also be viewed and edited online by uploading them to SharePoint and this course will take you step-by-step through this process. Microsoft implements some safety precautions when you work with online files, and this course will show you how to activate your content after you download it. This course will be of great interest to all business, finance and IT professionals who create and work with databases. You will see how creating a database makes handling data much easier and you will be able to maximise the functionality of the data and reduce data redundancy.

  • Learning outcomes:
    - 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.

  • All Alison courses are free to study. To successfully complete a course you must score 80% or higher in each course assessments. Upon successful completion of a course, you can choose to make your achievement formal by purchasing an official Alison Diploma, Certificate or PDF.

    Having an official Alison document is a great way to share your success. Plus it’s:

    • Ideal for including in CVs, job applications and portfolios
    • An indication of your ability to learn and achieve high results
    • An incentive to continue to empower yourself through learning
    • A tangible way of supporting the Alison mission to empower people everywhere through education.

Modules List( 8 )
  • When you complete this course you can receive an A...
  • Module 1: Making the Switch to Access 2010
    • Making the switch to Access 2010
    • Get started with Access 2010
    • Start something with the Navigation Pane
    • Get to know the ribbon
    • Use files from previous versions
    • Get started fast with templates and web databases
    • Design on the fly with Layout view
  • Module 1: Resource
  • Module 2: Design and Create the Tables for a New Database
    • Plan for good design
    • Planning a new database
    • Keys and data types
    • Create tables for a new database
    • Saving, adding and navigating your data
  • Module 2: Resources
  • Module 3: Create Relationships and Queries for a New Database
    • Create relationships for a new database
    • Create relationships
    • Set referential integrity
    • Create lookup fields
    • Create queries for a new database
  • Module 3: Resources
  • Module 4: Create forms and reports for a new database
    • Create forms for a new database
    • Types of forms
    • Ways to create forms
    • Change forms in Layout view
    • Create reports for a new database
  • Module 4: Resources
  • Module 5: Building and Working with Online Databases through SharePoint
    • Building and working with online databases through SharePoint
    • Create and publish a web database
    • Save a changed database to the web
    • Create a web database from scratch
    • Add the web to your database
  • Module 5: Resources
  • Module 6: Access 2010 Keyboard Shortcuts
    • Access 2010 keyboard shortcuts
    • Introduction to keyboard shortcuts
    • Basic keyboard shortcuts
    • Moving around in Access
    • Keyboard shortcuts for selecting
    • Keyboard shortcuts for editing
    • Introduction to access keys
    • Basic access keys
    • Getting around dialog boxes
    • The property sheet and field list
    • Other kinds of access keys
  • Module 6: Resource
  • Module 7: Microsoft Office 2010 Security
    • Active Content
    • Enable Content
    • Trusted Documents
    • Protected View
  • Module 8: Microsoft Access 2010 Assessment
    • Access Full Assessment
Topics List ( 7 )
Module 1: Making the Switch to Access 2010
In this module you will be introduced to Access 2010, shown how to navigate the ribbon, save files as ACCDB (2007/2010) files and how to use database templates.
Topics List ( 5 )
Module 2: Design and Create the Tables for a New Database
This module shows you how to create and design a good database, starting with planning. You will be shown the different keys and data types. And also saving, adding and navigating through your data.
Topics List ( 5 )
Module 3: Create Relationships and Queries for a New Database
You will learn to create relationships within your tables to bring your data together here. Also how to extract meaningful information from your database using queries.
Topics List ( 5 )
Module 4: Create forms and reports for a new database
Here you will learn to create forms to make your database look more polished. Then you will learn to create reports to represent your data visually.
Topics List ( 5 )
Module 5: Building and Working with Online Databases through SharePoint
This module helps you to create, edit and publish your database for online use to the Microsoft SharePoint Server. You will find out also how to use web browser controls to display web pages in an Access 2010 database.
Topics List ( 4 )
Module 7: Microsoft Office 2010 Security
This module guides you through the various Security options available within Access 2010, including Protected View, Trusted Documents and Enabling Active Content.
Topics List ( 1 )
Module 8: Microsoft Access 2010 Assessment
You must score 80% or more to pass this assessment.
Course Features
  • Duration

    4-5 Hours

  • Publisher


  • Video


  • Audio


  • Assessment


  • Certification


  • Price


  • Reward

    50 Pts

  • Responsive


Reviews and Rate
This course has no reviews yet.