Microsoft Access 2010: 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 both input of and extraction of data in either straightforward tabular formats or through the use of input forms and printable reports to set out information in a structured format. The content of this course is designed for users of Microsoft Access 2010 although the principles of database use can be applied to other versions of Microsoft Access
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 2010: Designing and Creating Your Database, Microsoft Access 2010: Working with Information in Your Database and Microsoft Access 2010: Creating Input Screens and Printing Reports) which are 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
You should be familiar with the Microsoft Office 2010 interface and the use of a mouse and keyboard and ideally you will have already have used other Microsoft Office applications like Word or Excel. It is also desirable to have a current need to create and use a database as you will learn more from this course if you are able to put into practice the skills learnt as you consider the design of your own database.
6 x half-day (3 hours) sessions - length of course 18 hours.
£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.