Du er her: Søg IT kursus /
Access 2010 Basic (conducted in English), 4D Konsulenterne
Access 2010 Basic (conducted in English)
|
Kursusinfo
|
|
|||||||||||||
Access 2010 Basic (conducted in English)
Kursusmål
Access is a database program that allows users to process any type of information. This Access 2010 course will provide you with a sound understanding of many of its basic, relevant and most commonly used functions. This newly acquired understanding will allow you to work with Access 2010 independently, in a structured manner and far more efficiently than before. This course is also relevant for you, if you are working with Access as a part of Office 365.
Deltagere
The course is aimed at those who need and/or wish to learn the basic, relevant and most commonly used functions in Access 2010, allowing them to work independently and efficiently with the program. You do not need to have previous experience of Access, but we assume that all participants are familiar with using a PC and have a level of knowledge equivalent to our Windows (XP, Vista, 7) Basic course.
Kursusmateriale
A combination of theory, in-depth questions and practical exercises is designed to give participants the full benefit of the course. To support these exercises you will be given comprehensive course materials. In order to maintain and develop your Access skills we recommend that you use the course materials as a handy reference guide after the course. If you require more help, you are always welcome to contact our tutors with more in-depth queries etc.
Kursus indhold
Getting Started with Access 2010
I this module the Access interface is reviewed and how to navigate through the various objects.
- 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.
- What is a Database?
- Limiting the Database – which Information to Use
- Database Design with Access 2010
- 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.
- Creating a Database in Access 2010
- 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 2010
- Sorting and Filtering
- Importing/Exporting Data in Access 2010
- 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.
- What is a Query?
- Datasheet/Design View
- Extracting Data by Applying Criteria
- Extracting from One or More Tables in Access 2010
- Calculated Fields
- Combined Fields in Access 2010
- Extracting via User Input
- Extracting with Totals
Forms in Access 2010
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.
- What is a Form?
- Form Design
- The Form Wizard in Access 2010
- 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 2010
- Filtering on a Form
- Calculated Fields and use of Functions
- Navigation (Creating your Own Menu System)
Reports in Access 2010
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.
- What is a Report?
- Report Structures
- The Report Wizard
- Display Options in Access 2010
- 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 2010
- Editing and Printing
- Calculated Fields and Adding Functions
Spar helt op til 40% med et:
4D Klippekort:http://www.4d.dk/Priser/Klippekort/Pages/klippekort.aspx
Vi har mange Access kompetencer - se alle vores::
Access ydelser:http://www.4d.dk/Produkter/Office/Access
Er I flere - skræddersy kurset med eksempler fra jeres hverdag:
Læs mere om firmakurser:http://www.4d.dk/kursus/kursustyper/Pages/kursus_typer.aspx
Eksamen og diplom
77-885 MOS: Access 2010:
http://www.4d.dk/Tests/Office/Access/2010/77-885
Pris
4D Konsulenterne
Microsoft kurser og certificeringer
4D Konsulenterne er eksperter i IT kurser og Microsoft certificeringer. Mere end 7000 tilfredse kursister om året, nyder godt af vores gennemarbejdede kursusmaterialer og højt kvalificerede undervisere. Både 2008 og 2009 er 4D kåret af Microsoft som Årets Learning Partner. Noget vi er meget stolte af.
Som Danmarks største udbyder af Office kurser, finder du altid mange dato at vælge imellem.
Teknisk træning - som Microsoft Gold Partner leverer vi MCP kurser, specielle Certificeringsforløb og Microsoft Partner uddannelse.
Vores instruktører er blandt Danmarks højest certificerede og løser også konsulentopgaver.
Se opdateret kursuskatalog nedenfor, hvor du finder kursusdatoer og kan læse mere om indholdet på kurserne.
Du er altid velkommen til at kontakte os for at få mere at vide om kursustyper, metoder, priser og få sparring på uddannelse, der dækker præcist dit - eller jeres firmas - behov.
Køb flere kurser - Klippekort
Har du brug for en rabatordning, der tilbyder maksimal fleksibilitet, er et klippekort fra 4D Konsulenterne en god løsning. Klippekortet kan bruges af alle medarbejdere i virksomheden.
» Få mere information – helt uforpligtende!
Udfyld en interesseforespørgsel nederst på denne side.
Vis alle uddannelser afholdt hos
4D Konsulenterne
Forespørgsel efter information
Kontaktinformation til 4D Konsulenterne
Telefon: +45 3314 7144 
Bestil information
For at bestille information om Access 2010 Basic (conducted in English), venligst indtast følgende oplysninger:
Giv din anmeldelse
