MICROSOFT ACCES TABLES

MICROSOFT ACCES TABLES need help Rate Topic:

#1 kean023

D.I.C Head

Group: Members
Posts: 119
Joined: 29-November 08

Dream Kudos: 0

Posted 03 February 2009 - 10:28 PM

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

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

Was This Post Helpful? 0

Register for Free to Make These Ads Go Away!

#2 Trogdor

D.I.C Addict

Group: Contributors
Posts: 619
Joined: 06-October 06

Mac Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 200

Posted 04 February 2009 - 09:15 AM

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?

Was This Post Helpful? 0

#3 P4L

Geek 4 Life

Group: Contributor w/DIC++
Posts: 2,353
Joined: 07-February 08

Windows Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 150

Posted 04 February 2009 - 09:39 AM

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.

CREATE TABLE `ibwf_users` (
  `id` number)

Was This Post Helpful? 0

#4 kean023

D.I.C Head

Group: Members
Posts: 119
Joined: 29-November 08

Dream Kudos: 0

Posted 05 February 2009 - 10:54 PM

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??

Was This Post Helpful? 0

#5 General Adamus

D.I.C Head

Group: Members
Posts: 110
Joined: 05-February 09

Who Cares Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 0

Posted 07 February 2009 - 10:35 AM

ALTER TABLE ibwf_users
ADD COLUMN StudentID int

Adamus

This post has been edited by General Adamus: 07 February 2009 - 10:36 AM

Was This Post Helpful? 0

#6 ayman_mastermind

human.setType("geek");

Group: Greeters
Posts: 1,833
Joined: 12-December 08

Linux Favorite Browser Favorite Processor Favorite Gaming Platform Your Car
Dream Kudos: 525

Posted 08 February 2009 - 08:42 AM

@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.abo...l/aaaccess1.htm
http://www.bcschools.../AccessHelp.htm
the second link is a very good tutorial, hope this helps, good luck