Excellent		0 Reviews
Good		0 Reviews
medium		0 Reviews
Acceptable		0 Reviews
Not Good		0 Reviews

تحميل Access Essential

Programming 2022-03-03

روابط التحميل

لمشاهدة الكورس مباشر بدون تحميل اضغط هنا

عدد الدروس 59

قسم Programming

Building databases with Access

What you should know

Database concepts

Create the database file

Understand the Trust Center

Digging into Ribbon tabs

The database Navigation pane

Customize the Quick Access Toolbar

Create a database backup

Table structures and relationships

Create a table and set data types

Enter data

Primary and foreign keys

Importing tables

Relationships and referential integrity

Editing table structure in Design view

Control input with masks

Set a default value

Data validation rules

Data lookup fields

Additional field properties

Sorting table data

Filtering table data

Deleting records

Searching and replacing values

What are queries

The Simple Query Wizard

Build queries in Design view

Establishing constraints with criteria

Specifying criteria with wildcards

Incorporating AND and OR statements

Filtering with mathematical comparisons

Create flexible queries with parameters

Build expressions

Obtain summary statistics

Understand the role of forms

Generate forms from tables

Adjusting form elements in Layout view

Using the Form Wizard

Form Design view

Find records

Introducing reports

The Report Wizard

Edit a report in Design view

Edit a report in Layout view

Group and sort records

Creating calculated totals

Apply conditional formatting rules

Create labels

Adjust print settings

Customize groups in the Navigation pane

Compact and repair the database

Examine database object relationships

Document your thought process

Print the blueprint of your database

Split a database into front and back ends

Protect the database with a password

Set startup options

Next steps

Programming
2022-03-03