информатика2

*!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

• *consists 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

• *С

• *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 document

*!The main types of MS Access models

• *basic

• *cyclic

• *standard

• *application

• *relational

*!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

*!MS Access. Methods of creating tables

• *table wizard

• *simple table

• *project table

• *classic table

• *table design