IKT 142

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. Functions of commands in 'Datasheet' tab

• 'Home' commands of MS Access

• are intended for working with tables

• provide supporting of created databases

• provide creating basic components of database

• are intended for organization exchange with external data

MS Access. Connected fields have

• two files but different types of data

• one file but different type of data

• different names and different types of data

• the same name but different type of data

• different names but the same type 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

• create new table, template, resume, query, slide and new database

MS Access. Change the table structure

• table wizard

• design view

• datasheet view

• create new table

• open the table and rename fields

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

• table

• form

• report

• query

• macros

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

• external data - clipboard - cut

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

• number the table

• sum of form numbers

• sum of report 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

• status bar, start button

• menu bar, toolbar

• database window and its objects windows

Commands of 'Database tools' tab

• forms, reports, analyze and others

• Import, export, collect data, analyze

• macro, show/hide, analyze, move data

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

• tables, clipboard, font, show and hide, find, representation