2_DB_development_presentation_l2_v1

Learn basic database concepts and terms
Explore the Microsoft Access window and Backstage view
Create a blank database
Create and save a table in Datasheet view
Enter field names and records in a table datasheet
Open a table using the Navigation Pane

Open an Access database
Copy and paste records from another Access database
Navigate a table datasheet
Create and navigate a simple query
Create and navigate a simple form
Create, preview, navigate, and print a simple report
Learn how to compact, back up, and restore a database

Click the Create tab on the Ribbon
In the Tables group, click the Table button.
Accept the default ID primary key field with the AutoNumber data type, or rename the field and change its data type, if necessary.
In the Add & Delete group on the Fields tab, click the button for the type of field you want to add to the table (for example, click the Text button), and then type the field name. Repeat this step to add all the necessary fields to the table

In the first row below the field names, enter the value for each field in the first record, pressing the tab or Enter key to move to the next field
After entering the value for the last field in the first record, press the Tab or Enter key to move to the next row, and then enter the values for the next record. Continue this process until you have entered all the records for the table
Click the Save button on the Quick Access Toolbar, enter a name for the table, and then click the OK button