YOUR CART
- No products in the cart.
Subtotal:
€0
Overview
This course starts you at the beginning of Access. It will guide new Access
users through the powerful Microsoft Access program. You will gain a fast,
practical and extensive knowledge of the powerful features of this package,
explaining the structure, design and capabilities of databases
Course Objectives
If you're new to Microsoft Access or want to use Access more effectively, you’ll need to
understand all the features it has to offer. This course will provide you with all the tools you
will need to be more efficient in Access and get the most from this powerful database
management application.
See also
Other Office applications Word, Excel, PowerPoint, and Access Advanced outlines for further
ways to continue your learning path
Content
Tables
- Opening the Access Application
- Create a blank access database
- Create a table using design view
- Create field names and assign data types
- Use the primary key
- Modify table properties
- Add, delete, edit records in datasheet view
- Sort and filter records in datasheet view
Queries
- Create a query in design view based on a table
- Add and remove fields from an existing query
- Use OR and AND queries
- Use wildcards and operators in a query
- Sort a query
Forms
- Create a form based on a table using the wizard
- Change the layout of the form in design view
- Add company logos to the form
- Add text to the form
- Add, delete and edit records in form view
- Delete a form
Reports
- Create a report based on a table using the wizard
- Change the layout of the report in design view
- Modify the title of the report
- Insert a date into the report
- Preview the report
- Delete a report
- Relationships & Excel
- Understand a one-to-many relationship between 2 tables.
- Create a two-table query
- Export a table or query to Excel
You will learn how to
- Understand the basics of database concepts to store data efficiently
- Create and design tables
- Use queries to extract and manipulate data
- Build forms for easy data entry and navigation
- Generate reports to summarize and present data
- Establish relationships between tables to ensure data integrity
- Import and export data from Microsoft Excel
- Customize the Access interface to suit your workflow
- … and much more
Audience
No prior knowledge of Access is
required, some knowledge of excel
maybe useful.
Classroom and Virtual training options
Online Course Materials
Duration
2 Days
More Courses...
Contact us...
Relevant, industry-focused learning and development
Our expert trainers have a wealth of experience in providing corporate training. Whether you pick off-the-shelf professional diplomas or a customised online L&D Program, we provide relevant, engaging content for all employees.
