Access Basic (conducted in English) kursus

You will learn

Access is a user-friendly and efficient tool if you want to create smaller and medium sized databases. You can work with any kind of information. All it takes is for you to structure your data correctly and then you can type in, search and present your information in any way you want. You must only store your data once! So, in order to do that, you must split up your data in several tables which you then link together by using relations.

After the course you will be able to:

  • Design and create a database including:
  • Create tables and define data types and field properties
  • Create relations between tables
  • Create and save queries
  • Design and create user forms using control elements, such as drop-down boxes
  • Design and create reports using group sections and sorting
  • Understand how a database works
In the section below called “Course details” you will find detailed description of each subject in this Access course.

You get

Before the course
  • The opportunity to speak with one of our instructors about finding the right course for you.
During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.
After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

This Access course is a part of 4D's unique collection of English conducted courses for Office. You do not need to have previous experience with Access but we recommend that you show up in time on the day of the course, willing to learn, and we can promise you the best possible course experience.

Course Details

Getting Started with Access
I this module the Access interface is reviewed and how to navigate through the various objects.

The following will be covered:
  • The Access Interface
  • Tabs and Groups
  • The Navigation Pane in Access

Database Design with Access
In this module you’ll get an introduction to the theory behind the construction of a database. You will also get an understanding of relationships, keys and which problems may occur if the database is not built correctly from the beginning.

The following will be covered:
  • What is a Database?
  • Limiting the Database – which Information to Use
  • Database Design with Access
  • Using Normal Forms
  • Primary Keys
  • Relationships

Tables in Access
In this module you’ll learn to create tables, adding fields with different data types and managing field properties. Tables are the foundation in a database, and therefore it’s important to design them correctly.

The following will be covered:
  • Creating a Database in Access
  • Creating a Table
  • Fields and Data Types
  • Restricting Input by Using Standard Values, Input Masks, Validation Rules, Mandatory Characters etc
  • Navigating and Editing Data in Access
  • Sorting and Filtering
  • Importing/Exporting Data in Access
  • Changing the Table Layout

Creating Queries in Access
In this module you’ll learn to create queries, choosing information/fields from various tables. You’ll go through the many opportunities in building criteria’s, as you often want to see a selected outcome of your data set. It will also be shown how to make calculations and using totals.

The following will be covered:
  • What is a Query?
  • Datasheet/Design View
  • Extracting Data by Applying Criteria
  • Extracting from One or More Tables in Access
  • Calculated Fields
  • Combined Fields in Access
  • Extracting via User Input
  • Extracting with Totals

Forms in Access
In this module you’ll learn how to create and design Access forms. Learn how to create them with a nice layout, colors, and command buttons to open other forms, perform a search or print the current form. We look at the many wizards used to building forms.

The following will be covered:
  • What is a Form?
  • Form Design
  • The Form Wizard in Access
  • Adding Controls and Fields
  • Text Boxes, Combo Boxes, Command Buttons, other Objects and Their Properties
  • Adjusting and Placing Fields on a Form
  • Navigating and Editing Data in Access
  • Filtering on a Form
  • Calculated Fields and use of Functions
  • Navigation (Creating your Own Menu System)

Reports in Access
In this module the goal is to create good-looking reports, quickly and easily. Reports can be printed, but often they are just shown on the screen. Reports have the advantage that they can handle and display huge amounts of data, as data can be grouped and sorted. You have the same design features as when you design a form, but of course, no interaction with the user. You learn to insert formulas, controls, and to use different sections for inserting repeated content or headlines.

The following will be covered:
  • What is a Report?
  • Report Structures
  • The Report Wizard
  • Display Options in Access
  • Adding Controls and Fields
  • Guide to Text Boxes, Combo Boxes, Command Buttons and other Objects and their Properties
  • Designing a Report
  • Adjusting and Placing Fields in Formulas
  • Report Sections
  • Sorting and Grouping in Access
  • Editing and Printing
  • Calculated Fields and Adding Functions

Hvad siger vores kunder om os?

Se vores google reviewsPå Google Bussiness har vi en score på 4,8 af 5 fordelt på 256 reviews

Se vores facebook Reviews

På Facebook har vi en score på 5 af 5 fordelt på 162 reviews

 

 

Se alle vores reviews 

 

 

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Kejsergade 2, 3 sal
1155 København K
Kursusindgang
Kejsergade 2, 3 sal
1155 København K
Åbningstider
Mandag: 08.30 - 15.30
Tirsdag: 08.30 - 15.30
Onsdag: 08.30 - 15.30
Torsdag: 08.30 - 15.30
Fredag: 08.30 - 15.30

 

Kontaktoplysninger

 
Kejsergade 2, 3 sal
1155 København K