Microsoft Access Essentials
This introductory course is suitable for complete beginners to Access. It is aimed at anyone who needs to create their own simple database or who is using an existing database a regular basis.
We have broken the course down into 2 half day sessions as we feel that this gives the delegate an opportunity to practice the initial skills and gain confidence before moving on to the second section.
Course duration:
2 x half day sessions
Course Content: Session 1
- Understand what a database is
- Create a new database
- Create a table
- Understand the different types of data field, date, numeric, text
- Add/amend/delete a record to a table
- Print records in table view
- Find, sort and filter data in a table
- Create a simple form
- Enter data using the form view
Course Content: Session 2
- Understand the use of queries
- Create a simple query
- Create a query using multiple criteria
- Print the query
- Create a report using Report Wizard to print data from a table or query
- Make changes to the report using design view
- Consolidation exercise
Description:
This course, broken down into 2 bite size sessions, will give you the skills you need to build a simple Access Database to hold your data. You will also gain skills in creating queries and reports to use your data effectively.
No previous database knowledge is required, although some keyboard skills are desirable.
Call us now on 01403 734431 to book on this course.
