Skip to content

MS Access 2010 – Exam 77-885 Prep

EduCBA

Summary

Price
£149 inc VAT
Or £49.67/mo. for 3 months...
Study method
Online
Course format What's this?
Video
Duration
5 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Exam(s) / assessment(s) is included in price

Overview

About MS Access 2010

  • 5+ Hours OF HD VIDEOS
  • Verifiable CERTIFICATION
  • Practical SKILLS DEVELOPMENT
  • Accelerate YOUR CAREER
  • Lifetime Access 24*7 Unlimited Access
  • Access through any device
  • Technical support
  • Mobile App Access

Microsoft Access 2010 is a “Database Management System” (DBMS) that comes from Microsoft. It helps to combine the “graphical user interface” with the “relational Microsoft Jet Database Engine” and the tools of software development. A member of the “Microsoft Office suite of applications”, Microsoft Access is a part of the higher editions or professional editions of this suite and is also sold separately. On the basis of the “Access Jet Database Engine”, Microsoft Access can store data in a format of its own. It can also import or form a direct link with the data that is stored in databases as well as in other applications.

Certificates

Certificate of completion

Digital certificate - Included

Description

MS Access 2010

MS Access 2010 can be used by the data architects or the software developers for the development of application software. It can also be utilised by the “power users” for the building of software applications. Similar to the other applications of Microsoft Office, this is also gets support from the “Visual Basic for Applications (VBA)” which is a programming language that is object based and which can reference a number of objects including “Active X Data Objects”, “Data Access Objects (DAO)” and several other components of “Active X”. The visual objects that are used in reports, as well as forms, reveal their properties along with methods in the environment of VBA programming while the code modules of VBA might declare and also call the functions of the operating system of Windows.

Course Description:

  1. Introduction

This section consists of an introduction to MS Access 2010.

  1. Basic Concepts of Database along with Terminology
  • How to start Microsoft Access?
  • Backstage of Access
  • Quick Access Toolbar
  • Trusting of a File
  • Navigation Pane
  • Exploration of the Ribbons
  • Database Components
  1. Creation of a Database and Designing a Table
  • Planning as well as designing of the database
  • Understanding the table’s structure
  • Creation of a table by the use of design view
  • Creation of a table by the use of calculated view
  • Field Properties
  • Formatting tools
  • Import of data into Access
  • Linking of the tables
  1. Creation of Queries
  • Use of Quiz Wizard for queries that are simple
  • Use of design query
  • Sorting of data by the use of queries
  • Modification of the Queries
  • Building of calculated fields
  1. Creation and Modification of Forms
  • Creation of data entry forms
  • Creation of compound forms
  • Modification of forms in Layout as well as design view
  1. Creation and Designing of Reports
  • Report in case of a single table
  • Report in case of a Multiple tables along with formatting
  • Creation of reports by the use of queries
  1. Export of data and Mail Merge
  • Export of data from Access
  • Creation of a Mail Merge
  1. Creation of Tables
  • Creation of tables by the use of Application parts
  1. How to Work with Specialty Queries?
  • Updating Queries
  • Making a table query
  • Deleting a query
  • Union Query
  • Crosstab Query
  • Statistical Query
  1. Designing of Forms
  • Datasource
  • Form Controls
  • Navigation of Record
  • Input Boxes
  • Addition of buttons
  • Pivot charts as well as tables
  • Setting the tab order
  • Split Form
  • Multiple Form
  1. Creation as well as Designing of Reports
  • Structure of the Report in design view
  • Addition of group as well as sort
  • Addition of fields from other tables
  • Addition of totals as well as subtotals
  • Creation of mailing labels
  • Conditional Formatting as well as Data Bars
  1. How to work with a Macro?
  • Creation of a Macro
  • Use of data macros
  • Addition of group and sort
  1. Other Applications of Access
  • Publishing in HTML or XML
  • Collection of data through an email
  • Sharing through email
  • Use of tools of data analysis
  • Encryption of the database
  • Splitting the database
  1. Conclusion

Who is this course for?

  • Any student who is a novice and wants to gain knowledge about Microsoft Access 2010
  • Working Professionals
  • Any other person who may be interested in learning about Microsoft Access 2010

Requirements

  • Basic knowledge related to access
  • Installation of Microsoft Access 2010 in your computer
  • Internet connection in your computer

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.