Curso de Access - podstawy

Código del Curso

accbas

Duración

14 horas (por lo general 2 días incluidas las pausas)

Descripción General

Microsoft Access is a pseudo-relational database engine from Microsoft.

Programa del Curso

1. Introduction:

What are relational databases?
When and why should you consider using them
Why Access is such an attractive database


2. Support for existing Access databases:

Overview of basic concepts related to databases
Opening and closing the database
Basic database objects and relationships between them (tables, queries, forms, and reports)
Record operations (add, remove, modify)
Search records, sort and filter
Support for existing forms
Compacting and repairing a database


3. Tables:

Designing new tables
Types of fields and criteria for their selection
Role of primary key
Modify the structure of tables containing data
Import data to and from Excel


4. Relationships:

Links as a way to create a relationship
Create relationships in the relationship window
Relationships: one-to-one, one-to-many, many-to-many
Definition of integrity constraints


5. Query

Create queries using the wizard
Create Queries in Design View
Creating queries based on a single table and multiple relational tables
Types of couplings and their role
Grouping data and calculations in queries
Different types of queries (selecting, joining, creating tables, updating, removing, crossing)
A few words about the syntax and meaning of SQL
Formatting results
Query parameters
Set properties and format query results
Create complex queries
Presentation of potential problems and ways to avoid mistakes


6. Excel collaboration with Access

Export, import and merge data
Create reports in Excel based on data from Access


7. Forms and reports

Create simple forms and reports with wizards


8. Automation work

Introduction to creating macros

Testimonios

★★★★★
★★★★★

Categorías Relacionadas

Cursos Relacionados

Promociones

Descuentos en los Cursos

Respetamos la privacidad de su dirección de correo electrónico. No vamos a pasar o vender su dirección a otros.
Siempre puede cambiar sus preferencias o anular la suscripción por completo.

Algunos de nuestros clientes

is growing fast!

We are looking for a good mixture of IT and soft skills in Spain!

As a NobleProg Trainer you will be responsible for:

  • delivering training and consultancy Worldwide
  • preparing training materials
  • creating new courses outlines
  • delivering consultancy
  • quality management

At the moment we are focusing on the following areas:

  • Statistic, Forecasting, Big Data Analysis, Data Mining, Evolution Alogrithm, Natural Language Processing, Machine Learning (recommender system, neural networks .etc...)
  • SOA, BPM, BPMN
  • Hibernate/Spring, Scala, Spark, jBPM, Drools
  • R, Python
  • Mobile Development (iOS, Android)
  • LAMP, Drupal, Mediawiki, Symfony, MEAN, jQuery
  • You need to have patience and ability to explain to non-technical people

To apply, please create your trainer-profile by going to the link below:

Apply now!

Este sitio en otros países / regiones