Professional MS ACCESS 2010
Service Times: 9am and 10:30am
6399 North Wells Road, Bigtownville, CO 32748
Latest
  • Loading
f

Professional Training in Microsoft Access 2010

Email Print Export to ical format

Venue:

Academy of Management & Science (AMS)
House # 89/E, Road # 13/C, Block # E, Banani, Dhaka 1213, Bangladesh
Telephone: +880 (2) 9891190, +880 (2) 8836875, Cell No: (88) 01680878839, (88) 01193070284

Resource Person

Md. Anwar Hossain is an Information Technology & Security Professional with M.Sc. in Computer Science & over 12+ years of IT experience in Telecom, Bank ,Multinational & local enterprise , Small medium business and IT Service Provider with notable success in directing IT corporate initiatives while participating in planning, analysis Designing and Lead implementation of Information Technology & security solutions and standards in direct support to business objectives. He is extremely well versed with ITIL v3 & MOF. He served as Technology Specialist for Microsoft Bangladesh part for last 6+years.
Presently he is working as freelance consultant to implement IT infrastructure, messaging and collaboration, Unified communication, IT asset management, service desk, business process automation to make business more productive, profitable and competitive as well as security software that drive awareness, decrease exposure and strengthen organizations. He also has hands- on experience in Enterprise regarding various Information technologies including Security application based on Microsoft platform.
He has imparted Information technology including Cisco, Microsoft & security training at various levels in the organizations for Senior Management, implementation team members, end users.
Mr. Anwar has a passion for teaching and learning which is evident from the string of certificates he has obtained and which he also teaches. He conducted classes on MCITP Server admin and enterprise admin , exchange server 2007,2010 CCNA ,CCNP, Microsoft Office. He also conducted ITIL Foundation 3.0 to British High commission, Apollo Hospitals, Sheraton Hotel, NCC Bank, HSBC Bank, Chevron, Singapore Technology, Rajuk, Australia high commission, Banglalink.
ITLI Foundation in IT Service Management:
ITIL Foundation V.3
EC Council

Workshop Details

Venue:
Academy of Management & Science (AMS)

Location:
House # 89/E, Road # 13/C, Block # E, Banani, Dhaka-1213, Bangladesh

Contact:
Telephone: +880-2-9891190
+880 (2) 8836875
Cell No: (88) 01193070284
(88) 01680878839

Professional Training in Microsoft Access 2010

Overview:

This course provides participants with a solid overview of the features, functions, usability & will learn advanced-level Microsoft Access 2010 skills.

Duration:

16 Hours

Course Objectives:

At the end of the course, participants will be able to:

  • Work in Access 2010
  • Understand Database Concepts
  • Create Database, Form, Report, Custom Report
  • Create Queries
  • Maintain Data Integrity
  • Database Protection
  • Make Database user friendly

Course Details:

Intermediate part of this course will cover the following modules:

Module 1: Explore an Access 2010 Database:
This module discusses the Access interface and explores various database components, including tables, forms, queries, and reports.

Lessons:

  • Working in Access 2010
  • Understanding Database Concepts
  • Exploring Tables, Forms, Queries, Reports
  • Previewing and Printing Access Objects

Module 2: Create Databases and Simple Tables:

This module explains how to create databases and tables, either manually or from templates, and how to change table formatting and structure. It also explains how to create relationships between tables.

Lessons:

  • Creating Databases & Tables from Templates & Manually
  • Manipulating Table Columns and Rows
  • Refining Table Structure
  • Creating Relationships Between Tables

Module 3: Create Simple Forms:

This module explains how to create forms to view and enter data, modify the appearance of a form, and customize the layout of a form.

Lessons:

  • Creating Forms by Using the Form Tool
  • Changing the Look & Arrangement of Forms

Module 4: Display Data

This module explains how to display information in useful ways, by sorting and filtering tables, and by filtering information in forms.

Lessons:

  • Sorting & Filtering Information in Tables in various ways
  • Filtering Information by Using Forms
  • Locating Information That Matches Multiple Criteria

Module 5: Create Simple Reports:

This module explains how to extract information from a database as a report. It also explains how to modify report design and preview and print reports.

Lessons:

  • Creating Reports by Using a Wizard
  • Modifying Report Design
  • Previewing and Printing Reports

Module 6: Maintain Data Integrity:

This module explains how to ways to help ensure the accuracy of data entered into a database.

Lessons:

  • Restricting the Type, Amount, Format of Data
  • Restricting Data by Using Validation Rules
  • Restricting Data to Values in Lists & Other Tables

Module 7: Create Custom Forms:

This module explains how to customize forms to facilitate data entry and display.

Lessons:

  • Modifying Forms Created by Using a Wizard
  • Adding Controls, Subforms
  • Using E-Mail Forms to Collect Data

Advance Part of this course will cover the following modules:

Module 8: Create Queries

This module explains how to use the Query wizard to create a select query, how to use the Query Designer to created less common queries, and how to perform calculations and update and delete table information.

Lessons:

  • Creating Queries by Using both Wizard & Manually
  • Using Queries to Summarize Data, Perform Calculations, Update Records, Delete Records

Module 9: Create Custom Reports:

This module explains how to extract information from a database as a report. It also explains how to modify report content and add a sub-report.

Lessons:

  • Creating Reports Manually
  • Modifying Report Content
  • Adding Sub-reports

Module 10: Import and Export Data:

This module explains how to populate the tables of a database by importing existing information from other sources and how to use information that exists in an Access database in other programs.

Lessons:

  • Importing & Exporting Information from/to text file, excel worksheet and various formats
  • Copying to and from Other Office Programs

Module 11: Make Databases User Friendly:

This module explains how to make databases easier to access and manipulate, and more difficult to unintentionally change or delete.

Lessons:

  • Creating Navigation Forms (two-level)
  • Creating Custom Categories
  • Controlling Which Features Are Available

Module 12: Protect Databases:

This module explains how to ensure that a database

Training Calendar

<<  November  2017  >>
 S  M  T  W  T  F  S 
     1  2  3  4
  5  6  7  8  91011
12131415161718
19202122232425
2627282930  

Newsletter

AMS Campus Facilities

  • Two Air conditioned seminar halls with projector & audio system [Maximum Capacity up to 50 persons] including video recording capacity.
  • Two different PC Labs (Air conditioned)
  • Centralized server
  • Internet / WIFI facilities
  • Practice facilities in LABS
  • Online Exam Centre
  • Cafeteria & Own cook facility
  • Large lobby with natural surroundings
  • Huge Parking Space
  • Waiting Lounge
  • Distance education facilities
  • Printer, Scanner etc logistics facilities
  • Special Guest Room
  • Registration Booth Arrangement Space
  • 3 Star Accommodation arrangements for foreign guests on demand in walking distance from the center.
    ………and many more

Contact AMS

Academy of Management & Science (AMS)
House #450, Road # 31, New DOHS,Mohakhali, Dhaka-1206, Bangladesh
Cell No: (88) 01616004108
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Academy Location

Testimonials

Show