2_DB_development_presentation_l4_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

A report is a formatted printout (or screen display) of the contents of one or more tables in a database
The Report tool places all the fields from a selected table or query

Open the report in any view, or select the report in the Navigation Pane
To print the report with the default print settings, click the File tab to display Backstage view, click the Print tab, and then click Quick Print
or
To display the Print dialog box and select the options you want for printing the report, click the File tab, click the Print tab, and then click Print (or, if the report is displayed in Print Preview, click the Print button in the Print group on the Print Preview tab)

Compacting a database rearranges the data and objects in a database to decrease its file size

Make sure the database file you want to compact and repair is open
Click the File tab to display Backstage view
Make sure the Info tab is selected in the navigation bar
Click the Compact & Repair Database button

Backing up a database is the process of making a copy of the database file to protect your database against loss or damage
The Back Up Database command enables you to back up your database file from within the Access program, while you are working on your database