Поделиться
2_DB_development_presentation_l3_v1.pptx
Access Tutorial 1 Creating a Database
Objectives
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
New Perspectives on Microsoft Access 2010
2
Objectives
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
New Perspectives on Microsoft Access 2010
3
The Create Tab Options
New Perspectives on Microsoft Access 2010
4
Opening a Database
Start Access. If necessary, click the File tab to display Backstage view
Click the Open command in the navigation bar to display the Open dialog box
Navigate to the database file you want to open, and then click the file
Click the Open button
New Perspectives on Microsoft Access 2010
5
Opening a Database
New Perspectives on Microsoft Access 2010
6
Navigating a Datasheet
The navigation buttons provide another way to move vertically through the records
New Perspectives on Microsoft Access 2010
7
Creating a Simple Query
A query is a question you ask about the data stored in a database
The Simple Query Wizard allows you to select records and fields quickly
New Perspectives on Microsoft Access 2010
8
Creating a Simple Form
A form is an object you use to enter, edit, and view records in a database
You can design your own forms, use the Form Wizard, or use the Form tool to create a simple form quickly and easily
New Perspectives on Microsoft Access 2010
9
Creating a Simple Form
New Perspectives on Microsoft Access 2010
10
Материалы на данной страницы взяты из открытых источников либо размещены пользователем в соответствии с договором-офертой сайта. Вы можете сообщить о нарушении.
