You can format your documents fast, fix your mistakes, add graphics and figures and edit them by learning the advanced tools of Word. Also, you can print correctly by using print settings. With this education you will learn methods that will increase your control over the document and complete your actions in a very short time.

Duration: 1 Day

Module 1: Overview of Word

• Use the Backstage Button
• Customize the Ribbon
• Use Office Menus
• Use the Quick Access Toolbar
• Use the Help Menu
• Use the “Tell me what you want to do” feature *New

Module 2: Document Control

• Enter a text
• Insert and Delete a Text, and use Different Fonts
• Copy and Paste the Text
• Move and Copy a Text Between Documents
• Undo changes

Module 3: Formatting

• Use the Ribbon
• Use Quick Format Toolbar
• Edit Paragraph Options
• Copy Formats
• Use Automatic Correction
• Insert Bullets And Numbering

Module 4: Version Management and Text Functions

• Use the Navigation Pane
• Version Management
• Split a Text into Different Columns
• Change the Capitalization or case of a Text
• Use Tabs
• Insert Symbols and Special Characters
• Find and Replace a Text
• Insert a Text Automatically
• Insert Date and Time

Module 5: Proofing a Document

• Use the Thesaurus
• Spell Check
• Checking the Number of Words

Module 6: Working with Tables

• Create a Table
• Use the Table Tools Section
• Add and Delete Columns and Rows
• Enter Data to the Table
• Create Automatic Formatted Tables
• Transform a Table into a Text
• Use Formulas within the Tables

Module 7: Inserting Graphical Objects

• Insert a Clip Art
• Insert a Watermark
• Ink Equations *New
• Insert a Symbol

Module 8: Print Settings

• Use the Layout Tab
• Insert Header-Footer
• Change Margins
• Insert a Page Break
• Preview the Document
• Print the Document
• Fast Print

With this education you can use styles efficiently, create professional work by enriching your texts with advanced document techniques, send e-mails with the address letter feature and control a lot of features where you can print labels. In addition to that, you can turn it into a dynamic program by integrating with the other programs. Also, you obtain necessary skills for cooperation by using encrypting methods, document-tracking options, inserting and following a comment features actively.

Duration: 2 Days

Module 1: Definition of Styles and their Applications

• Define Style Properties
• Change and Apply Style Properties
• Transfer Styles Between Files

Module 2: Advanced Document Techniques

• Use the References Tab
• Insert Hyperlinks to a Text
• Add Comments to a Text
• Add a Bookmark to a Text
• Add and Update a Field
• Use Captions
• Create Cross-References
• Add Footnotes to a Text
• Add a Table of Contents
• Add Page and Section Breaks

Module 3: Print Envelopes and Labels

• Use the Mailings Tab
• Use Data Sources
• Merge Letters and Addresses
• Create a Name Tag
• Send a Mass Mail with Personal Names

Module 4: Working with Templates

• Use Templates
• Add Fields and Formulas to the Templates

Module 5: Customize Word

• Customize Quick Access Toolbar
• Customize the Ribbon

Module 6: Cooperation

• Add and Delete Comments
• Track and Print Comments
• Work on a Workpaper together by Sharing It
• Tracking Options
• Accept and Deny Changes

Module 7: Protect and Track the Document

• Use the Review Tab
• Track Changes
• Protect the Document
• Compare and Combine Word Documents

Module 8: Work with Graphical Objects

• Use Picture Tools
• Add Effects to a Picture
• Remove the Background of a Picture
• Add Screenshots to the Document
• Work with SmartArts
• Add a Cover Page
• Explore Special Chart Types special for Office 365 *New

Module 9: Data Exchange with the other Programs

• Create a Link
• Word & Excel
• Word & PowerPoint
• Word & Outlook
• Save as PDF, XPS, XML

Module 10: Print Settings

• Use the Version Management
• Inspect the Document
• Encrypt the Document
• Rights Management
• Insert a Digital Signature
• Mark as Final
• Compatibility Inspector

You can get the prerequisite information for advanced Excel Education in the Microsoft Office Excel basic education. It is for people who get to know Excel for the first time or who have just a bit of information. You can learn short cuts and methods like Excel interface, cell structure, worksheet, easy calculations, creating tables, basic formatting and print setting that are necessary for the beginner-level and gain experience. Also, you can learn the function and experience basic functions and customize your worksheets.

