IT tutorials
 
Tags
 
Change page: < 1 2 3 4 >  |  Displaying page 1 of 4, items 1 to 30 of 109.
Microsoft Access 2010 : Create Custom Forms (part 4) - Using E-Mail Forms to Collect Data
If you employ Microsoft Outlook, you can create the forms of investigation which you can send to other people in the e-mails. When people answer, you can have access automatically to add the answers to a basic table of data.
Microsoft Access 2010 : Create Custom Forms (part 3) - Adding Subforms
So one-to-many relations exists between two tables, you can show the information of “that” and “much” on sides of the relations using a principal form and a subform
Microsoft Access 2010 : Create Custom Forms (part 2) - Adding Controls
Although controls of zone of text and label are the most common controls found in the forms, you can also increase your forms with many of other types of controls. For example, you can add groups of buttons of option, check boxs, and zones of list to the current people with choices instead of making them type entries in zones of text.
Microsoft Access 2010 : Create Custom Forms (part 1) - Modifying Forms Created by Using a Wizard
When a form is envisaged like primary method to enter new records, it includes usually all the fields of the fundamental table. The fastest manner to create a form which includes all the fields of a table is to use the tool of form.
Microsoft Access 2010 : The Linked Table Manager - Move and Update Table Links
The Linked Table Manager is an important tool for working with linked tables. It allows you to move tables to another folder or another drive and then update the link to that table.
Microsoft Access 2010 : Linking to Another Type of Database (part 2) - Linking to SQL Server Databases
In a system where you store your data solely in Access tables, the Access Database Engine supplies all data retrieval and management functions and handles security, data validation, and enforcement of referential integrity.
Microsoft Access 2010 : Linking to Another Type of Database (part 1) - Link to Excel Spreadsheets, Link to Other Databases
With Tables selected as the object type, right-click in the Navigation Pane and select Import and then Excel from the context menu. (Alternatively, you can select Excel from the Import & Link group on the External Data tab of the Ribbon.)
Microsoft Access 2010 : Sharing Data with Other Applications - Linking to Tables in Another Access Database
When you link to data in another database, the data remains in its source location. Access simply creates a pointer to the data.
Microsoft Access 2010 : Sharing Data with Other Applications - Importing ASCII Data
Mainframes and minicomputers often export data in the ASCII file format. When you import ASCII data, you often need to make some changes for Access to handle the data properly.
Microsoft Access 2010 : Sharing Data with Other Applications - Importing Spreadsheet Data
If you plan to import spreadsheet data on a regular basis, it is helpful to define a named range in the Excel spreadsheet, containing the data you wish to import. You can then easily opt to import the named range in step 6 each time that you execute the import process.
Microsoft Access 2010 : Sharing Data with Other Applications - Importing from Another Access Database
You can import objects (for example, tables, queries, reports) from one Access database into another. When you import an object, you are making a copy of the object. Any changes you make to the imported object do not affect the original object.
Microsoft Access 2010 : Sharing Data with Other Applications - Exporting to ASCII
ASCII is a standard file format that many programs can work with. Exporting to the ASCII format allows you to make the data in an Access database available to other applications.
Microsoft Access 2010 : Sharing Data with Other Applications - Exporting to an Excel Spreadsheet
You might want to export table data or query results to an Excel spreadsheet so that you can use Excel’s analytical features. You can accomplish this in many ways.
Microsoft Access 2010 : Sharing Data with Other Applications - Exporting to Another Access Database
When you export an object to another database, Access exports a copy of the object. When you choose Definition Only, Access copies just the object’s structure (no data) to the receiving database.
Microsoft Access 2010 : Sharing Data with Other Applications - Importing, Linking, and Opening Files
When you import data into an Access table, Access makes a copy of the data and places it in the Access table. After Access imports the data, it treats the data like the data in any other native Access table
Microsoft Access 2010 : Enhancing the Queries That You Build - Working with Outer Joins
Outer joins are used when you want the records on the one side of a one-to-many relationship to be included in the query result, regardless of whether there are matching records in the table on the many side.
Microsoft Access 2010 : Enhancing the Queries That You Build - Creating Totals Queries
Add to the query grid the fields or expressions you want to summarize. It’s important that you add the fields in the order in which you want them grouped. For example, Figure 1 shows a query grouped by country and then by city.
Microsoft Access 2010 : Enhancing the Queries That You Build - Using Aggregate Functions to Summarize Numeric Data
By using aggregate functions, you can easily summarize numeric data. You can use aggregate functions to calculate the sum, average, count, minimum, maximum, and other types of summary calculations for the data in a query result.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Action Queries (part 4) - Creating and Running Make Table Queries
Whereas an Append query adds records to an existing table, a Make Table query creates a new table, which is often a temporary table used for intermediary processing.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Action Queries (part 3) - Creating and Running Append Queries
You can use Append queries to add records to existing tables. You often perform this function during an archive process. First, you append to the history table the records that need to be archived by using an Append query. Next, you remove the records from the master table by using a Delete query.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Action Queries (part 2) - Creating and Running Delete Queries
Rather than just modify table data, Delete queries permanently remove from a table any records that meet specific criteria; they’re often used to remove old records. You might want to use a Delete query to delete all orders from the previous year, for example.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Action Queries (part 1) - Creating and Running Update Queries
You use Update queries to modify all records or any records that meet specific criteria. You can use an Update query to modify the data in one field or several fields (or even tables) at one time.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Parameter Queries
You might not always know the parameters for the query output when you’re designing a query—and your application’s users also might not know the parameters. Parameter queries let you specify specific criteria at runtime so that you don’t have to modify the query each time you want to change the criteria.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Getting Help from the Expression Builder
The Expression Builder is a helpful tool for building expressions in queries and in many other situations in Access. To invoke the Expression Builder, you click the Field cell of the query design grid and then click Build on the toolbar.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating Calculated Fields
One of the rules of data normalization is that you shouldn’t include the results of calculations in a database. You can output the results of calculations by building those calculations into queries, and you can display the results of the calculations on forms and reports by making the query the foundation for a form or report.
Microsoft Access 2010 : Enhancing the Queries That You Build - Building Queries Based on Multiple Tables - AutoLookup in Multitable Queries
The AutoLookup feature is automatically available in Access. As you fill in key values on the “many” side of a one-to-many relationship in a multitable query, Access automatically looks up the non-key values in the parent table.
Microsoft Access 2010 : Enhancing the Queries That You Build - Building Queries Based on Multiple Tables - Pitfalls of Multitable Queries
If you have properly normalized your table data, you probably want to bring the data from your tables back together by using queries. Fortunately, you can do this quite easily by using Access queries.
Microsoft Access 2010 : Relating the Information in Your Database - Establishing Referential Integrity
Referential integrity consists of a series of rules that Access applies to ensure that it properly maintains the relationships between tables.
Microsoft Access 2010 : Relating the Information in Your Database - Establishing Relationships in Access
To open the Relationships window, you must select Relationships from the Relationships group on the Database Tools tab of the Ribbon.
Microsoft Access 2010 : Relating the Information in Your Database - The Types of Relationships
Three types of relationships can exist between tables in a database: one to many, one to one, and many to many. Setting up the proper type of relationship between two tables in a database is imperative.
 
 
Top 10
 
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
programming4us programming4us
 
Popular tags
 
Video Tutorail Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS