Access 2016

Do you have an idea for a database to help your team work more efficiently? With Access, you don’t have to be a developer to implement it.

Take advantage of your data with the power of Access—without writing code or becoming a database expert:

• Use templates to build databases quickly.

• Easily find and report on data stored in Access.

• Create rich data entry forms.

• Import, transform, and export a variety of data sources.

Create a primary key to associate data between multiple tables.

1. In the Navigation Pane, right click a table, and select Design View.

2. Select the field or fields you want to use as the primary key.

3. Select Design > Primary Key.

1. Select File > Save As.

2. Under Database File Types, select Save Database As.

3. Under Advanced, select Back Up Database and then select Save As and Save

The default file name includes the source database and when the backup occurred.

Create a select query

Create a query to focus on specific data.

1. Select Create > Query Wizard .

2. Select Simple Query, and then OK.

3. Select the table that contains the field, add the Available Fields you want to Selected Fields, and select Next.

4. Choose whether you want to open the query in Datasheet view or modify the query in Design view, and then select Finish.

Create a split form

A split form gives you two views of the data at the same time — a Datasheet view and a Form view. For example, use the Datasheet view to find a record and the Form view to edit it.

1. In the Navigation Pane, select a table or query that contains the data.

2. Select Create > More Forms > Split Form.

Create a report

1. Select Create > Report Wizard.

2. Select a table or query, double-click each field in Available Fields you want to add it to the report, and select Next.

3. Double-click the field you want to group by, and select Next.

4. Complete the rest of the wizard screens, and select Finish.

1. Get started with databases
2. Get to know database objects
3. Desktop database or web app?
4. Create an Access desktop database
5. Create an Access web app

1. Build tables and set data types
2. Build tables with Table Designer
3. Combine fields using the Calculated data type

1. Get started with table relationships
2. Create relationships with the Lookup Wizard
3. Create relationships with the Relationships Pane
4. Create many-to-many relationships
5. Create one-to-one relationships

1. Copy data from Excel
2. Link to shared data

1. Get started with queries
2. Create basic queries
3. Creat queries with more than one data source
4. Create queries with outer joins
5. Query unrelated data sources

1. Create navigations forms
2. Create basic reports
3. Modify and print reports

Email: vanessa.arredondo@gccisd.net
Location: 5950 North Main Street, Baytown, TX, USA
Phone: (281) 707-3338