Who is this course for?
As a new user, with little or no experience of Microsoft Access, the topics covered on this course introduce you to the main concepts involved in creating and maintaining a simple relational database.
An overview of the power and benefits of computer databases.
Tour of the Access initial screen.
The Ribbon and other toolbars.
Data Entry & Editing
Adding and editing records.
Navigation through data.
Finding specific records.
Sorting and filtering data.
Setting field attributes.
Importing from Excel.
What they are and why relational databases are useful.
How data stored in different tables can be related.
Using SELECT Queries to build new record sets.
Sorting and basic filtering.
Deriving new information in queries.
Combining data from different tables through a query.
Creating forms with and without the Access Forms Wizard.
Using queries and tables as the basis for forms.
Introducing object properties within forms to change data and display characteristics.
Creating simple reports with and without the Access Reports Wizard.
Introducing object properties within reports to change report definitions.
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
Outcome / Qualification etc.
Nationwide Software Training
Vantage Training formed as a limited company back in 1995, although the two directors, Gill Lewis and Brian Roberts, had been working together for some years at this point. By the time vtl was formed, long term contracts had been...
There are no reviews available yet.
Are you curious about the L&D strategies of some of the U.K.'s top companies?
Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!