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

New
EMI EASY PAY

Microsoft Access 2007 - 2013 for Database Management

Introduction

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.

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

Methodology

This will be an instructor led program delivered through hands on labs with real life example. Audience will taste a new level of experience by attending the course.

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

Price 6,000 Tk + VAT
Muhammad Rabiul
  • 26 Feb - 17 Mar 2019

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

IT
Md. Feroz Kibria
  • Friday, March 1, 2019

Organizations use Microsoft Office Excel to track sales ...

IT
Md. Rabiul Islam
  • 5 Mar - 7 Apr 2019

Data Science is one of the lucrative job of the 21st ...

IT
Mostofa Monower
  • 5 Mar - 7 Apr 2019

Upon successfully completion of this training, participants ...

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