Psychology tasks

You need to solve a psychology assignment

MS ACCESS. STAGES OF CREATING MULTI-TABLE DATABASES.

CREATION OF A MULTI-TABLE DATABASE «COURSES».

CONSTRUCTING EMPTY TABLES IN «WIZARD» AND «DESIGNER» MODES. CREATING THE DATABASE SCHEMA.

WORKING WITH SUBSTITUTIONS

Mastering the stages of creating multi-table databases. Creating a multi-

table database «Courses».

Creating the «Courses» database file. Designing the «Students» table in «Designer» mode. Creating the «Specialization» table in «Designer» mode.

Designing the «Teachers» table in «Wizard» mode. Designing the «Groups» table in «Designer» mode.

Creating the database schema. Establishing relationships between tables.

Removing relationships between tables.

Creating substitutions. Removing substitutions. Creating substitutions for

the «Groups» table.

Filling empty database tables. Entering data directly into the «Specialization», «Teachers», and «Groups» tables. Entering data into the «Listeners» table by copying this data and from an Excel table.

Creating queries. Building the «Typing» query in «Design» mode. Refining the «Typing» query in «Design» mode.

Creating parameterized queries. Building the parameterized «Typing» query. Building the «Report» parameterized query.

Working with «Expression Builder». Inserting basic expressions into a query.

Creating crosstab queries. Creating the crosstab query «Prepared Listeners».

Working with forms. Developing a form for listener registration using the Form Wizard. Refining the listener registration form «manually» with the Designer. Creating a dropdown list field in the form.

Operations on records in forms. Entering records, copying, moving, and deleting them using the form. Sorting data in the form.

Creating and using reports in databases. Creating the «Typing» report using «AutoReport». Creating a parameterized report based on the «Report» query with the parameter «Listeners by specialization» using «AutoReport».

Using «Report Designer». Creating the «Reference» report based on the «Reference» query.

Preparing complex reports. Creating the «Group Lists» query. Creating the «Group Count» query based on grouping data from the «Group Lists» query.

Creating a cascade query «For Order» using «Design». Creating the «Order» report based on the «For Order» query. Creating the «Order» report by merging a Word document with the «For Order» query prepared in Access.

Creating a macro to run the «Listeners by specialization» query. Creating a macro to run the «Group Count» query.