Centre for Continuing Education

Microsoft Access Course: Level 1

Microsoft Access. Create databases fast without being a developer.

Learn Microsoft Access the smart way with Microsoft Access courses at CCE, the University of Sydney.

Aims

This Microsoft Access training course will provide you with the skills and knowledge sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

Outcomes

Upon completion of this Microsoft Access training course, you should be able to:

  1. Understand how Access is used and how to navigate around it.
  2. Design a database with lookup tables.
  3. Create a database structure using Access.
  4. Modify the structure of an existing table.
  5. Add records to a new table.
  6. Add transactional records to a lookup database.
  7. Work with the records in a database table.
  8. Sort and filter records in a table.
  9. Create simple and effective queries.
  10. Create meaningful reports from tables.
  11. Create and use forms.

Content

This Microsoft Access training course covers the following topics:

Microsoft Access orientation

  • Understanding Microsoft Access.
  • Starting Access.
  • Understanding The Start Screen.
  • Creating A New Blank Database.
  • Understanding The Backstage View.
  • Opening An Existing Database File.
  • Understanding The Access Screen.
  • Using The Ribbon.
  • Working With The Navigation Pane.
  • Adding Commands To The QAT.
  • Working With Touch Mode.
  • Working With A Table.
  • Working With Other Database Objects.
  • Closing A Database File.
  • Exiting From Access.

Designing a lookup database

  • Understanding How Access Stores Data.
  • Understanding Access Data Types.
  • Scoping Your New Database.
  • Identifying Table Problems.
  • Refining Table Structures.
  • Finalising The Design.

Creating a lookup database

  • Creating A New Database File.
  • Creating The Lookup Table.
  • Defining The Primary Key.
  • Saving And Closing A Table.
  • Creating The Transaction Table.
  • Understanding Lookup Table Relationships.
  • Connecting To A Lookup Table.
  • Viewing Table Relationships.

Modifying table structures

  • Opening An Existing Table.
  • Adding Fields To An Existing Table.
  • Understanding Field Properties.
  • Changing Field Size.
  • Changing Field Names.
  • Changing Decimal Places.
  • Changing Date Formats.
  • Indexing Fields.
  • Deleting Fields From A Table.
  • Copying A Table Within A Database.
  • Deleting A Table From A Database File.

Adding records to a table

  • Typing Records In A Table.
  • Adding Records Using A Form.
  • Saving A Form Layout For Reuse.
  • Adding Records Using An Existing Form.
  • Assignment: Adding Records.
  • Importing From Microsoft Excel.

Adding transactional records

  • Typing Transactional Records.
  • Adding Transactional Records Using A Form.
  • Assignment: Adding Transactional Records.
  • Adding Records Using A Subdatasheet.
  • Removing A Subdatasheet.
  • Inserting A Subdatasheet.

Working with records

  • Table Navigation.
  • Navigating To A Specific Record.
  • Editing A Record.
  • Deleting Record Data.
  • Undoing A Change.
  • Deleting A Record.
  • Deleting Several Records.
  • Searching In A Table.
  • Searching In A Field.
  • Finding And Replacing.
  • Printing Records From A Table.
  • Compacting A Database.

Sorting and filtering

  • Simple Sorting.
  • Sorting On Several Fields.
  • Simple Filtering.
  • Working With Filters.
  • Filtering Between Dates.

Creating queries

  • Understanding Queries.
  • Creating A Query Design.
  • Working With A Query.
  • Changing A Query Design.
  • Applying Record Criteria.
  • Clearing Selection Criteria.
  • Saving A Query.
  • Running Queries From The Navigation Pane.
  • Deleting A Query.
  • Assignment: Creating Queries.

Creating and using reports

  • Understanding Reporting In Access.
  • Creating A Basic Report.
  • Working With Existing Reports.
  • Previewing And Printing A Report.
  • Changing The Report Layout.
  • Using The Report Wizard.
  • Creating A Grouped Report.
  • Creating A Statistical Report.
  • Working With Grouped Reports.

Creating and using forms

  • Understanding Forms.
  • Creating A Basic Form.
  • Creating A Split Form.
  • Binding A Form To A Query.
  • Using The Form Wizard.
  • Working With Existing Forms.
  • Editing Records In A Form.
  • Deleting Records Through A Form.
  • Deleting An Unwanted Form.

Delivery Style