Duration: 2 Days

Module 1: Introduction

• Get Started with Excel
• Use the Backstage field
• Use the Quick Access Toolbar
• Customize the Ribbon
• View Older Versions of the workbook *New
• Use the “Tell me what you want to do” Feature *New

Module 2: Working within the Worksheet

• Data Entry and Selecting techniques
• Undo and Redo

Module 3: Editing on the Worksheet

• Add and Delete Cells, Columns and Rows
• Change the Column width and Row Height
• Hide Columns and Rows
• Move and Copy Data

Module 4: Make Calculations

• Create a Formula
• Use the Pin Feature with the ($) Sign in the Formulas

Module 5: Formatting

• Use the Ribbon
• Use the Quick Format Toolbar
• Format Font, Alignment, and Numbers
• Format Tables

Module 6: Themes and Styles

• Create and Apply a Theme
• Create and Apply a Style

Module 7: Workbook

• Format Page Tabs
• Place Worksheets
• Insert or Delete a Worksheet

Module 8: Print the Content of the Workbook

• Arrange a Print Title
• Create a Header & Footer
• Define the Printing Area

Module 9: Customize Layout

• Split, Hide or Show a Worksheet
• Align Worksheets
• Freeze Columns and Rows

Module 10: Introduction

• Create Charts
• Use the Chart Toolbar
• Add and Delete Data with a Chart
• Create Trend Charts
• Explore Charts Special for Office 365 *New
• Make SmartArt Edits
• Create Hierarchy and Pyramid
• Add Ink Equation and Symbols *New

You need to have completed the advanced level Excel Education before you get this one. You can learn complex function structures, write nested functions, use control functions and functions like If, And, Or of logical functions effectively. Also, you can create criteria and see database function in more detail, import data of different file types and analyze by interpreting them with Excel. You can create relation between tables by using dynamic tables efficiently in your educations, and experience formulation structure in dynamic tables. You can learn how functions are used in Conditional Format and Data Verification with practical examples. Besides, you will learn solver, scenarios, multivariate tables with different examples and discover the Power of Excel.

Duration: 2 Days

Module 1: Analyze Data

• Solve with Goal Seek
• Model with the Solver
• Create One-variable or Multivariate Tables
• Create Prospective Projection with Scenarios
• Define Special Criteria Fields for Advanced Filter
• Define Data Range and Use It in Functions

Module 2: Advanced Functions

• Make Dynamic Searches (Index, Match)
• Use Nested Searches (Vlookup, Hlookup)
• Financial Payment Functions (PMT, PPMT, IPMT)
• Merge Different Data Types (Dollar, Text)
• Advanced Text Splitting and Merging Techniques (Rept, Len, Search, Trim)
• Auditing Functions (If, Iserror, Isna, Isblank, Isnumber)
• Create a Pivot Table with Multiple Criteria
• Look up and Database Functions

Module 3: Working with External Data

• Database Query
• Excel Query
• Web Query
• OLAP
• XML

Module 4: Practical Techniques

• Shortcuts
• Practical Techniques in Functions and Data Analysis
• Effective Solutions with Record Macros

Module 5: Security

• Protect a Workbook, Worksheet and Cells
• Provide Security in the Workbook
• Document Encryption
• Rights
• Other Practice Examples
• Highlight Duplicate Records
• Highlight Unique Records
• Highlight the Row that Meets Specific Conditions
• Block the Reentering the Existing Records in the List
• Sort out Duplicate Records
• Turning Grouped Lists by Filling the Gaps into Excel Tables
• Define Special Sorting Criteria in Lists
• Design Dynamic Charts by Using Dynamic Names

Excel Macros are programs written with the VBA (Visual Basic for Application) language. You can develop your custom applications correctly and in a very short period of time by using VBA codes in Excel. Normally when you are using available Features in Excel for your actions, you can reach a certain point but if you need to automatize these actions or want to run a few actions connected to each other, using macros would be the best solution. This way you can customize your work and do your long-time consuming tasks in a very short time.

Duration: 4 Days

