Microsoft® Office 2010 Specialist | Access (Includes Access to our IT Library)
Get Office 2010 skills on your CV.
ITonlinelearning
Summary
- Exam(s) / assessment(s) not included in price, and must be purchased separately
Overview
Show your current or future employer that you are serious about your career.
The Microsoft Office Access 2010 course provides students with the skills and knowledge needed to use the software effectively and efficiently including advanced software features.
Included Microsoft Office 2010 Specialist Course:
- Microsoft Office 2010 Access
When you pass your Access 2010 Exam, you will have achieved the Microsoft Certified Application Specialist (MOS) status in Access 2010.
Why not explore our training for FREE?
Explore the great variety of courses free and get an exact idea of how the training is delivered.
What do I actually get?
- Expert Instructor-led training delivered via video streaming
- Extensive Demonstrations and presentations delivered in a multimedia format
- Practice Tests and exam simulators
*Course does not include exam fee.
When can I Start?
Online learning allows you to start anytime, even Today!
Enquire Now >>
Our friendly consultants are waiting to help you.
** This course bundle is part of our IT Library which also includes Certified Network Professional (CCNP), CISSP, MCSA: Windows Server 2016, MCSE: Cloud Platform and Infrastructure and MCSE: Productivity and many more **
Certification
Microsoft Office Specialist (MOS) IT
Description
Course Outline:
- 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
- Customising Access
- Keyboard Shortcuts
- Section Review
Section 2: Designing a Database
- Section Overview
- Database Design Process
- Normalising 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
- 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 Subforms
- Section Review
Section 12: Customising Reports
- Section Overview
- Organising Report Information and Setting Report Control Properties
- Page Layout and Controlling Pagination
- Summarise 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
- Analysing 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 Summarising
- 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 Startup Interface
- Section Overview
- Creating and Modifying a DB Switchboard
- Setting and Modifying Startup 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 center
- Setting Passwords
- Converting Files and Signing with Digital Signatures
- Section Review
- Course Review
Who is this course for?
New to IT students or existing IT Professionals wanting to validate skills and knowledge with Microsoft’s internationally recognised Office 2010 Certifications.
Requirements
There are no requirements for this course.
Career path
- IT System administrator
- IT Infrastructure Manager
- Desktop support engineer
- Cloud Applications Administrator
- Software as a Service Administrator
- 1st Line, 2nd Line IT Support Engineer
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Add to basket or enquire
Course provided by
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.
