Microsoft Access: Comprehensive
Databases are commonly used for storing and searching through large amounts of information held on computer systems. Microsoft Access provides a simple interface allowing you to both input and extract data using either straightforward tabular formats or you can create your own input forms as well as reports to print out information in a structured format.
Topics Covered
Whilst Microsoft Access is easy to use to both input and find information, it is imperative that you fully understand how information is held in a relational database which will then allow you to work efficiently with your information. This fully comprehensive course, based on Microsoft Official Academic Course materials, takes you from the fundamentals of creating a table and entering information to the point where you will be able to extract the relevant subsets of information required from either a single table or from multiple related tables and present your results as a suitably formatted report.
Normally set out as three full days, this course offers a complete overview of the topics taught on the individual Microsoft Access courses (Microsoft Access: Designing and Creating Your Database, Microsoft Access: Working with Information in Your Database and Microsoft Access: Creating Input Screens and Printing Reports) which are also offered individually as part of our scheduled programme.
However, with the continuity of a longer course, you will have time to think about what is required from your own databases as the course examples and topics are taught. Please note that you may attend the individual day sessions but we would only expect existing users of Microsoft Access who are trying to top-up their skills in specific areas to take this route. Anyone who is new to using this application is encouraged to think about the option of the comprehensive course so that you gain a full understanding of what can be done with your databases.
By the end of this course you will:
- understand how a relational database can be constructed to hold your data in the most appropriate format for analysis with Microsoft Access
- be able to create tables and establish appropriate links between them
- know how queries can be used to extract relevant subsets of information from one or more tables
- be able to use screen forms to input data into a relational database
- be able to create and customise paper-based reports for clear output of information held in one or more tables
Additional content is provided in the course training materials to correspond fully to the objectives specified for the Microsoft Office Access Specialist examination.
The topics taught closely match the learning objectives specified for Module 5 (Databases) of the ECDL syllabus.
Prerequisites
You must be familiar with the Microsoft Office interface and the mouse and keyboard. Ideally you will have already have used other Office applications like Microsoft Word or Excel and have a need to create a database as you will then be able to consider this against the course content.
Course Duration
6 x half-day (3 hours) sessions - length of course 18 hours.
Cost
£250 for members of staff and students of Cardiff University.
£340 for non-profit making organisations, e.g. other universities, charities, and government bodies, including Cardiff and Vale University Health Board.
£415 for commercial organisations (profit-making) wishing to book anyone onto this course.