1-50 ИКТ (540-сұрақ) сессия

Operation with the data which is used to arrangement

• sorting of data

• transmission of data

• organization of data

• archiving of data

MS Access. Functions of commands in “Datasheet” tab

• "Home" commands of МS Аccess

• are intended for working with tables

• provide supporting of created databases

• provide creating basic components of database

MS Access. Connected fields have

• one file but different type of data

• different names and different types of data

• different names but the same type of data

• the same name but different type of data

MS Access. «Create» tab allows

• 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

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

• 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

• sum of form numbers

• sum of report numbers

• number of form records in consecutive order

• auto input of sequential numbers

There are in working area of MS Access:

• database window and its objects windows

• working area, task pane

• status bar, start button

• menu bar, toolbar

Commands of "Database tools" tab

• 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