![]()
Syste
m (Hardware/Software)
Requirements
| Operating
Software | Windows XP or
Higher
| | Processor | Minim
um P4 or Higher
| | RAM | 1 GB or
Higher
| | Browser | Any
| | Recommended Internet
Speed | Minimum 1MBPS
| | Supported Browser
Plug-ins | * Updated
Flash Player, * Update Java
| | Other
Requirements | Speaker or
headphone | |
Prdocut DescriptionDuring this course for using Microsoft Access 2010, students will learn how to work with basic to advanced functions of Microsoft Access 2010. We'll start with navigating the Access 2010 interface. This course allows you to synthesize information with custom web apps and desktop databases. Whether you have been using Access your entire career or database technology is new to you, this Microsoft Access 2010 Tutorial will give you an advanced understanding of the many Access 2010 features that will enable you to gather and interpret data faster than everyone else.
This course covers how to get started with Microsoft Access 2010. Students will learn how to launch Access 2010 and open a database, understand the Windows components, learn about queries, use reports, create and save a simple Access 2010 database. Starting with the basics, this course will teach you to add and delete records to your database. Learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Build forms to capture information online. Implement pre-designed templates that track project, employee, issue, or task details. Protect databases with permissions. Run reports that provide valuable business intelligence. And walk away with a solid grasp of how tie it all together with this Microsoft Access Training.
By the completion of this training course, you will be capable of creating databases as well as reports and forms in Microsoft Access 2010, and you will have in-depth knowledge of the tools and functions available to you in this software.
Course Curriculum
Section 1: Introduction
Introduction To Microsoft Access
Section 2: Basic Database Concepts And Terminology
Starting Microsoft Access
Trusting A File
Quick Access Toolbar
Backstage Of Access
Exploring The Ribbons
Navigation Pane
Components Of A Database
Section 3: Creating A Database‚ Designing A Table
Planning And Designing The Database
Create A Table In Layout View
Understanding The Structure Of A Table
Create A Table Using Design View
Create A Table Using Calculated Field
Field Properties
Importing Data Into Access
Formatting Tools
Linking The Tables
Section 4: Creating Queries
Using Query Wizard For Simple Queries
Using Design Query
Sorting Data Using Queries
Modifying The Queries
Building Calculated Fields
Section 5 : Creating And Modifying Forms
Create Data Entry Forms
Create Compound Forms
Modifying Forms In Layout And Design View
Section 6 : Creating And Designing Reports
Report On Single Table
Report On Multiple Table And Formatting
Create Reports Through Queries
Section 7 : Exporting Data And Mail Merge
Exporting Data From Access
Creating A Mail Merge
Benefits
eduCBA e-campus
Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
Online Video Training Material
Presentation Slides
USP of the product
* 24 x 7 online access* Learn from tutorials curated by expert industry professionals and trainers* Certificate of Completion* Practical application oriented skillsHow to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email idStep 4 - Login using your email id and password and start learningTo get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