This Microsoft Access training course is delivered as presenter-taught computer-based training in a Microsoft Windows environment.

Intended Audience

This Microsoft Access training course assumes little or no knowledge of the software.

You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending Basic Computer Skills Course and Effective Internet Use before attempting this course.

Features

  • Free repeat class - Conditions apply
  • Free USB flash drive
  • Expert trainer
  • Dedicated computer for every student
  • Small class size
  • Student notes – yours to keep
  • Statement of completion

What others say.

  • Tutor was very capable and engaging, explaining everything very clearly. It went at a good pace and the tutor was always happy to assist when asked. Equipment was good and catering was good too. Thank you.

  • This tutor was very, very, very good at making a dry topic engaging. The communication and subject matter understanding is top notch.

  • This is the third one-day CCE course I’ve done in two years, and I have always gained a huge amount of information that I can use straight away and a great resource book to refer back to.

  • The Tutor was excellent – knowledgeable, skilled and able to impart knowledge in an easy to understand way, and never hurried, always helpful. And by the way, the sandwiches were absolutely top class. Highly recommended.

  • Great session. Tutor was happy to answer all questions. Very useful to go back to the business with this new knowledge.

  • As a mature aged student I approached the course with some trepidation. My fear was geek speak and the acronyms and jargon in IT is without a doubt intimidating to a Luddite like me. But what a surprise. The tutor was articulate in the delivery, treating all as equals and the language was simple plain English. I came away from the course enlightened, relieved and keen to progress to the next level. I would highly recommend this course to anyone and in fact I am enrolling both my son and daughter into this course and I have also enrolled into Level 2 and signed up for Excel Level 1 as my unfounded fear factor has dissipated.

  • I came away from this course feeling confident and inspired in what I had learnt.

  • The course was set at a steady pace for the entire class to keep up. The tutor was engaging and provided thorough explanations.

  • Excellent instructor, great venue, relevant and desired content. Overall, good value. Thank you!

  • The tutor was very clear and concise. I found I could follow the instructions easily and the class went at a good pace.

  • Excellent educator providing clear instructions and explanations which are definitely required for a computing course.

  • This course gave me the knowledge and skills that I need to get started using Microsoft Access, and was well-structured and very well delivered.

  • The course is very time-efficient in that it provides a lot of information in a short time. This is very useful for me as I am busy and have very limited time for doing such courses. Much apprciated.

  • The day was run very well, I felt the course covered all the basic information required. The tutor ran the class really well with all questions answered. the service was very good, thank you.

  • It was a great day with good learning experience. We had an excellent teacher who was very helpful. Although there is always more to learn, in my opinion, the course met expectations. Love the special parking rate of $10.00/day. Will recommend the course to the others.

  • I thoroughly enjoyed this course. The pace, content and the tutor were very enjoyable. Highly recommend the course to anyone.

  • My experience with the University of Sydney Centre for Continuing Education was a very pleasant, informative and great experience overall. I have already recommended this place to family, friends and fellow colleagues.

  • I was feeling a bit nervous about this course as I have had bad experiences with computer courses in the past but the tutor made the course enjoyable and easy to follow.

  • Great presenter. The tutor really went the extra mile to tailor the course to our needs and answer all our specific questions. Thanks so much. Was invaluable. I will be signing up for MS Access Level 2 course!

$357 Limited GST free
Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Heading - Aims”}</p><p>This Microsoft Access training course will provide you with the skills and knowledge sufficient to

...
$357 Limited GST free
Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Heading - Aims”}</p><p>This Microsoft Access training course will provide you with the skills and knowledge sufficient to

...
$357 Limited GST free
Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Heading - Aims”}</p><p>This Microsoft Access training course will provide you with the skills and knowledge sufficient to

...
$357 Limited GST free
Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Heading - Aims”}</p><p>This Microsoft Access training course will provide you with the skills and knowledge sufficient to

...
$357 Limited GST free
Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Heading - Aims”}</p><p>This Microsoft Access training course will provide you with the skills and knowledge sufficient to

...
$357 Limited GST free
Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Heading - Aims”}</p><p>This Microsoft Access training course will provide you with the skills and knowledge sufficient to

...
$357 Limited GST free
Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Heading - Aims”}</p><p>This Microsoft Access training course will provide you with the skills and knowledge sufficient to

...
If there isn't a class to suit you, please join the waiting list.