Web Design Tutorial

Citeste si progreseaza

Crearea unei tabele si definirea unei chei primare in Microsoft Acces

In Acces crearea unei tabele se poate realiza in 3 moduri:

  • design view
  • wizard
  • prin introducerea directa a datelor

Definirea unei chei primare in Microsoft Acces:

O cheie primara asigura unicitatea dateolr printr-un camp sau grup de campuri dintr-o tabela astfel:

  1. se deschide tabela in design view
  2. se selecteaza campul(sau grupul de campuri)
  3. din meciul Edit se selecteaza Primary Key
  4. In mod automat campul sau grupul de campuri devin indexate fara duplicari

Stabilirea unui index:

  • indexul este o structura  de date care permit accesarea rapida a datelor
  • in Acces un camp se poate indexa in 2 moduri(ambele tipuri de indexari pot saa admita valori nule
    • indexul fara dubluri se foloseste atunci cand vreti sa determinati in mod unic anumita linie
  • crearea unui index cu dubluri sau fara dubluri se face din : General -> indexed – se alege yes or no.

March 4, 2008 - Posted by | informatica |

1 Comment »

  1. publicati exemple de tabele in microsoft acces pls !!!

    Comment by alina | October 26, 2008 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: