Utilizing Microsoft Office 2007 with Cimple.NETSlide 2
Microsoft Office 2007 and Cimple.NET gives a constant connection to Microsoft Office clients This permits you to utilize any of the information from the Cimple.NET Centralized Database inside Microsoft Office progressively The Cimple.NET Student Information System naturally keeps up the Centralized Database and guarantees information respectability and legitimacy, wiping out the requirement for learning on outlining, making, and keeping up making complex SIS databases When you make Queries, Reports, Labels, Charts, or Mail Merges in Microsoft Office, they consequently overhaul when a change is made in Cimple (i.e. constant) This is an amazingly capable component that takes into account complete customization and reconciliation with Microsoft Office NOTE: Real-time incorporation is accessible in Microsoft Office 2000 (running Service Pack 3) and Microsoft Office 2003. The elements, capacities, and wizards are to a great degree comparable, paying little heed to the variant of Microsoft Office that you utilizeSlide 3
Initial Setup Before you can utilize Microsoft Office 2007 with Cimple.NET, you should setup and arrange your workstation to get to your Cimple.NET database If your school area utilizes a Microsoft Access Database for Cimple.NET, you can connection to the tables specifically If your school locale utilizes a Microsoft SQL Server, you should build up an ODBC information sourceSlide 4
Connecting to SQL Server First, set up an ODBC association from your PC to the Cimple.NET SQL Server Second, make a clear Microsoft Access database Third, set up a connection between your Microsoft Access database and the Cimple.NET SQL Server utilizing the ODBC association Once these three stages are finished, your Microsoft Access database will turn into a constant connection to the Cimple.NET SQL Server. You can then utilize any information put away in the Cimple.NET SQL Server in Microsoft Office continuously.Slide 5
Connecting to SQL Server: Step 1 From the Start Menu, open the Control Panel.Slide 6
Connecting to SQL Server: Step 2 Switch the Control Panel to Classic View (utilize the connection on the left of the screen)Slide 7
Connecting to SQL Server: Step 3 Open the Administrative Tools envelope.Slide 8
Connecting to SQL Server: Step 4 Under Administrative Tools, open the Data Sources (ODBC) organizer.Slide 9
Connecting to SQL Server: Step 5 Choose the System DSN tab and after that tap the "Include" catch.Slide 10
Connecting to SQL Server: Step 6 Select "SQL Server" to and afterward click "Completion" to make another information source.Slide 11
Connecting to SQL Server: Step 7 Enter the name "cimple" and after that select the name of your Cimple.NET SQL Server. Click "Next" to proceed.Slide 12
Connecting to SQL Server: Step 8 Use the default confirmation alternative (Windows NT verification utilizing system login ID). Click "Next" to proceed.Slide 13
Connecting to SQL Server: Step 9 Check the crate named "Change the default database to" and after that select the " cimple " database. Click "Next" to proceed.Slide 14
Connecting to SQL Server: Step 10 Use the default SQL choices. Click "Completion" to finish the way toward setting up your ODBC information source.Slide 15
Connecting to SQL Server: Step 11 Click the "Test Data Source" catch. This will affirm that the association with the Cimple.NET SIS server is working effectively.Slide 16
Connecting to SQL Server: Step 12 The framework will demonstrate to you the consequences of the test. It ought to say, "TESTS COMPLETED SUCCESSFULLY!" Click "alright" to proceed.Slide 17
Connecting to SQL Server: Step 13 Now that the information source has been tried, click "alright" to proceed.Slide 18
Connecting to SQL Server: Step 14 The ODBC information source is presently made. You ought to now see " cimple " SQL Server recorded as a System Data Source. Click "alright" and afterward shut all windows.Slide 19
Create an Access Database: Step 1 Start Microsoft Access. Double tap the alternative to make another Blank Database.Slide 20
Create an Access Database: Step 2 You will be provoked for a filename. Enter the name "cimple" and after that tap the "Make" catch.Slide 21
Create an Access Database: Step 3 A clear database will be made. Microsoft Access will likewise make a clear table for you. This table is not required. Close the table named "Table1" by tapping the "X".Slide 22
Create an Access Database: Step 4 Right-tap the "Table1" clear table on the left and afterward pick "Erase" to erase the clear table. You now have a clear Microsoft Access Database.Slide 23
Link to Cimple.NET: Step 1 From the External Data tab, tap the "More" catch and after that pick "ODBC Database".Slide 24
Link to Cimple.NET: Step 2 Select the alternative to "Connection to the information source by making a connected table" and after that snap "alright".Slide 25
Link to Cimple.NET: Step 3 Select the "Machine Data Source" tab and after that pick the "cimple" information source. Click "alright" to proceed.Slide 26
Link to Cimple.NET: Step 4 Highlight the "DATA_STUDENT" and the "DATA_STUDENT _CUSTOM" tables. Click "alright" to proceed.Slide 27
Link to Cimple.NET: Step 5 The tables that you chose will now show up as connections. The symbols ought to resemble a globe with a bolt to one side.Slide 28
Link to Cimple.NET: Step 6 Remove the "dbo_" prefix of every table by renaming the connected tables. To rename, right-click every table and pick "Rename".Slide 29
Link to Cimple.NET: Step 7 After renaming the table, press the "Enter" key to spare the new name.Slide 30
Using Microsoft Office and Cimple.NET You now have a Microsoft Access database that is connected to the Cimple.NET SQL Server. This connected database record is put away in your "Archives" envelope and is named " cimple ". To get to it later on, basically double tap the " cimple " archive to open it. You can now utilize any Microsoft Office application (Word, Excel, Powerpoint , Access, and so forth.) to get to any information put away in the Cimple.NET SQL Server.Slide 31
Getting Started utilizing Microsoft Access: Queries Open the " cimple " Access database you made already. On the highest point of Navigation Pane, ensure "All Access Objects" is chosen. From the "Make" tab, pick the "Inquiry Wizard".Slide 32
Queries Select the "Basic Query Wizard" and the snap "alright".Slide 33
Queries From the "Tables/Queries" dropdown, select the "DATA_STUDENT" table.Slide 34
Queries Make beyond any doubt you generally include the " SchoolYear " and the "Dynamic" field to your question. To find the "Dynamic" field, click in the "Accessible Fields" list and more than once press the "A" key on the console until the Active field shows up. Tip: You can press the principal letter of any field name on the console to flip through all fields that start with that field name.Slide 35
Queries Add any outstanding fields that you might want in your question. On the off chance that sought, you can pick fields from an alternate information table. When you are done, click "Next" to proceed.Slide 36
Queries When provoked, select a "Point of interest" inquiry. This will permit you to see the greater part of the information in the fields that you chose. Click "Next" to proceed.Slide 37
Queries Enter a name for your question. Click "Completion" to make your inquiry.Slide 38
Queries The inquiry that you made will show the greater part of the fields you chose and the records that were found. See how the question acquires records for various school years and in addition Active and Inactive understudies.Slide 39
Queries To indicate extra parameters for your inquiry, from the "Home" tab, tap the "Outline View" catch.Slide 40
Queries Once in "Outline View", find the SchoolYear and Active segments. In the main Criteria column, enter a "8" for the 2007-2008 school year and enter a "Y" for Active understudies as it were. At that point, tap the "Datasheet View" catch to see the altered inquiry comes about.Slide 41
Queries Notice how the question changed. Presently, just dynamic understudies in the 2007-2008 school show up. It is critical to dependably incorporate the SchoolYear and the Active field in your questions on the grounds that the Cimple.NET database keeps up data on both dynamic and dormant understudies for various school years.Slide 42
Queries: Adding a Field If you neglect to incorporate a field when utilizing the Query Wizard, you can simply include it later. Find the field you wish to include the table above (e.g. DATA_STUDENT). Drag the field to one of the sections underneath to add the field to the questionSlide 43
Queries: Adding a Field The field ought to now show up in another segment You can the indicate any extra inquiry criteria for this field in the Criteria box Change your perspective to "Datasheet View" to see your adjusted inquirySlide 44
Queries: Adding a Field Notice how the question changed Also, see the quantity of records that the question returned additionally changedSlide 45
Queries: Moving/Deleting a Field Notice the small bar that shows up over the field name To choose a segment, snap this bar; when you do this, the whole segment will highlight itself By dragging this bar to another area, you can change the request in which the segments show up in the inquiry If you highlight a segment and after that press the "Del" catch on the console, it will expel the field from the question totallySlide 46
Queries: Sorting From the "Outline View", select Ascending or Descending for every field you wish to sort. Fields are sorted as per the pattern in which they show up, from left to right. To change the sort request, change the request in which the fields show up by moving the section to the fancied area.Slide 47
Queries: Saving To spare an inquiry, basically tap the "Plate" symbol in the upper left-hand corner. On the off chance that you neglect to spare, Microsoft Offi
Investigating Microsoft Office 2007 Windows XP Robert Grauer, Lynn Hogan, Keith Mulbery Focused ...
Data Innovation Partners Program presents: Microsoft ® Office 2007 Preparing Get up to speed wi ...
Prologue to .NET Themes to be secured MSDN Scholarly Union What is .NET? Tulane Client Bunch Env ...
Microsoft ® Office Preparing How the 2007 Office framework helps you to stay more secure Course ...
AgIT Upgrade December, 2006 Welcome and Plan Desktop IP Camcorder Establishments Microsoft Offic ...
Microsoft Office FrontPage 2003 Instructional exercise 1 – Making a Site Realize what FrontPag ...
B.b.D Data Apparatuses Brendan Doss Presentation Design Utilizing Microsoft Word to distribute a ...
Microsoft ® Office Visio ® 2007 Training. Get to know Visio. Course contents. Overview ...
Opening Outlook 2007. Go to Start, All Programs, Microsoft Office, then tap on Microsoft ... Off ...
When you first open Word 2007, you may be astonished by its new look. ... practice (requires Wor ...
February 2007: Germany (Federal Foreign Office) August 2007: Malaysia ... standard for Office. N ...
with Business Contact Manager, Publisher 2007, Power Point 2007> ... with Business Contact Manag ...
Visual Studio .NET consequently adds obliged records to source control when working with Visual ...
What is ADO.Net?. Database dialect talked by oversaw applicationsADO.net database gets to experi ...
AJAX Now with ASP.NET 2.0. Jim Zimmerman. AGENDA. Overview of AJAX Client Script Callbacks ...
Outline. . Procedural information. . Applied information. Genuine information. Heuristic learnin ...
Utilizing Microsoft Enterprise Desktop Virtualization (MED-V) to Solve Windows 7 Application Com ...
Motivation. Diagram of the Microsoft IT LandscapeWhy SAP BWWhat are we utilizing as a part of SA ...