Description of this paper

Loading

Access 2010/2013 Tasks: 1. Run/open Microsoft Access-(Answered)

Description

Instant Solution ? Click "Buy button" to Download the solution File


Question

Attached. Please look at the attached file about the project.


Access 2010/2013

 

Tasks:

 

1. Run/open Microsoft Access 2010/2013.

 

2. Create a new address database.

 

3. Create a new address table in design view.

 

4. Design the fields for the address table.

 

5. Input data into the table.

 

6. Sort the data in the table.

 

7. Make a form for the table using the Form icon on the Create ribbon.

 

8. Make a report for the table using the Report icon on the Create ribbon.

 

9. Exit the Access program.

 

10. Send the file to me as an attachment to an email. Do not use the school email accounts.

 

To start a database you must create the file. First open the database program. You will see the Backstage view

 

(Figure 1)

 


 

Figure 1

 

You must pick a blank database then change the name in the box below ?file name?. Then click on the folder

 

and tell the program where you want to save the file. Finally click on create to start the process.

 

In the navigation window change it to say ?All Access Objects?. Now change the View to Design view to enter

 

the fields. When it asks for a name of the table, use ?Address?.

 

You will have to remove the primary key by clicking the Key icon. Then you can start entering the fields.

 

The description is other changes that can be done to improve the accuracy of the input of data. We will ignore

 

those changes for this assignment. Just enter the Field names and the Data types.

 


 

Field Name

 

LastName

 

FirstName

 

Address

 

City

 

State

 


 

Data

 

Type

 

Text

 

Text

 

Text

 

Text

 

Text

 


 

ZipCode

 


 

Text

 


 

AreaCode

 


 

Text

 


 

PhoneNumber Text

 


 

Description

 

Change field size

 

Change field size

 

Change field size

 

Change field size

 

Change field size and force two capital letters

 

Change field size and force five digits, a dash, and an optional 4

 

digits

 

Change field size and make the program enter in the parenthesis and

 

force three digits only.

 

Change field size and make the program enter in the dash and force

 

seven digits only.

 


 

After completing the input of the field names and data types, change to the Datasheet view to enter data. Enter

 

the first record in the datasheet and close the table, by right clicking on the tab and selecting close. Always save

 

if asked.

 


 

Data

 

LastName FirstName Address

 

1234 Ming

 

Smith

 

John

 

Avenue

 

1322 El Rancho

 

Johnson

 

Michael

 

Dr.

 

Alberts

 

Marsha

 

123 A St.

 

Marks

 

Ellen

 

145 Harbor St.

 

Cox

 

Fred

 

145 Lucky Lane

 

151 Panorama

 

Williams Mary

 

Dr.

 

Smith

 

Peter

 

415 Easy St.

 


 

City

 


 

State ZipCode AreaCode PhoneNumber

 


 

Bakersfield CA

 


 

93303

 


 

661 832-1234

 


 

Bakersfield

 

Fresno

 

Anytown

 

Reno

 


 

CA

 

CA

 

NV

 

NV

 


 

93303

 

93325

 

85364

 

85323

 


 

661

 

209

 

604

 

604

 


 

Bakersfield CA

 

Eloy

 

NV

 


 

93305

 

85341

 


 

661 395-4975

 

604 958-3822

 


 

832-1111

 

942-1239

 

123-9876

 

582-3967

 


 

Highlight (select) the table, in the navigation pane. The make a form by using the create ribbon and select form.

 


 

Right-click the tab and change the view to Form (it opens in Form Layout view). Then enter the rest of the data

 

into the form.

 


 

You can get the new/blank form with the Page Down key or the navigation arrows at the bottom on the screen.

 

Enter your last name and first name in the appropriate fields.

 

After entering all of the data, close the form and open the datasheet table. All data should be shown.

 


 

To sort the table on the last name, select any name in the LastName field and select ascending sort in the Home

 

ribbon. To sort on the LastName and FirstName, select the names from any record in both fields, then select

 

ascending sort in the Home ribbon. Close the table and save the changes.

 


 

To make a report, highlight the table and use the Create ribbon to select the Report. To resize the columns,

 

select the column and use the two-headed arrow to drag the right side of each column to make it the correct size.

 


 

After sizing the columns, close the report and save with the name Address.

 

Highlight the report Address and go to File, Print, and Print Preview to see what a printout will look like. It

 

should be on one page in portrait view.

 


 

 

Paper#9209312 | Written in 27-Jul-2016

Price : $19
SiteLock