Database questions (1 Viewer)

bradical

Member
Joined
Oct 17, 2003
Messages
44
What is a query, report and form and what are eached used for.

and what is a primary key and its purpose.
 

...

^___^
Joined
May 21, 2003
Messages
7,723
Location
somewhere inside E6A
Gender
Male
HSC
1998
ok

query=a search of the database for records that meet a certain condition

report=a tool in database that organises and presents the data

form=in a database to view, enter and change data in a table, in often displays single records

primary key=a single key in a database that must have a value
 

Winston

Active Member
Joined
Aug 30, 2002
Messages
6,128
Gender
Undisclosed
HSC
2003
Query, is a search based upon the criteria inputed

Primary key if i remember right is what unique identifies a table or record

Report, is where the contents of a table is represented in a report layout that can be easily read

A form is a document created to provide a layout that a user can use to enter the required information
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top