Kumpulan Materi Lengkap Microsoft Access

	1. Create and Manage Databases
		To create a desktop database To create an Access web app  insert a blank form as an application part  Using Quick Start elements Using earlier Access file formats
		Create and Remove Primary Keys Create and modify a relationship
		Working with Access views and Finding records Configuring the Navigation pane Building navigation forms
		Compact and repair the current database Encrypt and remove a database with a password Backup and restore a database object from a backup How to Split and Merge Database
		Print a report and selected records  Export, saved and run data from Access Save a database as a template and different format  Package and sign a database  Create an executable-only database
	2. Build Tables
		Create a Table in Design view Import data from Excel into a new table Import Data From Another Access database Import data from a text file into a new table Link to a table in another Access database Link to a text file To link to an Excel worksheet or named range Manage linked tables
		Hide and unhide fields Freeze and unfreeze fields Change a field’s data format in Datasheet view Add a Total row to a table Add a description and set other table properties Add total row and rename a table
		Work with records in Datasheet view Append and find records to a table in the current database Set up and apply an advanced sort Create filter and advanced filter Use a query as a filter and save a filter as a query Add,rename,delete a field in datasheet view and insert, define custom data type application part