Course description
Basic Microsoft Access
Being confident in Microsoft Basic Access functions is essential for anyone who prepares and want to store data. This course is for anybody wanting to learn Basic Microsoft Access and looks at 365 but also looks at previous versions, of 2016, 2013, 2010 or 2007, as it covers all the aspects and differences between the versions. It helps participants gain the knowledge to ensure that they are able to maximise the full use of MS Access.
To ensure success, participants should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable in the Windows® environment and be able to use Windows to manage information on their computers. Specific tasks the participants should be able to perform include launching and closing applications, navigating basic file structures, and managing files and folders
Upcoming start dates
Suitability - Who should attend?
Who should attend?
Anybody wanting to learn Basic Microsoft Access functions
Outcome / Qualification etc.
By the end of the course, participants will be able to:
- Understand basic functions of Microsoft Access
Training Course Content
- Introduction
- Getting Started
- Ribbons
- What is Access?
- Basic Database Structure
- Using A Database
- Creating Your First Table
- Planning Your Database Fields
- Defining Your Fields in Design View
- The Datasheet View
- Primary, Secondary & Multiple Keys
- Entering Data to Create Fields
- Data Types
- Deleting Fields
- Entering Data
- Using the Attachment Data Type
- Sorting, Finding & Filtering Data
- Find & Replace Data & Filter Data
- Filtering
- The Home Ribbon
- Totals
- Queries
- Entering the Criteria
- Multiple Criteria
- Boolean Expressions & Queries
- The AND Operator
- The OR Operator
- The NOT Operator
- Using Wildcards & Other Special Characters in a Query
- Creating Forms
- Re-designing the Form
- Adding Records in Form View
- Creating Reports
- Conditional Formatting
Expenses
Course Price:£180 + VAT
Request info
Oakley Services UK Ltd
Since its founding in 2007, Oakley Services UK Ltd trading as Oakley Training and Consultancy provides efficient, engaging, and practical training and consultancy covering a wide range of popular business needs. Hosted from our Head Office and dedicated training facility...