LEARN MS-ACCESS TIPS AND TRICKSLEARN MS-ACCESS TIPS AND TRICKSLearn Mail Merge in MS-Access. Learn how to enhance your Microsoft Access Forms with 3D Headings and Animated Controls. Step by step tutorial to prepare Graph Charts in Access. Use of Office Assistant in Access. Easy to implement Examples and Codes. 
Articles
Reminder POPUPs
2007-09-12 15:57:00 The Reminder Popup is a Report that opens and displays its contents automatically and plays a background sound to remind about something that needs the User?s immediate attention. The Report is exported into an external independent file format (Access Snapshot File Format, need MS-Office 2000 or later) and opens it in an external Window.We can open and view Access Reports exported into Access Snapshot File Format independently without the use of Microsoft Access and easily transport the Report alone through e-mails and share with others.The reminder can be of any future event that falls between current date and within next 7 days or so that we need advance information about, like appointments, conferences, Birthdays etc.This action is programmed into the Control Screen module with the help of the Form_Timer() Event Procedure.We will try an example with the Employees Table from the Northwind.mdb database. Import the Employees Table from Northwind.mdb sample database. If you are no...
MS-Access and Graph Charts2
2007-09-05 06:36:00 Continued...If you have landed straight on this page please go through the earlier Post MS-Access & Graph Charts and then continue.Sample Data for Pie-ChartPie_TableDesc Veh_Sales Parts_Sales Service_SalesTotal Sales 450000 645000 25000Create a Table with the above structure and data and save it with the name pie_Table.Open a new Report in design view. Select Object? from Insert Menu, select Microsoft Graph Chart and Click OK. A Chart Object with default values is inserted on the Report.Click outside the chart on the report to de-select the chart and to come out of Edit Mode. Click again on the chart to select it, display the property sheet and change the following values:Size Mode = ZoomRow Source Type = Table/QueryRow Source = Pie_TableColumn Heads = YesLeft = 0.3?Top = 0.3?Width = 6.0?Height = 4.0?Double Click on the Chart. The Chart Formatting Toolbar will appear on the top. Select 3-D Pie Chart from the Chart Type Toolbar Options or...
MS-Access and Graph Charts2
2007-09-05 06:36:00 Continued...If you have landed straight on this page please go through the earlier Post MS-Access & Graph Charts and then continue.Sample Data for Pie-ChartPie_TableDesc Veh_Sales Parts_Sales Service_SalesTotal Sales 450000 645000 25000Create a Table with the above structure and data and save it with the name pie_Table.Open a new Report in design view. Select Object? from Insert Menu, select Microsoft Graph Chart and Click OK. A Chart Object with default values is inserted on the Report.Click outside the chart on the report to de-select the chart and to come out of Edit Mode. Click again on the chart to select it, display the property sheet and change the following values:Size Mode = ZoomRow Source Type = Table/QueryRow Source = Pie_TableColumn Heads = YesLeft = 0.3?Top = 0.3?Width = 6.0?Height = 4.0?Double Click on the Chart. The Chart Formatting Toolbar will appear on the top. Select 3-D Pie Chart from the Chart Type Toolbar Options or...
MS-Access and Graph Charts
2007-08-29 14:19:00 Access Reports are excellent in presenting information in Numbers and Text. But, Charts goes one step further in providing information in the form of pictures and a quick look at them says it all. If we know the simple rule that goes for a Chart then we can create Charts in Access. The simple rule is: show the change of an event over a period of time in the form of dots and lines in relation to the numbers that they represent rather than in numbers and text itself. You must know how to create MS-Access data into a form suitable for preparation of Graph s. To get some familiarity we will look into some examples that uses only one set of values and the data format that is needed for the graph.Events like the daily change of day temperature or the change of body temperature. of patients in a hospital, to monitor their condition, or the change of Gold price over a period of time etc. can be plotted in the form of Line/Bar Charts on a Graph Paper manually. The Scale of the Chart can be d... More About: Access
MS-Access and Graph Charts
2007-08-29 14:19:00 Access Reports are excellent in presenting information in Numbers and Text. But, Charts goes one step further in providing information in the form of pictures and a quick look at them says it all. If we know the simple rule that goes for a Chart then we can create Charts in Access. The simple rule is: show the change of an event over a period of time in the form of dots and lines in relation to the numbers that they represent rather than in numbers and text itself. You must know how to create MS-Access data into a form suitable for preparation of Graph s. To get some familiarity we will look into some examples that uses only one set of values and the data format that is needed for the graph.Events like the daily change of day temperature or the change of body temperature. of patients in a hospital, to monitor their condition, or the change of Gold price over a period of time etc. can be plotted in the form of Line/Bar Charts on a Graph Paper manually. The Scale of the Chart can be d... More About: Access
Reports - Page Border
2007-08-22 22:42:00 Drawing a Page Border is very easy in MS-Word and it is part of the Formatting Options and different artistic styles are also available. But when it comes to MS-Access we have to depend on Code to draw a Page Border before printing the Document. An Example Document image is given below:The above Document is imported from Northwind.mdb Database (visit the Page Saving Data on Forms not in Tables for location reference of the Database) without the Page Border (Catalog Report attached to Categories Table) and drawn a double-lined Page Border with the help of Code given below. If you would like to try it out on the same Report then Import the Categories Table and the Catalog Report from Northwind.mdb database. The Code can be used on any Report that you wish to draw the Page Border and the border will be drawn within the Margin settings of the Page. Public Function PageBorder(ByVal strReportName As String)Dim Rpt As Report, lngColor As LongDim sngTop As Single, sngLeft As SingleDim sngw...
Reports - Page Border
2007-08-22 22:42:00 Drawing a Page Border is very easy in MS-Word and it is part of the Formatting Options and different artistic styles are also available. But when it comes to MS-Access we have to depend on Code to draw a Page Border before printing the Document. An Example Document image is given below:The above Document is imported from Northwind.mdb Database (visit the Page Saving Data on Forms not in Tables for location reference of the Database) without the Page Border (Catalog Report attached to Categories Table) and drawn a double-lined Page Border with the help of Code given below. If you would like to try it out on the same Report then Import the Categories Table and the Catalog Report from Northwind.mdb database. The Code can be used on any Report that you wish to draw the Page Border and the border will be drawn within the Margin settings of the Page. Public Function PageBorder(ByVal strReportName As String)Dim Rpt As Report, lngColor As LongDim sngTop As Single, sngLeft As SingleDim sngw...
Highlighting Reports
2007-08-16 15:20:00 Analysis of data stored in Tables and providing resultant information in the form of Reports to the outside world is an important function of any Database Management System.An Access Application may contain several Tables logically related but maintained separately for easier handling. When it is time to prepare Reports related tables are selected and joined on common information in them, filtered and placed the output on Reports. Meaningful and timely Reports play a very important roll in decision making.Report designing is an Art in its own merit, like Form designing. MS-Access is equipped with excellent Report Designing Tools and with little practice you can master it.We have been asked to prepare a report on the Company?s Sales Team, to review their monthly Sales Target Achievement. A mandatory Target Amount of $100,000 is fixed on each member of the Team and the Management wants a month-end Report to review his or her performance. The management focuses on the performance of ...
Highlighting Reports
2007-08-16 15:20:00 Analysis of data stored in Tables and providing resultant information in the form of Reports to the outside world is an important function of any Database Management System.An Access Application may contain several Tables logically related but maintained separately for easier handling. When it is time to prepare Reports related tables are selected and joined on common information in them, filtered and placed the output on Reports. Meaningful and timely Reports play a very important roll in decision making.Report designing is an Art in its own merit, like Form designing. MS-Access is equipped with excellent Report Designing Tools and with little practice you can master it.We have been asked to prepare a report on the Company?s Sales Team, to review their monthly Sales Target Achievement. A mandatory Target Amount of $100,000 is fixed on each member of the Team and the Management wants a month-end Report to review his or her performance. The management focuses on the performance of ...
SAVING DATA ON FORMS NOT IN TABLE
2007-08-09 13:48:00 We normally save data in Table s, even though we enter them on Forms . We cannot save data on Forms as we do on Tables. But, we can definitely save some useful information on the Form itself without the support of data Table to store the values.Let us look into a situation where we need such a facility for our day-to-day activities. Assume that we want to open the Employees Form in data editing mode (not in data entry mode) with the last record that we were working on during earlier session, to continue our unfinished work from there. To do this, we must save the key information of the last worked record on the Form before closing the Employees Form.Import the Employees Table and Employees Form from the NorthWind.mdb sample database located at C:Program FilesMicrosoft OfficeOfficeSamples (MS-Office 2000) or C:Program FilesMicrosoft OfficeOffice11Samples (MS-Office 2003). Make a copy of this File to your current working folder so that whenever you need information from this ... More About: Data , Saving , Not I
Edit Data in Zoom-In Control
2007-08-02 13:02:00 While designing a Form, Report or Query certain properties of these objects we can Zoom in and edit the property values in a big window, like Record Source Property, Filter or Order By property etc. When you right-click on these properties a Shortcut Menu will open up with the Zoom... option in it (see the image below) and when clicked we can edit the property values comfortably in a big window.But this option is not available when editing data on Forms, for large Field Type like Memo or text fields that holds more data than it displays.The Zoom? Tool Button is available under Properties Category of Forms, Reports, Query and Index groups in the Built-in Shortcut Menus. We can make a copy of this button and paste it on our Custom Shortcut Menu or on the built-in Form View Control Shortcut Menu, as we did for Animated Floating Calendar and use it on our Forms, if needed.But we will do it differently. We are going to design our own Zoom In Control and it will be interesting to expl... More About: Data , Edit
Custom Menus and Tool Bars2
2007-07-27 07:41:00 Continued from earlier Post: Custom Menus and Tool barsOpen your database where we have created the Custom Menu Bar with the name MyMenuBar. Select Customize from Toolbars sub-menu of View Menu. Or you can right-click anywhere on the Menu Bar or Toolbar above and select Customize from the displayed Shortcut Menu.We can add built-in menu options from the Customize Control also without copying/dragging from other menus as we did in step 11 in the earlier Post. Click on the Commands Tab on the Customize Control. When you click on any of the Menu items on the left (in categories list) the built-in commands pertaining to that Menu is displayed in the Commands List at the right window. From here you can click and drag (no need to press and hold the Ctrl key) any option and place it on your Custom Menu Bar or Toolbar to organize the Built-in Options for the User.12. We will concentrate on our totally independent Menu Options: Data Files, Process & Reports and create our own Programs/Macr...
Custom Menus and Tool Bars
More articles from this author:2007-07-20 14:17:00 We already had a formal introduction to Custom Tool Bar, Submenus & Shortcut Menus through the earlier posts: Animated Floating Calendar & Calendar and Toolbars. We have seen how to reference individual Button to enable/disable it based on situations that demands it.Here, we will take a closer look at Custom Menu bars, Toolbars & Shortcut Menus. Since, it is a lengthy subject we are forced to split this into 2 or 3 Posts.MENU BARSWindows based Applications have a Menu bar at the top with titles like File, Edit, View, Insert etc. When we click on them a long list of Options like Sub-menus, Items with Description alone or with Button Images and Description appears in a drop down list. When we click on any of them the designated action defined on the menu option runs and we will get our work done. We can create a Custom Menu bar with our Application specific Menu Descriptions like Data Files to open Forms linked to Tables/Queries, Reports to preview and print Reports, Utilities for ... More About: Bars 1, 2, 3, 4, 5, 6, 7 |
|
 |
|
 |
