Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 10+ tips for working efficiently in Access? Query Design window
- This article is also available as a PDF download.To create an Access query, you use the Query Design window. Youspecify a few data sources and fields, add a criteria expression or two,and perhaps specify a sort order. What you might not realize is that there'smore to working in this window...
- Tags: Databases, Susan Harkins, QBE, QBE grid, Query Design window, Query Design, grid, window, Microsoft Access
- Technical articles 2007-04-03
Additional Resources
- How to create a QBE that calculates Extended price minus Discounts.
- I've create a Purchase Order Database for my employer. This is my first effort. I've managed to create a query that calculates 'UnitPrice' by 'Quantity' and have named that expression as "ExtendedPrice". What I now need to do is create a calculation that subtracts the Discounts[percentages] from the ExtendedPrice. ...
- Tags: pilgrim001@...
- Discussion threads 2007-06-05
- 10+ tips for working efficiently in Access' Query Design window
- If you create Access queries, you probably know your way around the Query Design window. But there are some not-so-obvious tricks you can use to work more efficiently, maintain accuracy, and ensure database integrity. Access expert Susan Harkins outlines a variety of techniques, including several ways to add fields...
- Tags: Microsoft Access, Window, Microsoft Office, Databases, Construction, Office Suites, Software, Enterprise Software, Data Management
- Download resources 2007-04-03
- Lost in forms and paramaters
- Hello folks, I am current in a reporting role at my job and I am working on a project where I am trying to make a form in Access that will enable to update to SQL Server Tables in the background. I was trying to use stored procedures to update...
- Tags: Databases, Forms, search form, SQL
- Discussion threads 2005-04-28
- 10 tips for working with dates in Microsoft Access
- This article is also available as a PDF download.Working with dates in Access can be somewhat confusing. Fortunately,Access offers the Date/Time data type, which greatly simplifies the job ofhandling dates. In addition, you'll find a number of functions that manipulatedate values and components. But even with all the built-in help,...
- Tags: Calculating Julian, Ctrl, current date, Microsoft Access, Microsoft Corp., Susan Harkins, Value at Risk
- Technical articles 2006-11-13
- How do I... Generate a running total in an Access query?
- This article is also available as a PDF download.Displaying subtotals, grand totals, and otherwisesummarizing data is a common report feature. You can display a running total ina report simply by setting a property. A runningtotal is a cumulative sum that evaluates the previous rows and the currentrow. In other words,...
- Tags: Displaying, Microsoft Access, SQL, Susan Harkins, Value at Risk
- Technical articles 2006-12-04
- An IT manager explores COMDEX: Day 3
- If you have a flexible training budget, should you spend that money on trips to COMDEX? IT manager Mark D. Gonzales discusses his decision to do just that, and he describes his final day at the Las Vegas trade show.Editor’s Note: This week, the IT Manager Republic will feature journal...
- Tags: Monitors & displays, Web site development, Notebooks, Mark D. Gonzales, COMDEX, monitor
- Technical articles 2000-12-06
- A look at Comdex 2000 from a mail administrator's perspective
- So you didn't get to Comdex in Las Vegas this year? No problem. TechRepublic's Christopher Tellez will give you a 30,000-foot view of some of the products and services featured at the big show.I went to Las Vegas and gained 10 pounds in one day. No, I didn’t spend all...
- Tags: PDAs, E-mail servers, Handhelds, Christopher Tellez, COMDEX, mail administrator, Personal Computing Tablet, administrator
- Technical articles 2000-12-07
- << Previous
- page 1 of 1
- Next >>