Module 1: Overview of Macros

• General Information about Macros
• Macro Types, Saving Macros
• Change Macro Options
• Run Macros
• Connect Macros to Objects
• Edit Macros
• Security in Macros
• Create and Publish Numeral Signatures
• Delete Macros
• Overview of the Macro Codes

Module 2: Explore the Visual Basic for Application (VBA) Window

• Toolbars (Debug, Edit, Standard, User Form)
• Code Window Properties Window
• Project Explorer Window
• Module, User Form, Class Definitions
• Procedure Definitions
• Module 3: Operators
• Arithmetic Operators
• Modula Operators (^, *, /,\, +, -, &)
• Comparison Operators
• =, <>, ≤,≥, Like, Is Operators
• Logical Operators
• Not, And, Or, Xor, Eqv, Imp Operators

Module 4: Explore the Procedures

• Sub Type Procedures
• Function Type Procedures

Module 5: VBA Programming Structures

• Variables and Variable Types
• Range of Variables
• Constants
• Conditionals If… Then… Else…
• Select Case… End Case
• One-dimensional and two-dimensional Arrays
• Loop Types
• For…Next
• For Each…Next
• Do Until…..Loop
• Do While…Loop
• Goto Statement

Module 6: Introduction to Programming with Excel

• Property, Method and Event
• Select Cells
• Select Rows
• Select Columns
• Select Rows of Selected Cells
• Select Columns of Selected Cells
• Select Full Cells Around the Active Cell
• Find Out the Number of Selected Cells
• Find Out the Number of Columns and Rows of the Selection
• Find Out the Number of Selected Fields
• Run a Formula in a Cell
• Assign Value to a Cell
• Assign Value to the Selected Cell
• Automatically Fill Cells
• Assign a Random Value to a Cell
• Fill Target Cells with the Reference of Source Cells
• Change Cell and Font Type

Module 7: Check Errors

• Error Checking Statements
• Error Codes and Their Meanings

Module 8: Functions

• Create a Function
• Assign Parameters to the Function Type Procedures
• Create Custom Functions for Personal Reasons
• Use Functions in Excel

Module 9: The User Form and its Functions

• Create a New User Form
• Form Properties
• Form Events
• Add Controls to Forms
• Control Properties
• Control Events

Module 10: VBA Practice Examples

• Copy Tables between Pages
• Conditional Formatting
• Sorting
• Create Subtotals
• Create Charts
• Create Pivot Tables
• Create Data Entry and Query Form

Module 11: Excel – Access Relation

• Active Data Object (ADO)
• ADO Objects
• Connection Object
• Recordset Object
• SQL Query Language
• Move Data from Access to Excel

“Excel Productivity Training” is a special learning content considering the most frequent scenarios workers in the Finance, Budge-Reporting, Production, Planning, Business Development, Human Resources, Sales, Marketing, and IT departments face in the daily-used applications. You will learn the most important features in Excel, do your actions way faster and explore to ways that will increase productivity in your work life with this training.

Duration: 1 Day

Sequels: Excel Advanced, Excel Expertise, Excel Macro

*Sequel trainings are applied trainings and a placement test is done beforehand.

Module 1:

• We do not need shortcuts; we need the shortest cut. What are the most useful shortcuts?
• Create very long nested if formulas in one row with VLOOKUP!
• Get rid of error messages like #N/A, #Div that pollute your Excel Tables
• Convert values converted to text in calculation to numbers with (-)
• Methods that increase performance in formulas
• Create a Dependent Drop-Down List
• Highlight whole row using Conditional Formatting
• Highlight multiple cells in different field at once with format painter
• Write values into blank fields you have filtered at once
• Create New Custom Pivot Pages based on desired value in the PivotTable Report with one click!
• Eliminate duplicate records in the table
• Edit all the data in a row at once with Flash Fill
• Quick Filtering and Writing Including Formula with Wildcard Characters (*, ?)
• Learn quick formatting and custom formula structure by creating Dynamic Tables
• Make Table Title Renew on every page
• Prevent errors while printing the document
• Define custom names for cells to use tables easier in formulas
• Vertical/Horizontal pasting etc. with Pasta Special Options
• Quickly fill reports with blank cells coming from other programs
• Use mini charts
• Encryption in Excel
• Add Legends to Cells with Conditional Formatting in Tables
• Select visible cells only
• Limit the value entered in a cell by creating a Confirm Value rule with formula
• Prevent scientific number problem while writing very long numbers
• Display all formulas with one button to have a command of the document
• Have a command of the document by displaying source of formula with the Watch Window
• Quickly add date and time to cells
•  Change the cell format without changing the number/date/text valus of cells with cell formatting codes! For example, adding spaces into phone number.
• Make calculations in cells that contain errors like #N/A, #Name?
• Meet the Power BI Reports!

