Call Us © +91-9001627655       Email © lifewaytechindia@gmail.com ,   info@lifewaytechindia.com,   info@lwtindia.com Facebook GooglePlus  Twitter  Linkedin

MS Access Training

Training Description:

Microsoft Access is a highly worthwhile skill to have at your command as this very popular database application is widely used across many employment sectors.

Offering training in either 2010 or 2013, in this detailed and varied training programme you'll be guided through many aspects of Access including; database terminology; planning and design; defining relationships and creating a table; editing data; using advanced tools; using the query wizard; adding a field; exporting an html document; adding charts to forms; and creating macros.

Who Should Attend:

• This popular database programme is used in many industries by those wishing to keep accurate, up to date records of customers, projects, products etc.

• So, for example, if you're working as a PA, EA, VA, Secretary, Administrator or Customer Services Executive, learning how to use this software properly will help you and your skill stand out from the crowd.

Benefits of This Trainings:

Upon completion of this course, students will be able to:

• Learn how to use this popular database program

• The flexibility and value of a self-study course designed to enable you to work at your own pace

Prerequisites:

General handling of computer knowledge with some Microsoft office features

At Life Way Tech India, we provide an excellent and high quality Training. We have a team of highly skilled professionals to equip you and build a strong foundation. The curriculum can be customized as per individual’s need.

TABLE OF CONTENTS

Chapter 1. Including: terminology, working with existing databases, opening a table, query, form and report, entering new records, searching and sorting.
Chapter 2. Including: planning and design, relationships, defining fields, data types and properties, creating tables, entering data, re-sizing columns, using the lookup wizard
Chapter 3. Including: defining relationships, creating tables, formatting, modifying, using the input mask wizard, using templates, renaming an object.
Chapter 4. Including: editing data, adding records, printing preview, changing page orientation, enforcing referential integrity in a relationship, creating a relationship report, creating a form, working with controls in form design, using AutoFormat, modifying properties in a form.
Chapter 5. Including: Using advanced sort, using filters, importing a table from an external database using a junction table to resolve a many to many relationship, defining a composite (primary) key, using a calculated control on a form, creating a multi-value field, creating an attachment field.
Chapter 6. Including: using query wizard, setting sort criteria, using expressions to set criteria, creating different types of queries, creating and naming a calculated field in a query using aggregate functions.
Chapter 7. Including: adding a field with data validation in a table, creating a form with subform, entering data using a form/subform combination, creating a split form, creating and modifying the design of a report, using the concatenate expression, adding a subreport to an existing report.
Chapter 8. Including: exporting an html document, understanding object dependencies, importing and exporting a spreadsheet, importing a text file, using the analyze table function, using the analyze performance function, using the database documenter.
Chapter 9. Including: adding and modifying a chart, changing the tab order in a form, displaying the current date and time in a form, applying conditional formatting to a field.
Chapter 10. Including: creating a macro, adding a control button to a form, backing up a database, viewing database properties, compacting and repairing a database, encrypting a database using a password, saving the database as a previous version, splitting a database.
Chapter 11. Project using MS Access
     
Download Full Syllabus
     

HOW TO APPLY:-Please Register : Here(Registration is Free)

The training program is for candidates who are new and aimed to Learned PL/SQL Programming.

Do not wait anymore! Sudents Know more about Life Way Tech India Training admission process please Contact Us : www.lifewaytechindia.com Email: info@ lifewaytechindia.com ,call us @+9001627655

 
Copyright © 2014 LIFE WAY TECH INDIA PVT. LTD. DESIGNED BY : LIFE WAY TECH INDIA