Access 2010: Creating a Simple Database

BeginnersPrerequisites

This is an introduction to the popular database package Microsoft Access 2010. The course is aimed at those who have never used the package before or have just started using it. There is an Access Fast Track course that is a shortened version of this course for those who learn at a faster pace.

• All current University members (departments and colleges)
• Further details regarding eligibility criteria are available

Participants are expected to have basic computing skills (as covered on the Windows Introduction).

Number of sessions: 2

• Creating a database
• Creating a table
• Creating a basic form
• Creating queries
• Creating a basic report
• Importing and exporting information

Presentations, demonstrations and practicals.

Access 2010 on MCS Windows

• Anyone wishing to copy the course exercise files should bring a USB memory stick or they can be downloaded
• The concepts and design of relational databases are only briefly covered at this level, you will need to attend the Further Use course for a more detailed overview

Two sessions of three hours

• Access 2016: Fast Track Introduction
• Access 2016: Further Use
• MySQL: Implementing a Relational Database Design
• Relational Database Design (In Person Face to Face)