To include the joined field, include the field name in the SELECT statement - in this case, Categories.CategoryID. In the preceding example, CategoryID is the joined field, but it is not included in the query output because it is not included in the SELECT statement. ON Categories.CategoryID = Products.CategoryID The following example shows how you could join the Categories and Products tables on the CategoryID field: SELECT CategoryName, ProductName However, you cannot join Single and Double types of fields. For example, you can join on AutoNumber and Long fields because they are like types. You can join any two numeric fields of like types. If you try to join fields containing Memo or OLE Object data, an error occurs. In contrast, to select all departments (even if some have no employees assigned to them) or all employees (even if some are not assigned to a department), you can use a LEFT JOIN or RIGHT JOIN operation to create an outer join. You can use INNER JOIN with the Departments and Employees tables to select all the employees in each department. Inner joins combine records from two tables whenever there are matching values in a field common to both tables. You can use an INNER JOIN operation in any FROM clause. If they are not numeric, the fields must be of the same data type and contain the same kind of data, but they do not have to have the same name.Īny relational comparison operator: "=," "," "=," or "." The names of the tables from which records are combined. The INNER JOIN operation has these parts: SyntaxįROM table1 INNER JOIN table2 ON table1. You can easily export data to Excel or map accounts or contacts in Google Earth or Google Maps.Combines records from two tables whenever there are matching values in a common field. Every column allows filtering (numerous ways to filter) This is an filtering by groups.įiltering by Query (these are queries the user has created in Microsoft Access)įiltering on a List screen. The database works in conjunction with Microsoft Word to provide custom word merge documents.įiltering and searching can be done in numerous ways. Reporting is usually customized for each client’s needs.Įmailing is very flexible and lets you send single or multiple custom emails with customizable email templates (txt and HTML) emails. There are a few types of reports available in this template. This is the list screen that list the activities. The detail screen shows information for one contact and all related information (Activities, Opportunities, Former Companies)Ĭontact Detail screen (Relationships Tab)Īn activity is used to record various types of information (appointments, meetings, phone call, emails, task/to dos etc…). The ribbon at the top allows for easy navigation to other areas of the program.Ĭontact Detail screen (General Tab). You can easily search or filter the list to find any contact’s information. The detail screen shows information for one account and all related information (contacts, Former Contacts, Activities, Opportunities, Invoices)Īccount Detail screen (Relationships Tab) The ribbon at the top allows for easy navigation to other areas of the program.Īccount Detail screen (General Tab). You can easily search or filter the list to find any account information. If you have a question about what kinds of functionality we can incorporate into a custom database feel free to contact us. Here are some screenshots from one of our CRM templates (see products for more info).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |