Utilizing Microsoft Office 2007 with Cimple.NET.

Uploaded on:
Cimple.NET gives an ongoing connection to Microsoft Office clients ... Before you can utilize Microsoft Office 2007 with Cimple.NET, you should setup and arrange ...
Slide 1

Utilizing Microsoft Office 2007 with Cimple.NET

Slide 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 utilize

Slide 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 source

Slide 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 question

Slide 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 inquiry

Slide 44

Queries: Adding a Field Notice how the question changed Also, see the quantity of records that the question returned additionally changed

Slide 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 totally

Slide 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

View more...