MODULE 2: NEW FEATURES IN EXCEL!

• Filter with automatically created buttons based on the data in tables *New
• Use the map chart *New
• Improvements of features that existed before but are way better now *New
• Create relations between tables in PivotTable *New
• Use Treemap Chart and Funnel Chart *New
• Use the new Ifs formula instead of the Nested If Formula *New
• Use Maxifs and Minifs *New
• Use Textjoin instead of Concatenate in Office 365 *New
• Recover not-saved workbooks *New
• Quickly display the last saved file *New
• Time grouping Date/Time Fields in the PivotTable like Quarter, Year, Month, Hour, Minute

*Module 2 will be explained as long as the company has the compatible MS Office version.

You can color your rows with your rules with Conditional formatting methods, add data entry rules to your cells and prevent incorrect data entry. You can make more comprehensive test with nester if functions. You can import data from a table and compare tables with the VLOOKUP function. You can shorten your functions with correct use of True-False statements. You can create report you want with just a few clicks by doing a detailed data analysis with Pivot Table, add filter buttons to your reports and charts filtered based on these buttons and thus make your reports impressive.

Duration: 2 Days

Module 1: Tables and Data Management

• Shortcuts/techniques that allow you to navigate, choose and enter data quickly
• Sort Based on Cell Value, Color, Alphabetic/Numeric/Custom Lists
• Group and Outline
• Filter
• Use the Advanced Filter Feature
• Use the Subtotal Function
• Eliminate Duplicate Values in Lists
• Data Merge

Module 2: Data Validation and Conditional Formatting

• Apply Data Validation to Cells
• Fix Excel Error Messages Concerning Data Validation
• Highlight Cells with the Desired Color with Conditional Formatting Settings
• Insert Symbols to the Cells with Conditional Formatting Settings
• Use Formulas in Conditional Formatting

Module 3: Functions

• Access Desired Values from Different Pages or Book with Look up and Database Functions (VLOOKUP, XLOOKUP, DSUM, DCOUNT, DAVERAGE, DMIN)
• Create Conditional Formulas with Logical Functions (If, And, Or, Nested If, SUMIF, COUNTIF)
• Use Logical Functions Special for Office 365 (Switch, Ifs, Maxifs, Minifs, TextJoin) *New Text Functions (Uppercase, lowercase, from Left, from Right, TextJoin, Crop)
• Use the Quick Fill Tool

Module 4: Cooperation

• Add and Delete Comments
• Display and Print Comments
• Share the Workbook and Co-author
• Tracking options
• Accept or Reject Changes

Module 5: What-If Analysis

• Use the Watch Windows
• Watch the Formulas

Module 6: Pivot Table and Pivot Chart

• Create a Pivot Table
• Edit a Pivot Table
• Find Out the Percentage of the Values on the Pivot Table Based on Desired Criteria
• Create Automatic Report Pages from the Pivot Tables Based on the Desired Criteria
• Update the Pivot Table Database
• Use Slicers
• Exploring New Slicer Features Special for Office 365 *New
• Create Custom Charts

Module 7: Distribution

• Inspect Document
• Mark as Final
• Run the Compatibility checker
• Add or Delete a Worksheet

Module 8: Security

• Protect a Workbook, Worksheet and Cells
• Provide Security in the Workbook
• Encrypt a Document
• Manage Permissions

Module 9: Macros

• Create Macros
• Save Macros
• Edit Macros

Module 10: New Applications in the Reporting Fields

Define the Relation between Excel and Power BI *New

Discover the Potential of Reporting with Power BI Dashboards

