This allows you to create and manage your database much more efficiently than a manual database.
What is computerised databases?
100
This stores data about a specfic topic.
What is a table?
100
This is a selected field or fields in a table that uniquely identifies a record.
What is a primary key?
100
This determines how a field is stored,works and is displayed.
What is properties?
200
The process by which information is organised and stored in a computer in such a way that there is efficient retrieval, updating and manipulation of data.
What is database management?
200
A database that links together logically related data stored in several files or tables.
What is relational databases?
200
Datasheet View , Design View , Table Wizard
What are three ways tables can be created?
200
This speeds up the operations of the database.
What is an index?
200
Field size and format
What are the properties of a database?
300
This is a piece of software used to create and manage a computerised database.
What is a database package?
300
An option you can select and manipulate
What is an object?
300
Number
Text
Memo
Date/Time
Currency
Autonumber
What are the different data types?
300
Not allowed to be null values , sorts records according to the values in the fields.
What are characteristics of a primary key?
300
This specifies the number of characters you want it to have
What is a field size?
400
This is like a filing cabinet in which you might keep all related information on a particular subject.
What is manual databases?
400
This is the entire database
What is a database file?
400
This method is the easiest and fastest way of creating a table.
What is a table wizard?
400
Make
Order Date
Purchase Date
Serial Number
The serial number.
Which one can be used to set a primary key?
400
This property determines the way the field is displayed or printed.
What is format?
500
Database operators require training,which may take some time .
What is a disadvantge of computerised databases?
500
Each field in the table.
What is table definiton?
500
This is when you open a table in design view and select primary key from the edit menu.
How do you deselect a primary key?
500
Input Mask , Currency Format , Date Format , Number Format , Text And Memo Format.