Access 2010 (77-885)

Course

Online

£ 195 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    12 Months

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Completion Certificate awarded upon completion to show employers your new skills
Free upgrade on to our state of the art platform
12 Months unlimited Access
Access 2010(77-886)
Word 2010 MOS Certification training courses prepare students for the MOS exams by teaching greater skill mastery in Microsoft Word 2010. Candidates must pass one exam in order to earn the MOS credential.

The MOS exams provide a valid and reliable measure of technical proficiency and expertise in Microsoft Office Word 2010 by evaluating the ability to use the advanced features in the product to solve real-world business problems.

In today’s competitive economic climate, having certifications that validate one’s skills are essential to “set yourself apart from the pack” in the marketplace. Having Microsoft certifications not only increase one’s marketability but also validates an employee’s skills and experience to a potential employer. IT University is committed to helping all of our students in their given profession and has designed this bundle specifically to help any Business, HR, Sales, Office, Administration or Accounting professional gain the skills and certification they need to help them attain the positions they desire.
In today’s marketplace computers are a part of daily life for almost everyone in an office setting. Many people spend hours on projects that could take minutes if they had the necessary training to expedite their day to day tasks.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

Subjects

  • Word
  • Access
  • Office IT
  • Database
  • Database training
  • Ms Office
  • Layout
  • Design
  • Instructor
  • Customizing
  • Shortcuts
  • Keyboard

Course programme

Course Syllabus

Course Introduction
  • Instructor Introduction
  • Access Overview
  • Course Outline
Section 1: Access Basics
  • Section Overview
  • What Does Access Do?
  • Access Application Window
  • Database Objects
  • Basic Database and Table Management
  • Customizing Access
  • Keyboard Shortcuts
  • Section Review
Section 2: Designing a Database
  • Section Overview
  • Database Design Process
  • Normalizing Data
  • Setting Primary and Foreign Keys
  • Section Review
Section 3: Building a Database
  • Section Overview
  • Creating A New Database
  • Creating Tables
  • Inserting Field’s in Tables
  • Setting Up Field Properties
  • Formatting the Datasheet View
  • Creating Relationships
  • Keyboard Shortcuts
  • Section Review
Section 4: Managing Table Data
  • Section Overview
  • Updating and Deleting Records
  • Finding and Replacing Values
  • Adding a Total Row
  • Using Sub-datasheets
  • Sorting Data
  • Filtering Data
  • Keyboard Shortcuts
  • Section Review
Section 5: Creating Selection Queries
  • Section Overview
  • Creating Queries Using the Query Wizard
  • Creating Queries Using the Query Design View
  • Adding Criteria
  • Add Calculated Fields to Query
  • Section Review
Section 6: Creating and Managing Forms
  • Section Overview
  • Form Basics and Creating Forms
  • Contextual Tabs Design and Layout View
  • Managing Table Data with Forms
  • Modifying the Look and Design
  • Design Tab Controls
  • Section Review
Section 7: Creating and Managing Reports
  • Section Overview
  • Creating Reports, Report Views, and Managing Report Sections
  • Adding Calculated Fields and Formatting The Report Controls
  • Section Review
Section 8: Controlling Data Entry
  • Section Overview
  • Setting Field Properties
  • Validation Rules
  • Input Mask
  • Create Lookup Field
  • Section Review
Section 9: Finding and Joining Data
  • Section Overview
  • Inner and Outer Joins
  • Joining Unrelated Tables and Relating Data Within Tables
  • Section Review
Section 10: Creating Flexible Queries
  • Section Overview
  • Select Query Properties
  • Parameter Queries
  • Using Wild Cards
  • Creating Action Queries
  • Section Review
Section 11: Enhancing Forms
  • Section Overview
  • Using the Form Layout View and Improving Form Appearance
  • Restricting Data Entry
  • Command Buttons and Creating Sub forms
  • Section Review
Section 12: Customizing Reports
  • Section Overview
  • Organizing Report Information and Setting Report Control Properties
  • Page Layout and Controlling Pagination
  • Summarize Info and Sub-reports
  • Mailing Labels
  • Section Review
Section 13: Sharing Access Data
  • Section Overview
  • Importing and Exporting Data
  • Sharing Data and Merging Data with Word
  • Section Review
Section 14: Structuring Existing Data
  • Section Overview
  • Analyzing Tables and Junction Tables
  • Improving Table Structure
  • Section Review
Section 15: Writing Table Queries
  • Section Overview
  • Multi Table Query
  • Creating Unmatched Queries
  • Create Duplicate Queries
  • Create Duplicate Queries and Grouping and Summarizing
  • Crosstab Query
  • Creating Pivot tables and Pivot Charts
  • Section Review
Section 16: Using Macros
  • Section Overview
  • Planning and Creating Macros
  • Attach Macros to Command Buttons
  • Restrict Records Displayed Using Where Condition
  • Require Data Entry with Macros
  • Automate Data Entry
  • Section Review
Section 17: Making Forms More Effective
  • Section Overview
  • Form Format Properties
  • Active X Controls and Tabbed Pages
  • Display Pivot Chart Table on Forms
  • Section Review
Section 18: Improving Reports
  • Section Overview
  • Include Chart In Report and Concatenating
  • Arranging Data In Columns, Grouping, and Parameter Reports
  • Report Events and Cancelling a Blank Report from Printing
  • Section Review
Section 19: Creating a Start-up Interface
  • Section Overview
  • Creating and Modifying a DB Switchboard
  • Setting and Modifying Start-up Options
  • Section Review
Section 20: Database Maintenance
  • Section Overview
  • Database Maintenance Tools
  • Section Review
Section 21: Distributing and Securing a Database
  • Section Overview
  • Splitting a Database
  • Implementing Security and Trust centre
  • Setting Passwords
  • Converting Files and Signing with Digital Signatures
  • Section Review

Access 2010 (77-885)

£ 195 VAT inc.