In this PowerPoint training, you will learn the basic rules you should pay attention to while presentation, how to add visual, auditory and graphical objects, use themes, see practices of applying formatting and editing settings and design impressive slides. You can add tables, charts, audios and videos to your presentations and learn how to edit them. Also, you can print slides in different formats and print it the way you want by learning printing settings. You can leave an impressive impression in your presentations by having control of the programs with what you have learned.

Duration: 1 Day

Module 1: Introduction

• Use the Backstage Button
• Use the Quick Access Button
• Customize the Ribbons
• Edit PowerPoint Options
• Use the “Tell me what you want to do” feature *New
• Display the older versions of the workbook *New

Module 2: Create a New Presentation

• Create a Presentation with Templates
• Analyze Slide Design Ideas
• Create a Custom Presentation
• Add and Edit a Text

Module 3: Display Presentations

• Navigate Between Slides
• Display Slides
• Use the Slide Show Display

Module 4: Slide Essentials

• Choose the Design Theme
• Work with Text Boxes
• Use Bullets and Numbers
• Work with Tabs
• Auto-correction Options

Module 5: Advanced Report Options

• Use the Spell Check
• Use the Synonyms & Lookup
• Work with Speaker Notes
• Add a Header & Footer
• Print the Slides

Module 6: Work with Images and Shapes

• Create a Photo Album
• Use the Insert Tab
• Insert ClipArt and Images to the Slides
• Work with Automatic Shapes
• Work with the Format Tab

Module 7: Work with Audio and Videos

• Add Audio and Videos
• Crop Videos
• Add a Bookmark to a Video
• Use Image Frame
• Reduce the Presentation Size by Compressing Videos

Module 8: Work with Tables

• Insert a Table to a Slide
• Use the Table Tabs
• Navigate and Choosing in a Table
• Add and Delete Columns & Rows
• Format the Table
• Add an Excel Table to the Slide

Module 9: Outline

• Add a Slide in the Outline View
• Edit Slides in the Outline View
• Send the Outline View to another Document

You can create professional presentations with PowerPoint by bringing audio-visual expressions (audio, video, Charts, Images, Shapes, Smartart, 3D Objects) together and creating impressive animations and intriguing expressions. In addition to that, you can crate main templates that express your corporate identity, spice up your presentation with Smart Art, Morph and 3D Objects and leave a strong impression on the audience.

Duration: 2 Days

Module 1: Work with Animations

• Use the Animation Tab
• Insert Entry & Exit Animation
• Add Emphasis
• Use the Motion Paths
• Edit the Animation Effects

Module 2: Duplicate and Arrange the Presentations

• Copy and Delete Slides
• Hide Slides
• Rearrange Slides
• Add Slide Transitions
• Morph *New
• Add 3-D Slide Transitions

Module 3: Manage the Slides

• Add Slides from other Slides
• Use the Find-Replace Feature

Module 4: Work with Charts

• Add a Chart
• Use the Chart Tab
• Format and Resize a Chart
• Connect the Power BI Charts *New
• Explore the New Chart Types Special for Office 365 *New

Module 5: Word Art & Smart Art

• Insert a WordArt Object
• Create a List
• Create Hierarchy
• Create Pyramid
• Modify SmartArt

Module 6: Work with Templates and Slide Masters

• Create and Edit a New Slide
• Add a Logo to Every Slide with Slide Master
• Change the Title Font of Every Slide with Slide Master
• Make Changes on Specific Slides with Slide Master

Module 7: Advanced Slide Options

• Work with Action Buttons
• Explanatory Notes for the Presentation
• Use the Slide Timing
• Slide Show Options
• Record Audio Narration of the Slide Show

Module 8: Save the Presentation for Web

• Save the Presentation as PowerPoint Show
• Save the Presentation as PDF
• Publish the Presentation on Web
• Package the Presentation for CD
• Save the Presentation as Video

Module 9: Cooperation

• Access to OneNote Documents and Giving a Link *New
• Track, Accept and Reject Changes on the Document
• Compare with Different Presentations
• Add, Display and Edit Comments
• Work Synchronously on the Same Document with OneDrive *New
• Document Protection: Restrict Editing *New
• Co-author on Slides by Sharing the Presentation *New

