Microsoft Access
Duration: 1 day
Next Course :
TBA enquire here
Cost: £150 ex VAT
concessions available
Times: 10am - 5pm
At the end of this course you will have a good working knowledge of Access basics. You will be more confident using Access. You will be able to create a database from scratch. You will Understand how to use tables, fields and records, create simple queries, use forms and, ultimately create reports.
Suitable for:
Our Microsoft Access course is suitable for complete beginners to Microsoft Access.
Prerequisites:
- A basic understanding of the windows environment.
- A basic level of numeracy and literacy is required.
Book a course now by calling 0845 686 2888 or complete the online enquiries form
Course outline:
Database Concepts
- Database concepts and terminology
- Exploring the Access environment
- Planning and designing databases
- Closing a database and Access
Access Basics
- Exploring tables
- Examining queries
- Exploring reports
Creating Databases
- Creating a database
- Using the table wizard
- Working in design view
Working with Fields and Records
- Changing the design of a table
- Adding and deleting records
- Finding and editing records
- Sorting and filtering records Querying Tables
- Creating and using queries
- Modifying query results and queries
- Using calculations in queries
Creating and Using Forms
- Creating forms by using AutoForm
- Using the form wizard
- Using design view
- Finding, sorting and filtering records
Creating and Using Reports
- Using the report wizard and queries
- Creating, modifying and printing reports
Importing, Exporting and Linking Objects
- Importing Access objects
- Exporting Access objects
- Linking Access objects
Creating relational databases
- Database normalising
- Introducing relating tables
- Adding referential integrity
Book a course now by calling 0845 686 2888 or complete the online enquiries form
