School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become an Expert!

Join 300,327 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,931 people online right now. Registration is fast and FREE... Join Now!




MICROSOFT ACCES TABLES

 

MICROSOFT ACCES TABLES, need help

kean023

3 Feb, 2009 - 10:28 PM
Post #1

D.I.C Head
**

Joined: 29 Nov, 2008
Posts: 113

hello guys???/can u pls help me tables structure 4 microsoft acces????example tables???cause i want to create table for name.age,locatin,gender etc..please sir




i hv example of mysql tables


CODE
--
-- Table structure for table `ibwf_users`
--

CREATE TABLE IF NOT EXISTS `ibwf_users` (
  `id` int(100) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `pass` varchar(60) NOT NULL default '',
  `birthday` varchar(50) NOT NULL default '',
  `sex` char(1) NOT NULL default '',
  `location` varchar(100) NOT NULL default '',
  `posts` int(100) NOT NULL default '0',
  `plusses` int(100) NOT NULL default '0',
  `signature` varchar(100) NOT NULL default '',
  `avatar` varchar(100) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `site` varchar(50) NOT NULL default '',
  `browserm` varchar(50) NOT NULL default '',
  `ipadd` varchar(30) NOT NULL default '',
  `regdate` int(100) NOT NULL default '0',
  `chmsgs` int(100) NOT NULL default '0',
  `chmood` int(100) NOT NULL default '0',
  `shield` char(1) NOT NULL default '0',
  `gplus` int(100) NOT NULL default '0',
  `budmsg` varchar(100) NOT NULL default '',
  `lastpnreas` varchar(100) NOT NULL default '',
  `lastplreas` varchar(100) NOT NULL default '',
  `shouts` int(100) NOT NULL default '0',
  `pollid` int(100) NOT NULL default '0',
  `rbcid` varchar(255) NOT NULL default '',
  `hvia` char(1) NOT NULL default '1',
  `battlep` int(100) NOT NULL default '0',
  `fmsg` varchar(50) NOT NULL default '',
  `reputation` int(100) NOT NULL default '0',
  `ficon` varchar(50) NOT NULL default '',
  `ruse` int(100) NOT NULL default '0',
  `bwins` int(20) NOT NULL default '0',
  `bloss` int(20) NOT NULL default '0',
  `bcrew` varchar(50) NOT NULL default '',
  `shopssid` varchar(100) NOT NULL default '',
  `profileview` int(100) NOT NULL default '1',
  `theme` varchar(100) NOT NULL default 'style.css',
  `lastact` varchar(255) NOT NULL default '',
  `lastvst` varchar(255) NOT NULL default '',
  `perm` char(1) NOT NULL default '0',
  `subno` varchar(30) NOT NULL default '',
  `bank` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `ibwf_users`
--




i know that is only example 4 sql in php ...please i need sample tables for microsoft access thanks

User is offlineProfile CardPM
+Quote Post


Trogdor

RE: MICROSOFT ACCES TABLES

4 Feb, 2009 - 09:15 AM
Post #2

D.I.C Addict
Group Icon

Joined: 6 Oct, 2006
Posts: 619



Thanked: 14 times
Dream Kudos: 200
My Contributions
yes that is a table.
in access the datatypes might be different, and it might have a problem with the quotes around every columname.

Do you get any error?
User is offlineProfile CardPM
+Quote Post

P4L

RE: MICROSOFT ACCES TABLES

4 Feb, 2009 - 09:39 AM
Post #3

Geek 4 Life
Group Icon

Joined: 7 Feb, 2008
Posts: 2,163



Thanked: 16 times
Dream Kudos: 125
My Contributions
Just a quick blurp....with Access you will need to change the data types to plain names like 'int' would be changed to 'numbers' or 'varchar' to 'text'. If you try to run the code as is, you will get syntax errors out the end. I can try to clean it up. Also, for Access, remove the 'IF' statement as this is not supported in Access.

So the first line would look like this.

sql

CREATE TABLE `ibwf_users` (
`id` number)

User is offlineProfile CardPM
+Quote Post

kean023

RE: MICROSOFT ACCES TABLES

5 Feb, 2009 - 10:54 PM
Post #4

D.I.C Head
**

Joined: 29 Nov, 2008
Posts: 113

if i want to add column name like student number??


example



id Student number location
kean 12121121 philippines




how can i add student numbr and location sir??or can add more words??





User is offlineProfile CardPM
+Quote Post

General Adamus

RE: MICROSOFT ACCES TABLES

7 Feb, 2009 - 10:35 AM
Post #5

D.I.C Head
**

Joined: 5 Feb, 2009
Posts: 110



Thanked: 9 times
My Contributions
ALTER TABLE ibwf_users
ADD COLUMN StudentID int

Adamus

This post has been edited by General Adamus: 7 Feb, 2009 - 10:36 AM
User is offlineProfile CardPM
+Quote Post

ayman_mastermind

RE: MICROSOFT ACCES TABLES

8 Feb, 2009 - 08:42 AM
Post #6

human.setType("geek");
Group Icon

Joined: 12 Dec, 2008
Posts: 1,807



Thanked: 92 times
Dream Kudos: 525
My Contributions
@kean023, to add a new column such as student number, you will have to add it to the table from the design view.. this is very basic stuff... the basics of MS Access are usually self explanatory...i suggest you read a good MS Access basics tutorial since you seem to lack skills in the very basic stuff, and the mysql table you presented seems irrelevant... anyways check out these links:
http://databases.about.com/od/access/l/aaaccess1.htm
http://www.bcschools.net/staff/AccessHelp.htm
the second link is a very good tutorial, hope this helps, good luck wink2.gif

This post has been edited by ayman_mastermind: 8 Feb, 2009 - 08:45 AM
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/7/09 03:23PM

Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month