Access Project 1

1
Access Project 1

• Creating and Using a Database

2
Creating a New Database

• Click the New button
• Displays the task pane
• Click the Blank Database option in the task pane
• Click the Save in box arrow

3
Creating a New Database

• Enter a File name
• Click the Create button to create the database

4
Creating a New Database
5
Creating a Table

• Click the New button
• Click Design View
• Click the OK button

6
Creating a Table
7
Defining the Fields in a Table

• Type the name of the first field
• Choose a data type
• Type a description
• Choose a field as the primary field
• Click the Primary Key button

8
Defining the Fields in a Table

• Press the F6 key
• Advances into field properties
• Enter a fields size
• Indicate if field is required

9
Closing and Saving a Table

• Click the Close Window button for Table1
• Click the Yes button in the dialog box, and then
  type a name for the table

10
As Example of Closing and Saving a Table
11
Adding Records to a Table

• Right-click the Client table in the Database
  window
• Click Open on the shortcut menu
• Enter the data

12
An Example of Adding Records to a Table
13
Closing a Table

• Click the Close Window button for the Table window

14
Adding Additional Records to a Table

• Open the table
• Click the New Record button
• Add the remaining records
• Click the Close Window button

15
Previewing the Contents of a Table

• Right-click the Client table
• Click Print Preview on the shortcut menu

16
Printing the Contents of a Table

• Click the Setup button on the Print Preview
  toolbar
• Click the Page tab
• Click Landscape, and then the OK button
• Click the Print button to print the report

17
Using the Simple Query Wizard to Create a Query

• With the Tables object selected and the Client
  table selected,
• Click the New Object button arrow on the Database
  toolbar
• Click Query on the New Object list

18
Using the Simple Query Wizard to Create a Query

• Click Simple Query Wizard
• Click the OK button
• Click the Add Field button to add the field(s)

19
Using the Simple Query Wizard to Create a Query

• Click the Next button
• Enter a name for the query
• Click the Finish button

20
Using a Query

• If necessary, click the Queries object
• Right-click the Query name
• Click Design View on the shortcut menu
• Enter a Criterion

21
Using a Query

• Click the Run button on the Query Design toolbar

22
Using the New Object Button to Create a Form

• Select Form under the objects column
• Through the New button
• Select the table
• Click AutoForm columnar on the New Object list

23
An Example of a Form
24
Closing and Saving a Form

• Click the Close Window button
• Click the Yes button
• Click the OK button

25
Opening a Form

• Click Forms on the Objects bar, in the Database
  window
• Right click the forms name, and open

26
An Example of An Open Form
27
Navigating Through a Form

• Use the navigation buttons

28
Switching From Form View to Datasheet View

• Click the View button arrow on the Form View
  toolbar
• Click Datasheet View

29
Creating a Report

• Select Report under the objects column
• Click the New button
• Select a table
• Click Report

30
Creating a Report (cont)

• Click Report Wizard
• Click the Add Field button to add fields

31
An Example of a Report
32
Closing a Database

• Click the Close Window button for the Database
  window

33
Quitting Access

• Click the Close button in the Microsoft Access
  window