Nz Microsoft
Nz Microsoft
Tips and Tricks for working with Microsoft Access Reports
Manually Adding Grouping
1. Create report and click on View | Sorting and Grouping
2. Select field/s you want to group on Keep together property-
Yes – keeps together
With First Detail – keeps together and first record is kept with group header
Printing Data in Columns
File | PageSetup [Columns]
Printing Data in Columns with a Heading that Spans Columns
1. Create a report showing the data in columns and delete the page and report headers and footers.
2. Save the report.
3. Create another report with a header that spans the new report
4. Insert the other form as a subreport into the detail section of this report and resize so that it fills the width of the report.
5. Format borders as required
6. Save the report.
Numbering Records in a Report
1. Add an unbound text box to the detail section of the report
2. In the properties for the text box, click on the data tab
3. In the Control source property enter =1
4. In the Running Sum property select Over all or Over Group if the numbering needs to restart in each group.
Starting Page Numbering on a number other 1
1. In the footer add an unbound text box
2. Type the following into the text box =[Page]+the number you want to start on -1
Include a Running Total
1. Insert an unbound text box
2. In properties [Data] Control Source property choose the name of the field you want a running total for
3. Choose Over All or Over Group in the Running Sum property
Grand Totalling a Calculated Field
1. Use the Sum() function in the Report Footer (not Page Footer)
2. Use the same formula in the calculated field eg =sum([Fieldname]*[Fieldname])
Set Default Print Margins
Tools | Options [General]
Create a Page Break after Each Group
Add a page break in the Group Footer
OR
1. Select the Group Footer and open Properties [Format]
2. Set Force New Page property to After Section
Display Parameter Values in a Report
1. Create the parameter query and include the parameters as fields in the QBE grid – use exactly the same names eg [Start Date] as a parameter, would be something like Start: [Start Date] as a field
2. Create the report and use the fields wherever appropriate in the report, eg form report title control source may read:
="Customer Orders between" & " " & [Start Date] & " " & [End Date]
Open Report Based on a Single Record Shown in a Form
1. Create a report as usual
2. Create a macro:
Action: Open Report
Report Name: Name of Report
Where condition: [fieldname] = Forms![formname]![formcontrolname]
Fieldname is the unique reference that identifies the record
3. Drag the macro onto the form
Empty Calculated Fields
If some records show empty calculated fields this is because the calculated field value is Null. To covert Nulls to zeros use the NZ() function.
eg =NZ([Price])*.2
Column Headings in SubReports
Page headers and footers will not print – put headings in report header.
If the subreport goes over one page but headings in a group header.
Calculations in PageHeaders/Footers
Sum() does not work in a Page Header, therefore create the calculation elsewhere, such as the report footer and the create a text box that refers to that control in the page footer =[ControlName]
About the Author
Chester Tugwell is a freelance Microsoft Office trainer and owner of Blue Pecan Computer Training based in Sussex, UK. He provides a comprehensive set of Access training courses as well as other Microsoft Office training options.
How much could I sell my Graphics Card for?
NZ dollars, heres a currency converter: http://www.xe.com/
It came with my new computer and I'd like to upgrade. 9800 GT, the guy who made it said it came from pconlineshop.co.nz, so I had a look and these are all the details it provided:
NVidia GeForce 9800GT 512MB 256-bit DDR3 PCI-E Graphic Card
[POS9800GT512] $152.80
$157.38
GeForce 9800GT PCI-E 512MB 256-bit DDR3, 600/1800MHz, Dual DVI, HDCP, HDTV, FAN, 16x full-screen anti-aliasing, NVIDIA PureVideo HD technology, Two dual-link DVI outputs support two 2560x1600 resolution displays, power savings for everyday needs, Built for Microsoft Windows Vista.
How much could I sell it for?
£60 or so Sterling England Pounds UK
You work it out.
Nz Microsoft
Microsoft Dynamics CRM 2011 Automatic Bank Account Formatting Solution
Are Search Engine Rankings Dead?
There has been lots of chatter on the net about the future of search and in particular for website owners and SEO companies, whether they are going to be able to continue to achieve rankings in the Search Engines - or Are Rankings Dead?
To understand this issue better you need to be aware of three big changes that are affecting search results in Google and other top Search Engines right now and are rumoured to be the way of the web from mid 2009 onwards.
Personalised Search
(also known as Behaviour Based Search)
Google led the charge in providing personalised search results to its users based on their previous search history. With Google if you are logged into a Google Account while searching, the results that are returned to you are based on previous searches that you have made and more weight is given to websites that are likely to interest you.
This behaviour based searching is already in play with internet advertising as advertisers track your online activity (via cookies on your machine), build a profile and deliver advertising targeted to your needs and wants.
The feeling is that this type of activity will spread throughout the net and that other Search Engines will be delivering their results in this way - indeed the larger Search Engines are already trialing this new technology.
Localised Search
(incorporates Intent Based Search)
These days your location (what country you are in when you search), the location of your website (where it is hosted) and the TLD of your domain name (ie .co.nz, .co.uk) are all factors in serving up websites that are relevant to a user. Google already employ this search technology and other Search Engines are following suit. The assumption is that given your location your intent is to receive results that are relevant to that location.
Universal Search
In 2007 Google announced their move towards universal search:
"The Company will incorporate information from a variety of previously separate sources - including videos, images, news, maps, books, and websites - into a single set of results. At first, universal search results may be subtle. Over time users will recognize additional types of content integrated into their search results as the company advances toward delivering a truly comprehensive search experience"
Source: http://www.google.com/intl/en/press/pressrel/universalsearch_20070516.html
(Over the past 7 or 8 years Google has acquired more than 50 companies that specialise in such areas which means they have ready sources of data to call on.)
Shortly after this announcement Ask.com, Microsoft Live and Yahoo all rolled out their own versions of Universal Search.
The overall result is that Search Engines are all moving towards displaying multimedia results in search results. The impact on website rankings in this regard could be immense. It is considered that if a website does not take advantage of different media types within its pages it may begin to lose its share of rankings as the competitors that do incorporate multimedia into their sites gain from this.
So, back to my original question - "Are Rankings Dead?"
I don't believe so but I do feel that owing to the shift mentioned above, the days of being able to get definitive website rankings are numbered. There will, however, always be a need for competitor analysis, keyword research, best practice optimisation and popularity building techniques and website owners will need to consider the incorporation of different media types into their websites to be effective in Universal Search.
Determining the effectiveness of a website in the future will come down to sound traffic analysis through web server logs and analytic packages
About the Author
Karyn specializes in website optimisation and marketing. As co-founder and Operations Director of Apex Internet Ltd, Karyn now has ten years experience in optimising and promoting websites and has a wealth of knowledge in the industry. Karyn has worked on over 500 websites, spanning over 130 industries, for clients in New Zealand, Australia, UK and the USA. Whilst born and educated in New Zealand, Karyn has also travelled extensively throughout the US, Canada, UK and Europe and holds Business Management qualifications from the New Zealand Institute of Management (NZIM).
Nz Microsoft
