Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Use Access queries to archive old data
- Chances are you regularly access only a fraction of the Access records that live in your system—so why not archive the ones you don't use as often? It's not only possible but simple to selectively archive your Access databases. Mary Ann Richardson shows you how. An Access database can...
- Tags: Microsoft Access, Databases, Microsoft Office, Storage, Mary Ann Richardson, Workforce management, Click Employees table, Click Yes, Termination Date, Termination Date field, termination, database, Microsoft Office Suite Access Tips Newsletter, Employees Table, Enterprise Software, Software, Data Management, Office Suites, Human Resources, Hardware
- Technical articles 2006-10-24
Additional Resources
- Use an Access function to add a new field to your table
- You need to add a new field to a table in your Access database, but you don't have time to manually update hundreds of records. Discover how easy it is to add the field to your table. You are sending form letters to all your employees regarding their...
- Tags: Microsoft Access, Microsoft Office, Databases, Mary Ann Richardson, Microsoft Office Suite Access Tips Newsletter, Database, Table, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-05-30
- Ease Access database maintenance with the Alter Table command
- When you need to make a number of changes to your Access database, the Alter Table command can help. Learn how you can use the command to quickly add or delete fields in an Access table. When you need to make a number of quick changes to your ...
- Tags: Microsoft Access, Databases, Microsoft Office, Mary Ann Richardson, ALTER TABLE, Employees Table, database, Microsoft Office Suite Access Tips Newsletter, Storage, Enterprise Software, Software, Data Management, Office Suites, Hardware
- Technical articles 2006-03-14
- Use SQL to quickly create a new table from existing records in Access
- SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us. SQL Server lets you use one command to quickly create a new table ...
- Tags: Microsoft Access, SQL, Microsoft Office, Databases, Mary Ann Richardson, Fort Myers, new table, Microsoft Office Suite Access Tips Newsletter, Table, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-02-28
- Populate Info from table to access form
- I have a form that has SSN / Name / DOB / Servicing office employees table. Then I have the input table with SSN and other fields input table. On the form I have the SSN fields linked and then I call the SSN field on the form...
- Tags: SSN
- Q&A 2005-09-12
- Copy an existing table structure into a new Access database
- If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table structure to a new table in another database. Have you been eyeing a...
- Tags: Microsoft Access, Storage, Databases, Mary Ann Richardson, Microsoft Office, database, table structure, Microsoft Office Suite Access Tips Newsletter, Structure, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-26
- Access Query not doing what I need
- I have a database that has several tables that are all linked with a relationship on a field that contains a unique numeric ID. I need to run a query that pulls data from two of the tables and all attempts so far are not giving me the output...
- Tags: access, alcottrj@..., Microsoft Access, programming, queries, query, software, sql, Table B
- Discussion threads 2007-03-07
- Add a Total row to your Access 2007 table
- Before Access 2007, you could calculate totals on your data in query, report, or form view. Access 2007 lets you add a Total row field to your tables.For example, say you want to find out the average number of hours your employees worked per week in June. Follow these steps...
- Tags: tip, Office 2007, Microsoft Office, Access 2007, Access
- Blog posts 2007-07-24
- Create Access 2007 reports and forms from existing tables
- Access 2007 isn't totally foreign to your old databases. You can access and then import tables into the new version and create brand new forms and reports based on that data. Mary Ann Richardson tells you how. You are ready to start creating new reports, forms, and applications...
- Tags: Mary Ann Richardson, Microsoft Office Suite Access Tips Newsletter, Database, Microsoft Access, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2007-06-12
- Position your Word tables attractively on a page
- When working in Word, it's easy to align your tables to the surrounding text without dragging them there. Follow these steps for a streamlined look. Do your tables look out of place on the page? There's no need to try and click and drag them into place. Word's...
- Tags: Microsoft Word, Microsoft Office, Mary Ann Richardson, Word processors, Microsoft Office Suite Access Tips Newsletter, Table, Office Suites, Software
- Technical articles 2006-02-07
- Compare records in 2 tables and move data from one table to the other
- I have two tables with 3 columns in common: FirstName, LastName, Department. Table A Access table has additional columns (RecordID, Address, Phone, etc. This table is missing data in the some of the records in the Department field.Table B an Excel spreadsheet is missing no data in any...
- Tags: Microsoft Office, Table
- Discussion threads 2005-08-11
- Create a form-type Data Access page in Access
- It would be useful if your mobile users could view and edit data from their Access database anywhere, anytime from their mobile devices. Learn how to do just that by creating a form-type Data Access page that can be made accessible to your users over the Internet. Help users...
- Tags: Microsoft Access, Databases, Microsoft Office, Mary Ann Richardson, Data Access Page, data access, form-type Data Access page, database, Microsoft Office Suite Access Tips Newsletter, Data Page, Enterprise Software, Software, Data Management, Office Suites
- Technical articles 2005-04-12
- Use Access' Totals query to create summary reports
- In Access, you may find it difficult to assemble and summarize data from several tables. However, learn how to use the Totals Query—and get the last word on that stack of reports. Access reports that summarize data from multiple tables can be difficult to design from scratch. For...
- Tags: Microsoft Access, Microsoft Office, Databases, Mary Ann Richardson, Totals Query, OrderTotal, cell, Microsoft Office Suite Access Tips Newsletter, Table, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-09-05
- Most organizations wing it with new employees
- Most companies make job training a priority for new employees. But respondents to this IT Manager Quick Poll indicated that managers in their shop usually just wing it when training new employees.
- Tags: Job training, Recruitment & Selection, TechRepublic Staff
- Technical articles 2002-04-05
- Obtain quarterly records in Access with the DatePart function
- How did your company's stock fare last quarter? Who came aboard during the first quarter last year? Mary Ann Richardson shows how to use the DatePart function in Access to obtain quarterly results. IT managers often want to know data points about a particular quarter. If you need...
- Tags: Microsoft Access, DatePart, Microsoft Office, Databases, Mary Ann Richardson, Click New, cell, Microsoft Office Suite Access Tips Newsletter, Expression, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-04-25
- Let Word's Mail Merge feature insert Access data into your Word documents
- If you need to report on the latest data in the company's employee database and don't have Access, you can use Word's Mail Merge Directory feature. With this feature, you can quickly add data from any Access table into a table in any Word document. Follow these steps: ...
- Tags: Microsoft Access, Mail Merge, Cell, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-06-10
- How to integrate existing tables with a PowerPoint presentation
- You can create a table in PowerPoint, but if the table already exists in Word, why bother? It's more efficient to use an existing table. To insert an existing table into a PowerPoint presentation, do the following: With a slide in edit mode, choose Object from the Insert menu. (In ...
- Tags: Microsoft Word, Microsoft PowerPoint, PowerPoint Presentation, Table, Susan Harkins
- Blog posts 2007-08-24
- Include an attachment field with your Access 2007 database
- With Access 2007's new attachment fields, you can attach most file types to your database records. For example, suppose you want to include each employee's resume document with his/her record in your Employees database. Follow these steps: Open the Employees database. ...
- Tags: Database, Microsoft Access, Resume, Microsoft Office, Databases, Storage, Office Suites, Software, Enterprise Software, Data Management, Hardware, Mary Ann Richardson
- Blog posts 2007-10-09
- Using combined parameter queries in Access
- Access can help you easily find statistics on any set of data, but why not use Access to get information using a variety of parameters? Mary Ann Richardson explains how you can use combined parameter queries to get the information you need. Parameter queries are a powerful tool for...
- Tags: Microsoft Access, Microsoft Office, Databases, Mary Ann Richardson, Click New, criteria cell, Microsoft Office Suite Access Tips Newsletter, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2007-01-02
- Save time by creating tables from Access 2007 field templates
- Easily create fields for your tables by using Access 2007 field templates. A field template is a design for a field, complete with a name, data type, length, and predefined properties. All you need to do is decide which fields pertain to your data and then drag the appropriate field...
- Tags: tip, Microsoft Office, Access 2007, Access
- Blog posts 2007-07-17
- << Previous
- page 1 of 1
- Next >>