</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">Scheduler for WinForms</div> <div id="PageTitle"><div id="PageTitleText">Creating a Bindable Microsoft Access Database</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="schedulerforwinforms7.html">Scheduler for WinForms Task-Based Help</a> > Creating a Bindable Microsoft Access Database</td></tr></table></div> <div id="BodyContent"> <p>To create a bindable Microsoft Access database:</p> <ol> <li>Create a new Microsoft Access database.</li> <li>Add tables with the fields and settings listed below.</li> </ol> <div style="WIDTH: 100%"> <table class="hs-box"> <tbody> <tr> <td class="hs-box-icon" valign="top"><img src="images/hs-note.gif"></td> <td class="hs-box-content" valign="top"><b>Note:</b> This topic assumes that you are familiar with creating a database in Microsoft Access and setting up tables. If you are a novice to Microsoft Access, please see the Microsoft Office Help for more information.</td> </tr> </tbody> </table> </div> <h2>Appointments Table</h2> <p>The following fields and settings are for the <b>Appointments</b> table:</p> <table> <thead> <tr> <th>Field Name</th> <th>Data Type</th> <th>Field Size</th> <th>Required</th> <th>Indexed</th> <th>Primary Key</th> </tr> </thead> <tbody> <tr> <td>AppointmentID</td> <td>AutoNumber</td> <td>Replication ID</td> <td>Yes</td> <td>Yes (No Duplicates)</td> <td>X</td> </tr> <tr> <td>Subject</td> <td>Text</td> <td>255</td> <td>Yes</td> <td>No</td> <td>--</td> </tr> <tr> <td>Location</td> <td>Text</td> <td>255</td> <td>No</td> <td>No</td> <td>--</td> </tr> <tr> <td>Start</td> <td>Date/Time</td> <td>--</td> <td>No</td> <td>No</td> <td>--</td> </tr> <tr> <td>End</td> <td>Date/Time</td> <td>--</td> <td>Yes</td> <td>No</td> <td>--</td> </tr> <tr> <td>Body</td> <td>Memo</td> <td>--</td> <td>No</td> <td>No</td> <td>--</td> </tr> <tr> <td>Properties</td> <td>Memo</td> <td>--</td> <td>No</td> <td>No</td> <td>--</td> </tr> </tbody> </table> <h2>Categories Table</h2> <p>The following fields and settings are for the <b>Categories</b> table:</p> <table> <thead> <tr> <th>Field Name</th> <th>Data Type</th> <th>Field Size</th> <th>Required</th> <th>Indexed</th> <th>Primary Key</th> </tr> </thead> <tbody> <tr> <td>CategoryID</td> <td>AutoNumber</td> <td>Long Integer</td> <td>Yes</td> <td>Yes (No Duplicates)</td> <td>X</td> </tr> <tr> <td>CategoryName</td> <td>Text</td> <td>255</td> <td>Yes</td> <td>Yes (No Duplicates)</td> <td>--</td> </tr> </tbody> </table> <h2>Contacts Table</h2> <p>The following fields and settings are for the <b>Contacts</b> table:</p> <table> <thead> <tr> <th>Field Name</th> <th>Data Type</th> <th>Field Size</th> <th>Required</th> <th>Indexed</th> <th>Primary Key</th> </tr> </thead> <tbody> <tr> <td>ContactID</td> <td>AutoNumber</td> <td>Long Integer</td> <td>Yes</td> <td>Yes (No Duplicates)</td> <td>X</td> </tr> <tr> <td>Name</td> <td>Text</td> <td>255</td> <td>Yes</td> <td>Yes (No Duplicates)</td> <td>--</td> </tr> </tbody> </table> <h2>Resources Table</h2> <p>The following fields and settings are for the <b>Resources</b> table:</p> <table> <thead> <tr> <th>Field Name</th> <th>Data Type</th> <th>Field Size</th> <th>Required</th> <th>Indexed</th> <th>Primary Key</th> </tr> </thead> <tbody> <tr> <td>ResourceID</td> <td>AutoNumber</td> <td>Long Integer</td> <td>Yes</td> <td>Yes (No Duplicates)</td> <td>X</td> </tr> <tr> <td>ResourceName</td> <td>Text</td> <td>255</td> <td>Yes</td> <td>Yes (No Duplicates)</td> <td>--</td> </tr> </tbody> </table> <a name="seealsobookmark"></a> <div class="SectionHeading" id="seealsoSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">See Also</span></div><div id="seealsoSectionContent" class="SectionContent"><div class="SeeAlsoLink"> <a href="mappingthemicrosofta.html">Mapping the Microsoft Access Database to a C1Schedule Control</a></div> </div> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright © <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a target="_blank" href="http://our.componentone.com/groups/">Product Support Forum</a> | <a target="_blank" href="http://feedback.componentone.com/forums/255782-winforms-documentation">Documentation Feedback</a> </div> </body> </html>