Поделиться
2_Concepts_of_DB_presentation_l1_v1.ppt
10.3.2.1 define data types of database fields
10.3.2.2 create a one-table database
10.3.2.3 create a multi-table database
10.3.2.4 create a form for data entry
10.3.2.5 create reports using extracted data
Database Management System (DBMS) - software for creating databases, storing and searching the necessary information in them.
DBMS features
Creating database structure
Filling the database with information
Editing the structure and content of the database
Sort information
Search for information in the database
The output of the necessary information on the monitor screen, in a file and on paper
Setting Database Security
Tables
Form
Queries
Reports
DATABASE Objects
Access Database Objects
Tables are the main objects of any database.
The tables store:
all data available in the database
base structure (fields, their types and properties).
Объект (закладка) таблицы
Способы создания
Access Database Objects
Queries - these objects are used to extract data from tables and present them to the user in a convenient way.
With the help of queries, such operations as data selection by a given criterion, their sorting and filtering are performed.
Using queries, you can perform data conversion according to a given algorithm, create new tables, perform automatic filling of tables with data imported from other sources, perform simple calculations in tables and much more.
Объект (закладка) запросы
Access Database Objects
Forms are tools for entering data or viewing data. Provide the user with the means to fill only those fields that he should fill.
At the same time, special controls (counters, drop-down lists, switches, checkboxes, and others) can be placed in the form to automate input.
Закладка «Формы»
Access Database Objects
Reports are designed to output data to a printing device (for example, a printer).
They take special measures to group the output data and to output special design elements specific to printed documents (header and footer, page numbers, service information about the time the report was created, etc.).
Macros automate the execution of a specific database operation without programming.
The modules contain programs in Visual Basic language, used to configure, design and expand the database.
Access pages are intended for viewing and working over the Internet with data stored in MS Access or MS SQL Server databases.
Research
Find information about creating reports and forms in MS access database
What types of information systems exist?
Whole group discussion
Time to complete - 10 minutes
Reflection
Wish tree
Материалы на данной страницы взяты из открытых источников либо размещены пользователем в соответствии с договором-офертой сайта. Вы можете сообщить о нарушении.
