ICT Dina

Operation with the data which is used to arrangement

• sorting of data

• archiving of data

• organization of data

• transmission of data

• formalization of data

MS Access. «Create» tab allows

• split the table, query and report

• perform auto format of the table

• create new table, form, report, query, macro and module

• create the page, form, template, report, query, slide and database

MS Access. Change the table structure

• table wizard

• design view

• datasheet view

• create new table

MS Access. A major database object used to display information in an attractive, easy-to-read screen format

• table

• form

• report

• query

MS Access. For copying records it’s necessary to select records and perform following command

• home - font - copy

• create - reports - copy

• home - data collection - insert

• home - clipboard - copy

!MS Access. The function of «AutoNumber» in «ID» field of database

• number the table

• sum of form numbers

• auto input of sequential numbers

• number of form records in consecutive order

There are in working area of MS Access:

• desktop, task area

• working area, task pane

• menu bar, toolbar

• database window and its objects windows

Commands of "Database tools" tab

• forms, reports, analyze and others

  d

• Import, export, collect data, analyze

• macro, show/hide, analyze, move data

• rich text, clipboard, records, sort and filter, find

MS Access. Records are sorted in increasing order

• 12, 144, 245, 53, 94

• $10, $25, $35, $50

• Lily, Rose, Carnation, Aster

• Folder, Directory, Container

12MS Access. Logical operator «not» is used to select

• coincident files

• coincident values

• coincident querie

• in coincident values