икт 50-100

*!MS Аccess. Maximum numbers of symbols in «Memo»field

• 65.500

• 65.000

• 65.536

• 650.563

• 650.000

Relational database is the database which

• has file structure

• describes spreadsheets

• Has Boolean algebra as a base of it

• connects data by means of physical indicators

• consist of two dimensional table connected with themselves logically

The following operation is performed with records

 

• sort

• projecting

• forecasting

• exploitation

• searching on key

!MS Access program is constructed on the base

• C++

• Lisp

• Html

• MS Excel spreadsheets

• relational model of database management

The main object of database is

• form

• table

• macro

• module

• template

Creating of database includes

• stage of copying slides

• stage of output and project data

• stage of database project and input data

• stage of defining and deleting information

• stage of transmission and deleting of documents

The main types of MS Access models

 

• basic

• cyclic

• standard

• application

• relation

MS Аccess. Objects of database

• sort, filter

• book, sheets

• records , fields

• queries , tables

• investment , model

!MS Аccess. Types of data

• text

• financial

• graphical

• fractional

• percentage

MS Access. Type of query

 

• logic

• classic

• empty

• separate

• parameter