
Access -A software you use to create and manage databases. A form of DBMS (Data Base Mangement System).
Things you can have in a database: Tables, Queries, Pages, Macros, Modules, Reports and Forms.
Fields - Column headings.
Field size- default:50 characters (maximum 256 characters)
Fiddle around with all the features before database is created.
Different Data Types for settingup a table
-text and memo's are the same thing but memo's are longer (more limit).
-number - different types of numbers. 7 options. It affects how much storage space is neede for each number. It can be varied a bit.
-Date/time and currency - Part of a number that is set in a particular format/way.
-Auto number - This can be used as an ID field. IT makes sure you have a different number for each record
-yes/no - also called a boolean data field (field with only 2 options)
-OLE object - How they attach it to a database.
-Hyperlink - website
-Lookup Wizard - If you have a table already done. The lookup wizard helps you find the table. It is looking up what you neeed to find.
A Primary Key: A key field which will alow you to assicate a record in this table to a record in anothe table. It is some bit of data that is somewhat unique. Every table has their own unique key. If you don't have a primary key you can't link the table to other tables.
e.g in school system each student has an ID number which will make them unique.
The process involved in making a table is COLLECTING. If it was setup so that it would go in alphabetical order it would be ORGANISING.
Labels: Database, IPT, Microsoft Acces
TALK @ 10:23 AM