MS Access Level 4
Course Description
Level 4 is for students who have a thorough understanding of the basic and advanced user features of the Access database programme, and are interested in learning introductory level administrator skillsets. The course is also for the student who is working in a web-based environment and who may need to adapt Access applications to the environmentDuration: 1 day
Making data available on the Web
Create a Data Access Page using a wizard Improve Data Access Page presentationViewing Data Access Pages with a browser
Edit data using a Data Access Page
Group records in a Data Access Page
Developing a Data Access Page
Create a Data Access Page in design viewAdding a ComboBox to a Data Access Page
Testing a Data Access Page
Create a PivotTable
Develop a PivotChart
Sharing Access data
Import XML data into an Access databaseExport Access data to XML format
Share data with other Office applications
VBA
Create a Standard ModuleDeveloping code
Calling a procedure from a form
Running a procedure
Switchboards and Startup Options
Create a Database SwitchboardModify a Database Switchborad
Set the Startup options
Modify the Startup options
Distributing a database
Splitting a databaseImplementing security
Setting passwords
Encoding and decoding a database
Convert an Access database to an MDE