Microsoft Access 2007 - Beginners
Short course
In Nottingham
Description
-
Type
Short course
-
Level
Beginner
-
Location
-
Class hours
6h
-
Duration
1 Day
Suitable for: This course is designed for people with little or no experience with Microsoft Access. Some knowledge of the Microsoft environment will help but is not essential.
Facilities
Location
Start date
Start date
Start date
About this course
This is a beginner - Intermediate course and therefore no prior experience is necessary.
Reviews
Subjects
- Access
- Access for Beginners
- Access Beginner - Intermediate
- Database
- Database Design
- Database Marketing
- Database training
- MS Access
- MS Access 2007
- Microsoft Access 2007
- Microsoft Access 2007 for Beginners
- Microsoft Access 2007 Beginner - Intermediaet
- Microsoft Office
- Designing Database
- Creating Tables
- Running Queries
- Reports
Teachers and trainers (1)
Mandy Jones
ICT Trainer
Qualified and Experienced ICT trainer who brings significant knowledge, skills and experience in the use of Microsoft Office Applications from Beginner to Advanced Levels. Mandy supports learners in a professional and relaxed manner, through a range of practical exercises, enabling them to develop their knowledge and skills in ways that enable them to apply what they have learnt in the workplace.
Course programme
Microsoft Access for Beginners introduces you to the creation of a Microsoft Access 2007 database and understanding how relational databases work. The training demonstrates how to organise data into tables while using queries and filters to access specific data information.
Upon completion the delegate will be able to:
- Open, save & close Access databases
- Use the Access help system & the Office Assistant
- Enter, edit & delete information using tables & forms
- Create tables, forms & reports using wizards & Design View
- Modify Access database objects using Design View
- Sort & filter information held in an Access database
- Create select queries to extract & sort information
- Preview & print Access database objects
Additional information
•Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
•Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
•Modify a table’s design; use the attachment data type; find and replace data; sort, filter, and delete records.
•Set field properties, create input masks, and set validation rules.
•Create queries, and sort and filter the results; modify queries; and perform operations in queries.
•Creat
Microsoft Access 2007 - Beginners