CA CS CIMA Prakash Somani (Landmark Group) (23512 Points)
17 July 2009
Access Reports: Tips and Techniques
Add Line Numbers and Shading to Reports
Sorting and Grouping Access Reports
Create An Alpha Roster with Two Columns
Create Form Letters Without Mail Merge
Use Existing PDF Forms in Access Reports
Create a Dynamic List of All Your Reports
Create a Top Nth By Group Report
Add Dynamic Icons to Reports
Apply a Filter to a Report using a Form Entry
CA CS CIMA Prakash Somani
(Landmark Group)
(23512 Points)
Replied 17 July 2009
Access Query: Tips and Techniques
AND vs OR in an Access Query Grid
Delete Records From a Table if They Exist in Another Table
Using the IIF Function
Using the Left and Right Functions
Using "Top Values" Criteria
A Clever "Find Duplicates" Trick
About the NZ() Function
Clever ways to use the Date() Function
Create a Cross Tab Query without the Wizard
Manipulating Data with the Query Builder
Smart Parameters
Using the Instr() function to parse strings in a query
Parameter Input that Accepts Multiple Parameters
Create a Running Sum in your Query
Get Records Above or Below the Dataset Average
Get Top Values per Group
Get Details and Totals in one Query
Create a Percent of Total Column in your Query
Easy way to Query only Workdays
CA CS CIMA Prakash Somani
(Landmark Group)
(23512 Points)
Replied 17 July 2009
Access Forms: Control Basics
Setting Startup Options
Aligning and Positioning Controls
Message Boxes and Input Boxes
Combo Boxes 1 (create basic combo box)
Combo Boxes 2 (linking two combo boxes)
Combo Boxes 3 (multiple column combo boxes)
Tab Control Basics
Using the Calendar Control
Subforms Part 1 - Using a Basic Subform
Subforms Part 2 Referencing a Subform
Using Access Slider Controls Download Sample File
Using the Web Browser Control Download Sample File
Using the Option Group Control
Show a Report on a Form (Using the Snapshot Viewer ActiveX Control)
CA CS CIMA Prakash Somani
(Landmark Group)
(23512 Points)
Replied 17 July 2009
Access Forms: Tips and Techniques
Enabling and Disabling Controls on a Form
Creating a Splash Screen
Making an Image Look and Act Like a Button
Poor Man's Progress Bar
Build a Custom Filter in Your Form
Build a Basic Login Form
Make a Form Auto Expand for Hidden Controls
Creating a Basic Search Form
Add Data from Unbound Text Boxes to a Table
Alternatives to Typing your Parameter Dates
Prevent a User from Closing your Application
Using a Recordset Clone for Quick Searches
Create Web Page Effects with the 'On Mouse Move' Event
Adding and Removing Items Between Two Listboxes
Using Conditional Formatting to Highlight records
Add E-Mail functionality to applications with SendObject Method
Quick and Easy Dynamic Sorting Functionality
Create the Illusion of Colored Tabs
How to Compact Database Every 5th closing Download Sample File
Dynamically Expand a Combo Box Horizontally
Creating a Custom Help File System for your Application
Allow Users to Zoom into Comment Fields
Input Tax Credit, GST refunds and Recovery of refunds- Roadblocks and way outs
GST LIVE Certification Course - 43rd Weekdays Batch(With Govt Certificate)
CAclubindia
