Level 1 Microsoft Access
-
Truly appreciative for the magnificent preparing. In spite of the fact that I have just been back at my work area for a day or two, the tips and insights educated have spared me so much time as of now. I have utilized the fundamentals a great deal more than I ever suspected I would. I am a great deal more sure and would even go so far as to state that I really am no longer plagued by the entire spreadsheet issue.
← | →
-
A very much organized course that was conveyed with adaptability to guarantee pertinence to genuine work.
← | →
Course
In Royal Leamington Spa
Learn Microsoft Access essentials with this course!
-
Type
Course
-
Location
Royal leamington spa
-
Duration
2 Days
-
Start date
Different dates available
To provide the delegates with the knowledge and understanding of some of the design features and facilities within
Access. By the end of the course delegates will have an appreciation of the necessary steps required to build a relational
database and be able to extract information.
Facilities
Location
Start date
Start date
About this course
Users with no existing knowledge of Access and new or recent users of Access who want to gain a better understanding of the package.
Ability to use the keyboard and mouse.
An understanding of Windows.
Reviews
-
Truly appreciative for the magnificent preparing. In spite of the fact that I have just been back at my work area for a day or two, the tips and insights educated have spared me so much time as of now. I have utilized the fundamentals a great deal more than I ever suspected I would. I am a great deal more sure and would even go so far as to state that I really am no longer plagued by the entire spreadsheet issue.
← | →
-
A very much organized course that was conveyed with adaptability to guarantee pertinence to genuine work.
← | →
Course rating
Recommended
Centre rating
Former student
Former student
Subjects
- Powerpoint
- Access
- Database Design
- Database
- SQL
- Database training
- Computer Engineering
- Design
- IT Security
- Microsoft Access
- SQL Server
- Queries
- IT Systems
- Computer Science
- Office systems
- IT
- Access 2013
- Computering
- Microsoft
- Mirosoft Access
- Advanced Access
Course programme
Course content
Introduction to Access
Working with Databases• Creating a new database• The database window• Opening and closing databases• Identifying and manipulating Access objects
Creating and Working with Access Tables• Creating and modifying tables• Working with field property options• Setting a primary key• Saving, closing and opening tables• Navigating around a table• Selecting techniques• Adding data records to a table• Editing and saving records• Importing and attaching data• Finding and replacing data• Deleting, moving and copying records• Formatting tables
Working with Relationships• Types of relationships• Enforcing referential integrity• Creating and saving relationships• Editing and deleting relationshipsCreating and Working with Forms• Creating and designing forms• Selecting techniques used with forms• Adding, moving and resizing controls• Formatting controls• Changing the properties of controls
Sorting, Filtering and Creating Queries• Sorting data in to a specific order• Specifying criteria• Filtering data to extract records• Creating a query to extract records• Creating calculated fields in a query• Summarising using queries• Working with action queries
Creating and Working with Reports• Creating reports using the wizards• Creating and modifying reports in design view• Sorting and grouping in a report• Adding calculated and summary fields
Level 1 Microsoft Access