Tutorials Për Access dhe Excel
Access Tutorials
Access Improving Your Reports
Create a Top Nth by Group Report
Create an Alpha Roster with Two Columns
Creating Dashboards with Access Reports
Creating Form Letters with and without Mail Merge
Sorting and Grouping in Access Reports
Use an Existing PDF in an Access Report
Add a Line Number and Shading to a Report
Building a Dynamic Report List
Access - Query Tricks for Non Programmers
Create a Percent of Total Column
Easy way to Query Workdays
Get a Running Summary in you Query
Get Details and a Total Summary in one Query
Get Top Values Per Group
Parameter Box that Accepts Multiple Parameters
Using the Instr() function
Working with Sub Select Statements
AND vs OR in an Access Query Grid
Clever Trick to Delete Duplicates
Create a Cross Tab Query without the Wizard
Delete Problem
Manipulating Data with Queries
Smart Parameters
Using the Date Function in Queries
Using the IIF() function
Using the Left() and Right() function
Using the NZ() function
Using the Top Values Criteria
Access - Basics
Access Macros
Linking Tables
Schedule Compact
Schedule Macro
Access - User Form Basics 1
Access Slider Controls
Aligning and Positioning Controls in Access
Basics of the Calendar Control
ComboBox 1 - Create Basic ComboBox
ComboBox 2 - Linking ComboBoxes Together
ComboBox 3 - Working with Multiple Columns in a ComboBox
Create a Splash Screen
Message Boxes and Input Boxes
Access - User Form Basics 2
Access Subforms 1
Access subforms 2
Basics of the Tab Control
Setting Startup Options in Access
Using the Option Group Control
Using the Web Browser Control
Access - User Form Tricks 1
Add Animation and Sound to a Splash Screen
Add Information from Unbound TextBoxes to a Table
Add Quick and Easy Sorting functionality
Build a Custom Filter in a form
Compact Database every 5th Closing
Create a Basic Login Form
Dynamically Expand a Combo Box
Access - User Form Tricks 2
Add data from Unbound TextBoxes toa table
Alternatives to Typing in you Data Parameters
Basics of the RecordsetClone
Building a Poor Man's progress Bar
Create a Basic Search Form
Create Illusion of Colored Tabs
Prevent users from closing your application
Access - User Form Tricks 3
Add email to your Apps with SendObject functionality
Auto Expand a form for Hidden Controls
Create a Custom Help System
Create Web Effects with Mouse Move
Make buttons Look and Act Like a Button
Move data from one listbox to another
Using Conditional formatting to Highlight a Record
Download
Kodi HTML:
http://rapidshare.de/files/12694900/Access_-_Basics.rar 10.37 MB
http://rapidshare.de/files/12696211/Access_-_Improving_your_Reports.rar 30.55 MB
http://rapidshare.de/files/12697537/Access_-_Query_Tricks_for_Non_Programmers.rar 31.83 MB
http://rapidshare.de/files/12698401/Access_-_User_Form_Basics_1.rar 20.18 MB
http://rapidshare.de/files/12699161/Access_-_User_Form_Basics_2.rar 18.52 MB
http://rapidshare.de/files/12700062/Access_-_User_Form_Tricks_1.rar 20.88 MB
http://rapidshare.de/files/12700913/Access_-_User_Form_Tricks_2.rar 19.99 MB
http://rapidshare.de/files/12701777/Access_-_User_Form_Tricks_3.rar 21.03 MB
Password: timetable
Excel Tutorials
Excel - Building Applications with Excel
Basics of Recording Macros
Calling Excel Dialog Boxes
Cleaning up your Excel Macros
Excel SendMail Method
Excel Spreadsheep controls
Excel User Form Starter
Force Users to Enable Macros
Tying Excel Macros Together
Excel - Basic Concepts
Basics of Print Setup Options
Basics of Subtotals
Conditional Format with Four Conditions
Excel Formatting Tricks
Grouping Tabs to Save Time
Basics of Conditional Formatting
Basics of Protecting a Worksheet
Using autofilter in excel
Using Data Validation in Excel
Using Goal Seek
Using Paste Special
Using Text to Columns
Excel - Advanced Functions 1
Easy Fromula to Turn Dates to Quarters
Finding Duplicates with COUNTIF()
Increase the number of available undo actions
Matrix Lookup Formulas (Index and Match)
Setting a Duplicates Warning with Data Validation
Sort on Colour
Transpose Entire Dataset
Using IF(AND) and IF(OR)
Using Text Functions in Excel
Using the SubTotal Function to Calculate Filtered Data
VLOOKUP Formulas Made Easy
Excel - Advanced Functions 2
Add Dynamic Icons to Pivot Table Reports
Alternate Shading with Cconditional Formatting
Basics of Nested Formulas
Conditional Format with Four Conditions
Dynamic Ranges Explained
Easy Formula to Fix Trailing Minus Signs
Grouping Tabs to Save Time
Sort by Capitalization
Using Cell Information Functions
Using Conditional Sums and Array Formulas
Using the SUMPRODUCT() Function
Excel - Charts 1
Combo Charts and Formatting Data Points
Create a Histogram Chart
Create a Benchmark Chart
Create Organizational Chart
Formatting Charts
Invert Negatives in a Chart
Simple Thermometer Charts
Use Excel Charts in PowerPoint
Using Dynamic Chart Labels
Excel - Charts 2
Add Average Line to Your Chart
Create Basic Speedometer Chart
Create a Basic WaterFall Chart
Create a Scroll Bar Chart
Creating a Delta Chart
Getting Graphical Without Charts
Working with Bar to Pie Charts
Excel - Pivot Tables 1
A - Create a Basic Pivot Table
B - Sorting in a Pivot Table
C - Adding a Calculated Field in a Pivot Table
D - Grouping in a Pivot Table
E - Creating a Drill Down Effect in a Pivot Table
F - Using Pivot Table Advanced Options
G - Creating Pivot Charts
H - Tie a Pivot Table to Chart
I - Convert Your Table in Hard Data
Excel - Pivot Tables 2
J - Table Structures...Good and Bad
K - Synchronizing 2 Pivot Tables with a Combobox
Multiple Consolidation Range Pivot Tables Explained
Pivot Table Based Conditional Chart
Pivot Tables and Spreadsheet Bloat
Download
Kodi HTML:
http://rapidshare.de/files/12702881/Excel_-_Advanced_Functions_1.rar 24.37 MB
http://rapidshare.de/files/12704142/Excel_-_Advanced_Functions_2.rar 23.20 MB
http://rapidshare.de/files/12705218/Excel_-_Basic_Concepts.rar 23.93 MB
http://rapidshare.de/files/12706044/Excel_-_Charts_1.rar 20.20 MB
http://rapidshare.de/files/12706911/Excel_-_Charts_2.rar 22.33 MB
http://rapidshare.de/files/12707744/Excel_-_PivotTables_1.rar 19.92 MB
http://rapidshare.de/files/12708817/Excel_-_PivotTables_2.rar 26.85 MB
http://rapidshare.de/files/12709564/Excel_Building_Applications_with_Excel.rar 19.75 MB
Password: timetable
Visual Basic for Applications - Tutorials
VBA Tutorials
Declarations
DoLoop
ForEach
ForNext
IfStatement
Overview
References
Selectcase
Download
Kodi HTML:
http://rapidshare.de/files/12710094/Visual_Basic_for_Applications_-_Tutorials.rar 13.74 MB
Password:timetable
__________________
Sponzoret Mbajn forumin tonë dhe të juaj
www.kosovanetworks.com
Webdesign / Hosting / Domain
-----------------
www.Voipkosovasite.com
Voip Phone Call
Muhamet R.
Shiko Profilin Publik
Dërgo një mesazh privat tek Muhamet R.
Dërgo E-mail Tek Muhamet R.
Vizito Faqen E Internetit të Muhamet R.!
Gjej më shumë postime nga Muhamet R.
Shto Muhamet R. Në Listën E Shokëve
06-14-2006, 04:04 PM #2
bobkimja
Anëtar i ri
Eshtë Regjistruar: Apr 2006
Postet: 49
Postimi origjinal është bërë nga JoKeR
Access Tutorials
Access Improving Your Reports
Create a Top Nth by Group Report
Create an Alpha Roster with Two Columns
Creating Dashboards with Access Reports
Creating Form Letters with and without Mail Merge
Sorting and Grouping in Access Reports
Use an Existing PDF in an Access Report
Add a Line Number and Shading to a Report
Building a Dynamic Report List
Access - Query Tricks for Non Programmers
Create a Percent of Total Column
Easy way to Query Workdays
Get a Running Summary in you Query
Get Details and a Total Summary in one Query
Get Top Values Per Group
Parameter Box that Accepts Multiple Parameters
Using the Instr() function
Working with Sub Select Statements
AND vs OR in an Access Query Grid
Clever Trick to Delete Duplicates
Create a Cross Tab Query without the Wizard
Delete Problem
Manipulating Data with Queries
Smart Parameters
Using the Date Function in Queries
Using the IIF() function
Using the Left() and Right() function
Using the NZ() function
Using the Top Values Criteria
Access - Basics
Access Macros
Linking Tables
Schedule Compact
Schedule Macro
Access - User Form Basics 1
Access Slider Controls
Aligning and Positioning Controls in Access
Basics of the Calendar Control
ComboBox 1 - Create Basic ComboBox
ComboBox 2 - Linking ComboBoxes Together
ComboBox 3 - Working with Multiple Columns in a ComboBox
Create a Splash Screen
Message Boxes and Input Boxes
Access - User Form Basics 2
Access Subforms 1
Access subforms 2
Basics of the Tab Control
Setting Startup Options in Access
Using the Option Group Control
Using the Web Browser Control
Access - User Form Tricks 1
Add Animation and Sound to a Splash Screen
Add Information from Unbound TextBoxes to a Table
Add Quick and Easy Sorting functionality
Build a Custom Filter in a form
Compact Database every 5th Closing
Create a Basic Login Form
Dynamically Expand a Combo Box
Access - User Form Tricks 2
Add data from Unbound TextBoxes toa table
Alternatives to Typing in you Data Parameters
Basics of the RecordsetClone
Building a Poor Man's progress Bar
Create a Basic Search Form
Create Illusion of Colored Tabs
Prevent users from closing your application
Access - User Form Tricks 3
Add email to your Apps with SendObject functionality
Auto Expand a form for Hidden Controls
Create a Custom Help System
Create Web Effects with Mouse Move
Make buttons Look and Act Like a Button
Move data from one listbox to another
Using Conditional formatting to Highlight a Record
Download
Kodi HTML:
http://rapidshare.de/files/12694900/Access_-_Basics.rar 10.37 MB
http://rapidshare.de/files/12696211/Access_-_Improving_your_Reports.rar 30.55 MB
http://rapidshare.de/files/12697537/Access_-_Query_Tricks_for_Non_Programmers.rar 31.83 MB
http://rapidshare.de/files/12698401/Access_-_User_Form_Basics_1.rar 20.18 MB
http://rapidshare.de/files/12699161/Access_-_User_Form_Basics_2.rar 18.52 MB
http://rapidshare.de/files/12700062/Access_-_User_Form_Tricks_1.rar 20.88 MB
http://rapidshare.de/files/12700913/Access_-_User_Form_Tricks_2.rar 19.99 MB
http://rapidshare.de/files/12701777/Access_-_User_Form_Tricks_3.rar 21.03 MB
Password: timetable
Excel Tutorials
Excel - Building Applications with Excel
Basics of Recording Macros
Calling Excel Dialog Boxes
Cleaning up your Excel Macros
Excel SendMail Method
Excel Spreadsheep controls
Excel User Form Starter
Force Users to Enable Macros
Tying Excel Macros Together
Excel - Basic Concepts
Basics of Print Setup Options
Basics of Subtotals
Conditional Format with Four Conditions
Excel Formatting Tricks
Grouping Tabs to Save Time
Basics of Conditional Formatting
Basics of Protecting a Worksheet
Using autofilter in excel
Using Data Validation in Excel
Using Goal Seek
Using Paste Special
Using Text to Columns
Excel - Advanced Functions 1
Easy Fromula to Turn Dates to Quarters
Finding Duplicates with COUNTIF()
Increase the number of available undo actions
Matrix Lookup Formulas (Index and Match)
Setting a Duplicates Warning with Data Validation
Sort on Colour
Transpose Entire Dataset
Using IF(AND) and IF(OR)
Using Text Functions in Excel
Using the SubTotal Function to Calculate Filtered Data
VLOOKUP Formulas Made Easy
Excel - Advanced Functions 2
Add Dynamic Icons to Pivot Table Reports
Alternate Shading with Cconditional Formatting
Basics of Nested Formulas
Conditional Format with Four Conditions
Dynamic Ranges Explained
Easy Formula to Fix Trailing Minus Signs
Grouping Tabs to Save Time
Sort by Capitalization
Using Cell Information Functions
Using Conditional Sums and Array Formulas
Using the SUMPRODUCT() Function
Excel - Charts 1
Combo Charts and Formatting Data Points
Create a Histogram Chart
Create a Benchmark Chart
Create Organizational Chart
Formatting Charts
Invert Negatives in a Chart
Simple Thermometer Charts
Use Excel Charts in PowerPoint
Using Dynamic Chart Labels
Excel - Charts 2
Add Average Line to Your Chart
Create Basic Speedometer Chart
Create a Basic WaterFall Chart
Create a Scroll Bar Chart
Creating a Delta Chart
Getting Graphical Without Charts
Working with Bar to Pie Charts
Excel - Pivot Tables 1
A - Create a Basic Pivot Table
B - Sorting in a Pivot Table
C - Adding a Calculated Field in a Pivot Table
D - Grouping in a Pivot Table
E - Creating a Drill Down Effect in a Pivot Table
F - Using Pivot Table Advanced Options
G - Creating Pivot Charts
H - Tie a Pivot Table to Chart
I - Convert Your Table in Hard Data
Excel - Pivot Tables 2
J - Table Structures...Good and Bad
K - Synchronizing 2 Pivot Tables with a Combobox
Multiple Consolidation Range Pivot Tables Explained
Pivot Table Based Conditional Chart
Pivot Tables and Spreadsheet Bloat
Download
Kodi HTML:
http://rapidshare.de/files/12702881/Excel_-_Advanced_Functions_1.rar 24.37 MB
http://rapidshare.de/files/12704142/Excel_-_Advanced_Functions_2.rar 23.20 MB
http://rapidshare.de/files/12705218/Excel_-_Basic_Concepts.rar 23.93 MB
http://rapidshare.de/files/12706044/Excel_-_Charts_1.rar 20.20 MB
http://rapidshare.de/files/12706911/Excel_-_Charts_2.rar 22.33 MB
http://rapidshare.de/files/12707744/Excel_-_PivotTables_1.rar 19.92 MB
http://rapidshare.de/files/12708817/Excel_-_PivotTables_2.rar 26.85 MB
http://rapidshare.de/files/12709564/Excel_Building_Applications_with_Excel.rar 19.75 MB
Password: timetable
Visual Basic for Applications - Tutorials
VBA Tutorials
Declarations
DoLoop
ForEach
ForNext
IfStatement
Overview
References
Selectcase
Download
Kodi HTML:
http://rapidshare.de/files/12710094/Visual_Basic_for_Applications_-_Tutorials.rar 13.74 MB
Password:timetable
Njeri shum i cmuet je me punen qe je ka e bon per kfg thnx