Microsoft Access Introduction / Intermediate
- Level
- Total time
Microsoft Access Introduction / Intermediate
Provider rating:
Starting dates and places
Aspect Training offers their products as a default in the following regions: Surrey
Description
Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.
On Aspect Training's Microsoft Access Introduction Training Course you will explore database
basics and build tables and reports that corral your data
Access has undergone an extreme makeover! Whether you've used one of the older versions or
this is your first exposure to Access, Aspect Training's Microsoft Access Introduction Training
Course is where you'll find the essentials you need to make this database system work for you.
Cruise around the new interface, team up Access with other Office applications, use wizards to
automate your work, and much more.
Discover how to
* Create a new Access database
* Import and export data
* Build forms for efficient data entry
* Search tables…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.
On Aspect Training's Microsoft Access Introduction Training Course you will explore database
basics and build tables and reports that corral your data
Access has undergone an extreme makeover! Whether you've used one of the older versions or
this is your first exposure to Access, Aspect Training's Microsoft Access Introduction Training
Course is where you'll find the essentials you need to make this database system work for you.
Cruise around the new interface, team up Access with other Office applications, use wizards to
automate your work, and much more.
Discover how to
* Create a new Access database
* Import and export data
* Build forms for efficient data entry
* Search tables for specific data
* Construct custom reports
* Customize your database navigation
Course Topics:
Fundamentals
Basic database concepts
Designing a basic database
Overview of MS Access
Opening an existing database
The Access environment
Access Objects
Editing an Access table
Navigating through a table
Deleting records
Adding new records
Finding and sorting
Creating tables
Creating an Access database
Creating tables in design view
Using the Table Wizard
Setting field attributes
Setting a primary key
Datasheet view
Filtering and sorting
Finding records
Filtering records
Filtering with forms
Sorting records
Working with forms
Overview of forms
Using the Form Wizard
AutoForms
Bound and unbound forms
Data validation
Adding records via a form
Relationships
Relationships overview
Creating relationships
About referential integrity
Queries
Design view queries
Setting criteria
Using the query wizard
Sorting queries
Modifying and updating queries
Querying multiple tables
Creating reports
AutoReports
The Reports Wizard
Formatting a report
Linking reports to queries
Generating groupings
Creating custom headers
Adding your logo
Printing reports
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.