Module 10: New Features with Office 2016 and Office 365

• Add an Ink Equation and Symbols *New
• Other Features on the Draw Tab *New
• Work with 3D Models *New
• Design Ideas *New
• Auto-save *New
• Use the Transformation from Ink to Shape Feature *New
• Align with the Ruler *New
• Use the 3D Objects with the Morph Effect *New

You can easily learn how to do your e-mail actions with Outlook and comprehend options like formatting, adding a file, editing, searching for a post, responding, and printing. You can learn what expressions like Contacts, Calendar, Tasks mean and how to use them with practices. You can assign yourself a task and organize meetings in your company. Also, you can customize your Outlook by using the View Tab.

Duration: 1 Day

MODULE 1: EXPLORE THE OUTLOOK PROGRAMS

• Explore the Outlook Screen
• Arrange Outlook Menus
• To-Do Bar
• Use the “Tell me what you want to do” Feature *New

MODULE 2: PRIMARY E-MAIL ACTIONS

• Create and Send an E-mail Message
• Use the Message Tab
• Save Messages as Draft
• Add a File to the E-Mail Message
• Read the Messages
• Display the Attachments
• Respond and Forward Messages

MODULE 3: FORMAT THE E-MAILS

• Use the Format Text Tab
• Use the Quick Format Mini Toolbar
• Mark Important Messages
• Use the Find and Replace Tab

MODULE 4: USE THE CONTACTS SECTIONS

• Add and Edit a Contact
• Use the Contact Tab
• Add a Contact from an E-mail Message
• Send a Message on the Contact View
• Create and Use a Distribution List
• E-Mail Addresses, Send & Receive Options

MODULE 6: MANAGEMENT OF THE E-MAILS

• Delete a Message
• Empty the “Deleted Items” File
• Rename a File
• Move-Copy Messages and Files

MODULE 7: PRINT E-MAIL MESSAGES

• Use the Print Windows
• Print a Table etc. in a Short Note
• Print Files with Attachments

MODULE 8: MANAGING CONTACTS

• Find and Sort Contacts
• Edit and Delete Contacts
• Print Contacts

MODULE 9: CREATE A TASKS LIST

• Analyze the Outlook Calendar
• List the Tasks
• Assign Categories to Tasks

MODULE 10: ARRANGE A MEETING

• Respond to a Meeting Invitation
• View Calendars on Top of One Another
• Recommend a New Meeting Time
• Track Meeting Responds
• Update – Cancel a Meeting Invitation
• Printer and Calendar

You can do your e-mail actions, move your e-mails to files and to these moving actions with automatic rules with Outlook. Also, you can track appointments and organize meetings by using the calendar. You can add reminders to use your time more efficiently on Outlook, learn how to use categories, how to archive and move -emails and create auto-responds for when you are not at work. In addition to all these, you can work with shaped and images, and customize your Outlook.

Duration: 2 Days

MODULE 1: E-MAIL ACTIONS

• Sort Messages by different criteria
• Filter Messages by Multiple Criteria
• Filter Messages
• Edit Messages
• Unimportant E-Mail Options
• Create and Arrange Rules
• Edit and Delete Rules
• Use Conditional Formatting
• Grouping Options

MODULE 2: ARRANGE THE MESSAGE OPTIONS

• Change the Message Options
• Change the Message Format
• Use the Out of Office Assistant (Automatic Replies)
• Add “Hyperlinks” to Messages

MODULE 3: ARCHIVE OPTIONS

• Archive the Messages
• Manually Archive the Messages
• Automatically Archive the Messages

MODULE 4: ARRANGE THE CALENDAR OPTIONS

• Arrange Workdays and Hours
• Display the Extra Time Fields
• Arrange the Compliance Options
• Share and Publish the Calendar

MODULE 5: TRACK DAILY WORK ACTIVITIES AND RSS

• Auto-save Daily Entries
• Manually Save Daily Entries
• Change Daily Entries
• Use RSS

MODULE 6: TASK MANAGEMENT

• Assign Tasks
• Respond the Task Assignment Message
• Send a Task Update
• Forward Task Assignments

MODULE 7: USE PERSONAL FILES

