Details
This course is an introduction to Microsoft Access 2016 and is designed for learners who have not previously used Access and might be unfamiliar with database software in general. It introduces delegates to the basic concepts of a relational database system as well as some of the things that are possible with Microsoft Access, including creating database systems, entering and deleting data in database files, producing information in forms and reports and generating queries.
COURSE DESCRIPTION
This Microsoft Access 2016 Beginner course is designed for learners who have not previously used Access and might be unfamiliar with database software in general. It introduces learners to the basic concepts of a relational database system as well as some features that are possible with Microsoft Access, including creating database systems, entering and deleting data in database files, producing information in forms and reports and generating queries. This is an interactive course, packed with exercises and provides a good foundation on which to continue learning and creating databases with Microsoft Access. Upon completion of the course, delegates will be able to:
- Understand how to use and navigate your way around Access
- Using lookup tables to design databases
- Use Access 2016 to create database structure
- Modify the structure of existing tables and use the attachment data type
- Find and replace data and delete records
- Add records to new tables
- Add transitional records to lookup databases
- Work with records in database tables
- Sort and filter records in table
- Create queries, and sort and filter the results
- Modify queries and perform operations in queries
- Create, modify, and work with forms and use formsto sort and filter records
- Create reports and modify and print reports
Direct delivery via tutor-led training session, offering you interactive training in a small classroom setting. Packed with exercises and hands-on experiences, this course enables you to apply what you have learnt back in the workplace and professionally.
Entry RequirementsThis course assumes that you have little or no knowledge or experience of using the Excel 2016 software. A general understanding of personal computers and the Windows operating system environment would be beneficial.
ProgressionThe natural progression is Access Intermediate.
Duration9:30 am to 4:30 pm
LocationAspyra Training: 46-48 Alfreton Road Nottingham NG7 3NN. Alternatively, Aspyra can also deliver the training in your location or on your own site at a mutually convenient date and time. Offsite rates apply.
Aspyra Training provides a wide range of ICT and online, distance learning training courses from beginner to advanced levels. Courses include ECDL, ECDL Extra, ECDL Advanced, E-type, CCNA Switching and Routing, A+ Certification, MCTS Configuring Microsoft Windows 7, MCTS Windows Server 2008 Administration, MC PRO Windows Server 2008 Network Infrastructure Implementation and Configuration, MCTS Windows Server 2008 Active Directory Implementation and Configuration, Cisco Courses, including CCNA Routing and Switching - all leading to a nationally and internationally recognised qualification.
Our offering also include tutor-lead courses in small classroom settings that include, Microsoft 2007 and Microsoft 2010 courses from Beginner to Advanced Levels in Excel Spreadsheet, Access Database, PowerPoint Presentations, Word Processing as well as Computerised Accounting Courses in Sage 50 Accounts Software, QuickBooks and Sage Payroll.
Our Trainers and Consultants are highly qualified and occupationally competent in their chosen field and provide the relevant support required by our clients. We adopt a flexible approach to the development and delivery of our courses and place our clients at the centre of what we do, thus ensuring that we meet their unique requirements. ...