Microsoft Access 2007 - 2013 for Database Management training centre in Bangladesh


Microsoft Access 2007 - 2013 for Database Management

  • Date : 19 June - 22 July 2019
  • Duration : Evening(6.30 pm-9.30 pm)
  • No. of Classes/ Sessions : 10 sessions
  • Class Schedule : Monday and Wednesday
  • Total Hours : 30
  • Last Date of Registration : 17 June, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.


This SMART WORK course is designed for the office/business people who are facing problems to do their jobs especially on Database. This course is a powerful relational database program that includes hundreds of tools you can use to quickly start tracking, sharing, and reporting information, even if you are new to database development. Users have access to a large library of professionally designed templates; wizards that automatically creating tables, forms, queries, and reports.

This course aims at facilitating the officers to use Microsoft-office (2007-13) and others Internet related program with high level of efficiency and productivity in following areas:

1. Solving real life cases with professional expertise in Ms-Access.
2. Gaining skills in data management, analysis, advanced reporting.
3. Participants will be able to creating database applications and do tracking, sharing, and reporting information.

Pre Assessment will be taken to understand participants' level, while the course will end with a post assessment.


This course is a powerful relational database program that includes hundreds of tools you can use to quickly start tracking, sharing, and reporting information, even if you are new to database development.

Contents of Training:

1. Introduction to Databases and objects
1. What is a database? /Why use a database?
2. What to expect from this course/Is this course right for you?
3. Tables/Forms/Queries/Reports
4. Putting it all together

2. Getting Started with Access
1. Getting to know Access 2007/2013 environment
2. The Ribbon/The Quick Access Toolbar/Backstage view
3. The Navigation pane/Object sorting in the Navigation pane
4. To sort objects in the Navigation pane
5. Databases with navigation forms

3. Managing Databases and Objects
1. To open an existing database/to close a database
2. Working with objects
3. To open/ save/ close/ rename an object

4. Working with Tables
1. To open an existing table: a) Understanding tables/b) Navigating within tables
2. Adding records and entering data
a) To add a new record/ To save a record
b) Editing records: To replace a word within a record: To delete a record:
3. Modifying table appearance
4. Resizing fields and rows: To resize a field/a row/Hiding fields
5. Table formatting options
6. Alternate row color/to change the alternate row color
7. Modifying gridlines/to customize which gridlines appear:
8. Additional formatting options

5. Working with Forms
1. Why use forms?
2. To open an existing form
3. Entering and modifying data/to add a new record
4. To find an existing record to view or edit
5. To save/ delete the current record
6. Using form features

6. Sorting and Filtering Records
1. Sorting records
2. Filtering records
3. To create a simple filter/Creating a filter from a selection
4. To filter text/ numbers by a search term

7. Designing a Simple Query
1. How are queries used
2. To create a simple one-table query

8. Designing a Multi-Table Query
1. Planning a query
A) Step 1: Pinpointing the question we want to ask
B) Step 2: Identifying the information we need
C) Step 3: Locating the tables that contain the information we need
2. Joining tables in queries
3. Creating a multi-table query

9. More Query Design Options
1. Modifying queries/Sorting queries/ apply a multilevel sort
2. Hiding fields within queries
3. More types of queries: create a totals query:
4. More query options:
a) Creating a Parameter Query
b) Creating a Find Duplicates Query
5. Other query-building resources
a) Query criteria quick reference guide
b) Simple criteria for all data types/Text/Numbers/Dates

10. Creating Reports
1. To create a report
2. Deleting fields
3. Printing and saving reports in Print Preview
A) To print a report:
c) Saving reports
d) To export a report:

11. Advanced Report Options
1. The Report Wizard/To create a report with the Report Wizard:
2. Formatting reports/Modifying report text
3. Modifying the page header and footer
4. Modifying your report's appearance
a) To add a logo:
b) Themes and fonts

12. Modifying Tables
1. Adding and rearranging fields
2. To add a new field to an existing table:
3. To move a field:
4. Advanced field options
A) To change the data type for existing fields
B) to set a character limit for a field
C) to create a validation rule
5. More table options: Calculated fields and totals rows

13. Creating Forms
1. To create a form/about sub forms
2. To add a field to a form/to add a field from a different table:
3. Adding design controls
4. Combo boxes: To create a combo box
5. Customizing form settings with the Property Sheet
6. Modifying form settings: To hide a field
7. To set a field to auto fill with the current date

14. Formatting Forms
1. To add a command button to a form/Modifying form layout
2. To resize/ move form components
3. More formatting options
4. Modifying the colors and fonts of form components

15. Designing, protecting and using function Your Own Database
1. To create a database from a template
2. More resources on database design
3. Protect Databases
4. Use the common function in database

16. Import and Export Data
1. Importing from Excel Worksheets
2. Exporting to Other Access Databases
3. Exporting to Excel Worksheets
4. Exporting to PDF and XPS Files

Related Courses

S.M.Morshed Hemal
  • 19 Jun - 8 Jul 2019

Microsoft Excel is one of the most widely used tools for ...

Price 18,000 Tk + VAT
Muhammad Rabiul
  • 19 Jun - 19 Aug 2019

The course has designed to become familiar with an ...

Md. Rabiul Islam
  • 20 Jun - 21 Jul 2019

In this course, you will learn exciting concepts and skills ...

Imran Hossain
  • 20 Jun - 30 Jul 2019

Understanding user Interface and experience design, you can ...

Executives, Managers, Teachers, Developers, Students, Researchers and people who deals with large data for their daily tasks and activities.

Resource Person

Md. Nizamul Islam, MBA, UK

ICT Specialist & Professional Freelancer

Nizamul is a business graduate from University of Wolverhampton, UK and an expert in MS Office Applications and Professional Digital marketing. He used to work in UK for Lebara Mobile, UK and Epson UK Ltd and also worked in Bangladesh for ICT division for last 3 years as Project Manager (LEDP, LICT) and Master Trainer of Advanced Outsourcing Training.

He is the author of freelancing book “Online Earning Tips” and called “Freelancing Guru” for creating over 100 Freelancing trainers including over 3000 freelancers all over Bangladesh.
As part of his plan to contribute to his own country’s development; he came to Bangladesh back in 2013 and started his own business. He is now involved in IT solutions including web and software development and Digital Marketing. Also he facilitates IT education in MS Office applications and graphic designing. He has been a reputed public and corporate trainer for several years on subjects like Financial Analysis & Modeling, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word, and Digital Marketing up to advanced level.
He is the founder of several IT organizations all over Bangladesh like PC Plus IT, Rangpur Freelancing Park, Dinajpur Freelancing Park and Nilphamari Freelancing Park and also he has trained over 3000 new entrepreneurs, freelancers, professionals, business owners, technical and management experts and still counting in.

This course is a powerful relational database program that includes hundreds of tools you can use to quickly start tracking, sharing, and reporting information, even if you are new to database development.