• What Are Personal Files
• Create Personal Files
• Move and Copy Messages

MODULE 8: WORK WITH SHAPES AND IMAGES

• Use the Insert Tab
• Insert ClipArt and Images
• Automatic Draw
• Use the Format Tab
• Layer the Objects
• Add a WordArt Object
• Add a SmartArt Chart

MODULE 9: CUSTOMIZE OUTLOOK

Work with the Quick Access Toolbar

Customize Toolbars

Access is a database program developed by Microsoft. In our training, you will explore the Access interface first and then learn database, table, field, data type and relation notions with practices. You will learn how to add records, search, delete and how to exchange data between different platforms with database. Also, you will learn the basic rules to be careful about in managing the database and actively use table, query, form and report concepts.

Duration: 2 Days

Module 1: Overview of Access

• Access and Relational Databases
• Access Environment
• Use Office Desktop
• Database Components
• Use the Navigation Pane
• Use Help
• Start and Stop the Access Database

Module 2: Create a Database

• Data Types
• Create a Table in Datasheet View
• Create a Table in Design View
• Arrange Field Settings
• Determine a Primary Key
• Explore the Datasheet
• Arrange and Choose Table Data
• Add and Delete a Report
• Find and Replace
• Undo and Renew
• Relation Types
• Print Relations
• Sort Records in the Table

Module 3: Share Data

• Import Excel Files to access
• Copy the Table Structure and Data

Module 4: Query and Filter Options

• Use Filters
• General Filter
• Apply Filters Based on a Selection
• Advanced Filter
• Differences between Query and Filter
• Create a Query with the Simple Query Wizard
• Create a Query in Design View
• Add Criteria to a Query
• Add a Calculated Field
• Group the Data
• Use Parameters in Query
• Types of Joins

Module 5: Forms

• Create an Automatic Form
• Create a Form with the From Wizard
• Use the Design View
• Add Controls to the Form
• Use the Toolbar
• Add a Textbox
• Add Labels
• Add an Option Button
• Add a Check Box
• Add a Combo Box and Drop-Down List
• Add a Calculated Field
• Add Graphical Objects
• Create a Subform

Module 6: Reports

• Create Automatic Reports
• Create a Report with the Wizard
• Create a Report in Design View
• Format Controls
• Add Date and Time
• Add Page Numbers
• Add Graphical Objects
• Group Reports
• Sort Reports
• Use Page Break
• Create Calculated Controls
• Print the Report

Participants will manage the databases correctly by using features of Access, connect with the other programs and exchange data, use advanced query techniques and learn advanced database features and use them. Also, they will be able to create advanced forms and reports, write Sql queries. In addition to this, you can learn how to use macros in Access.

Duration: 2 Days

Module 1: Advanced Table Properties

• Field Properties
• Use Input Masks
• Use the Totals Row on Datasheet
• Use Rich Text Format in the Memo Data Type
• Connect Tables
• Use Linked Table Manager
• Share Data with Other Office Programs

Module 2: Import Data

• Import Tables
• Import XML Data to Access
• Import Data from a Sharepoint List
• Import Data from Excel
• Import Data from a Text File

Module 3: Use Advanced Query

• Create a Calculated Field
• Find Duplicates
• Create a Crosstab Query
• Action Queries
• Update Query
• Append Query
• Make Table Query
• Delete Query

Module 4: Advanced Form Options

• Use Field List Pane
• Use Form Controls
• Add and Format Labels
• Add Charts
• Add a Command Button
• Use the Label Wizard
• Add a Combo Box Field

Module 5: Advanced Report Options

• Use Report Controls
• Work with Page and Report Width
•  Arrange Field Properties
• Add Charts
• Put Report Data in Two Columns

Module 6: Advanced Database Properties

• Database Documenter
• Analyze the Performance of the Database
• Change the Version of the Database
• Compact and Repair a Database
• Backup a Database
• Split a Database
• Convert Access Database to MDE File
• Create a Switchboard
• Edit a Switchboard
• Create a Database Password

Module 7: Macros

• Create a Macro
• Run a Macro
• Create and Run a Group Macro
• Create a Macro with a Condition
• Assign Macros to Command Buttons
• Use Macros on Menu Options