<div>
1. Click the Create tab on the Ribbon to display the icons for creation functionality.<br />
2. Click Query Design in the Queries section.<br />
3. Place below code<br />

<pre><code class="code-1 nolinks" id="code-20-41465856-1"><span>CREATE TABLE [Your Table Name)</span>
<span>(</span>
<span>UsrMsgUID AUTOINCREMENT PRIMARY KEY,</span>
<span>UsrMsg CHAR(255),</span>
<span>HideUsrMsg Bit</span>
<span>)</span>
</code></pre>
4. Save query<br />
5. Open in design mode and execute<br />
<br />
Best Regards
</div>


<div>
Thanks Mohit. &nbsp;<br />
<br />
I should have been more clear. &nbsp;I need to run the whole process as a function in VBA as part of an automatic data conversion on client machines.
</div>


<div>
Okay, are you asking for VBA function to create table?
</div>


<div>
Perfect. &nbsp;Thank you very much.
</div>


<div>
<div class="content wysiwyg-content">
How can I create the following table using the CREATE TABLE method in MS Access.<br />
<br />
UsrMsgUID &nbsp; &nbsp; &nbsp;AutoNumber, Primary key, indexed<br />
UsrMsg &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text 255<br />
HideUsrMsg &nbsp; &nbsp; &nbsp;Boolean<br />
<br />
Thanks in advance.
</div>
</div>


How can I create the following table using the CREATE TABLE method in MS Access.

UsrMsgUID      AutoNumber, Primary key, indexed
UsrMsg             Text 255
HideUsrMsg      Boolean

Thanks in advance.

How to create a table using CREAT TABLE in MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.