Course Outline

1. Introduction:

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

2. Support for existing databases Accessa:

  • Discussion of basic concepts related to databases
  • Opening and closing the database
  • Basic database objects and dependencies between them (tables, queries, forms and reports)
  • Operations on records (adding, deleting, modifying)
  • Record searching, sorting and filtering
  • Support for existing forms
  • Compacting and repairing the database

3. Tables:

  • Designing new tables
  • Types of fields and criteria for their selection
  • The role of the primary key
  • Modification of the structure of tables containing data
  • Data import to and from Excela

4. Relationships:

  • Links as a way of creating relationships
  • Create relationships in the Relationships window
  • Relationships: one-to-one, one-to-many, many-to-many
  • Defining referential integrity

5. Queries

  • Creating queries using the wizard
  • Creating queries in Design view
  • Creating queries based on one table and many tables connected by relationships
  • Types of couplings and their role
  • Data grouping and query calculations
  • Different types of queries (select, append, create tables, update, delete, crosstab)
  • A few words about the syntax and meaning of the language SQL
  • Formatting the results
  • Query parameters
  • Setting properties and formatting query results
  • Creating complex queries
  • Presentation of potential problems and ways to avoid mistakes

6. Cooperation between Exceland Accessem

  • Exporting, importing and combining data
  • Creating reports in Excelu based on data from Accessa

7. Forms and reports

  • Creating simple forms and reports using wizards

8. Work automation

  • Introduction to creating macros
 14 Hours

Number of participants

Price per participant

Testimonials (1)

Related Categories